C# Data Access Layer (Not EF but SP and objects)

Question

I have ben requested to create an application that uses an existing DB with stored procedures (insert, update, delete) and they don't want to use Entity Framework.

One way is to create my own Data Access Layer using System.Data.DataSet but I would like to know if there is any existing library or something I can use where I can fill objects from SP's and also update data using SP's.

Any clue?

Check [Dapper.NET](https://github.com/StackExchange/dapper-dot-net#stored-procedures) — Federico Dipuma, Apr 27 '16 at 21:22
Yes, Entity Framework. You can use stored procedures with EF. Usually though developers are given a task but not told they can't use specific tools that lend themselves nicely to the job. Why the requirement not to use EF? — Igor, Apr 27 '16 at 21:24

score 0 · Answer 1 · edited May 23 '17 at 11:52

0

If you really want to go down this path, you can use Automapper

Take a look at this post How do I use automapper to map a dataset with multiple tables

Still, keep in mind that performance can actually be really bad.

IMHO, EF would be a better choice.

edited May 23 '17 at 11:52

Community

1
1

answered Apr 27 '16 at 21:38

Militello Vincenzo

187
2
15

Spilarix · Accepted Answer · 2016-04-27T21:43:40.793

0

You can use a micro-orm like Dapper which is simple, efficient and maps correctly to objects.

Example of use :

// Call spGetUser with a parameter Id and put the result in a User instance.  
var user = cnn.Query<User>("spGetUser", new {Id = 1}, 
        commandType: CommandType.StoredProcedure).SingleOrDefault();

edited Apr 27 '16 at 21:43

answered Apr 27 '16 at 21:40

Spilarix

1,418
1
13
24

Does Dapper can track of changes over the entity? So I can know what property was changed, etc.? – VAAA Apr 27 '16 at 21:42
@VAAA You can use [Dapper.Contrib](https://github.com/StackExchange/dapper-dot-net/tree/master/Dapper.Contrib) to do it. – Spilarix Apr 27 '16 at 21:45
Amazing!! thats what Im looking – VAAA Apr 27 '16 at 21:49

score 0 · Answer 3 · answered Apr 27 '16 at 21:44

0

I usually recommend to use Dapper. it is very light-weight, it's performance is on par with ADO.NET coding.

answered Apr 27 '16 at 21:44

Riad Baghbanli

3,105
1
12
20

Does Dapper can track of changes over the entity? So I can know what property was changed, etc.? – VAAA Apr 27 '16 at 21:44
No, it is just direct query and execute operations, extending the connection object. – Riad Baghbanli Apr 28 '16 at 13:40

C# Data Access Layer (Not EF but SP and objects)

3 Answers3