Find Jobs
Hire Freelancers

.NET C# Dapper Simple Crud

$30-250 USD

Completed
Posted almost 6 years ago

$30-250 USD

Paid on delivery
Our project is a standard C# application with both ADO and Entity framework connection to DB (MS SQL2016). To make our ADO queries easier we want to add Dapper functionality ([login to view URL]). But there is a problem. Every time we try something like this: var invoice = [login to view URL]<Invoice>(1); there is an error about missing column ID or Key. Because all our tables have the primary column name "tablename_id" instead of "id" only. And EF generates classes without any label [Key] or something like this. We have "DB first" model, so we cannot add anything to EF classes, because next time all changes will be overwritten by newly generated files. So the Job is to make sample project where this: var invoice = [login to view URL]<Invoice>(1); works and also (insert, update, delete) by using EF classes and without modifying DB structure. If more detail is needed, please ask, I will answer asap.
Project ID: 17319682

About the project

26 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I think, I have resolved your issue. I have successfully made a Sample c# application where I have implemented both Entity framework and Dapper. You need NOT to make changes in any EF generated classes. Please message me so that I can show you a demo. Regards, Vikas
$155 USD in 1 day
5.0 (26 reviews)
4.8
4.8
26 freelancers are bidding on average $159 USD for this job
User Avatar
i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck
$111 USD in 3 days
4.9 (184 reviews)
8.0
8.0
User Avatar
Respected Sir, Will you like to get this done using ADO as it is much faster then EF? Kind Regards Pankaj Garg
$111 USD in 3 days
4.9 (106 reviews)
7.0
7.0
User Avatar
Hi I'm c# developer with 12 years experience on .net framework and related tools. I have an architecture for my web application to manage my CURD and other functionality of EF. I can share it with you, I guess it can solve that issue. please send me a message to have discussion about details.
$200 USD in 3 days
4.9 (32 reviews)
5.8
5.8
User Avatar
Hello, I would like to take this assignment. I am having 14 years of experience on web development, deployment and project management. Below are my core technical skills •ASP.Net /HTML/CSS/JavaScript/JQuery •C# and VB.Net SOLID Design Principles •MS SQL, AZURE SQL, MySql and non-relational databases like Azure Table storage, Azure Document Db and MongoDb •Entity Framework (Database first, Code first and OData) •Azure Service Bus, N Service Bus and Azure Service Fabric •AWS: EC2/S3/Elastic Beanstalk/RDS/LightSail •Restful API Development (using C#) and deployment on cloud •Team City and Octopus Server for Continuous Integration and deployment •VSS/TFS/GitHub/SVN/Bitbucket/VSO •Agile/Scrum/Kanban/Zendesk •JIRA/Confluence •Unit tests using nUnit and xUnit framework •Integration testing •Acceptance/ Behavioral testing using SpecFlow •API Authentication using JSON web token •JSON format for information exchange •Domain Driven Design (DDD) •Command Query Responsibilities Segregation (CQRS) •Owin Web hosting •QuartzNet for Cron job •SSRS and Crystal Reports •Integration and implementation of Carrier(DHL, UPS, FedEx,TNT) APIs in the ASP.Net application •Integration and implementation of payment gateway(PayPal, PayUMoney) APIs in the ASP.Net application Working on tools like: Zendesk, Autofac, AutoMapper, SeriLog, Elastic-Search, Kibana, RoboMongo, RabbitMQ, TopShelf Looking forward for further discussion and to start. Best Regards
$500 USD in 5 days
4.9 (8 reviews)
4.4
4.4
User Avatar
Please contact me if you wish to discuss project specifics. I have a fairly simple solution to your problem which does not require modifying the db structure.
$250 USD in 1 day
5.0 (3 reviews)
3.8
3.8
User Avatar
Hi there, We've understood the technical issue. Just need to go through dapper API documentation. We can discuss further when you are online to chat. thank you
$200 USD in 3 days
3.8 (2 reviews)
4.5
4.5
User Avatar
Good project Experience 8 years in web and desktop application My skill : - Asp.net - MVC - Net Core - C# - Javascript - Jquery - Json - Bootstrap - Html 5 - Web Service - Api Service - Gateway - Linq - Entity Framework etc.
$222 USD in 3 days
4.0 (7 reviews)
2.6
2.6
User Avatar
Hi, I'm very experienced with C# and EntityFramework, and have a solution for you. I'll update you as soon as I have the sample project ready. In the meantime please PM me for more details, thanks.
$80 USD in 3 days
4.2 (3 reviews)
2.2
2.2
User Avatar
My offers include the complete development of your project as per your specification. i am good in development plus a student which have working in the field for more than a year so i am willing to work on your project looking forward to work longer term with you thanks
$66 USD in 3 days
5.0 (1 review)
1.1
1.1
User Avatar
Hi, I'm an expert c #. I can write your project. Please send me all the tasks, and I'll finish it on time.
$100 USD in 3 days
4.6 (1 review)
1.0
1.0
User Avatar
I have strong knowledge and experience in dapper with entity frame work . Feel free to contact me at any time
$55 USD in 1 day
5.0 (1 review)
0.5
0.5
User Avatar
Plz share database script I will try at my end If I will do what you are expecting will go further discussion. The id column is used as a primary key by default, but you can override it with an attribute. By default, queries expect that table name is matching the class name, but you can override it with an attribute.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Greetings from Kshitij, I am a C#.NET developer with more than 8 years of experience .although I have 10+ years of web development experience . To be professional ,i have done similar kinds of job ,so it seems to be very easy for me ,so i can do it 1/2 rate. Your project is of particular interest to me as I have successfully delivered similar kind of projects in the past . You need to add data annotation to properties in order to solve your problem. I can assist you to complete your project . I offer the following to my clients : 1. 2 hours of free consultation about the project. 2. Charge for actual time I will work on project. 3. 4 weeks of free support after development. Thank you for your time and considerations. Look forward to a con-call to discuss the project requirements in details. Best, Kshitij
$111 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, i was read you post and interest to do this job, i have good experience on it hope i work with you , thank you.
$155 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked on both entity framework and dapper with crud operations with asp.net mvc with sql and mysql.
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Total 7.5 years of industry experience in enterprise applications. You can share code base etc. I will resolve the issue and then you can pay instead of hiring me. Meanwhile if someone else can fix, no issue. I will quit.
$55 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CZECH REPUBLIC
Jeseník, Czech Republic
5.0
3
Payment method verified
Member since Mar 25, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.