Are there existing data levels that I can use for the application that I create?

Question

I am writing a .NET application, and I don’t like the idea of ​​implementing a data layer from scratch. (By the data layer, I mean the code that speaks to the database, not the layer that abstracts access to the database in domain objects (sometimes called the data access layer and used interchangeably with the data layer).)

I would like to find an existing implementation of a common data layer that provides standard crud functions, error handling, connection management - works. I will only talk with SQL Server.

It doesn't matter to me if the library is in C # or VB.NET, and I don't care if it is LINQ or ADO.NET. While this is working.

** I want to emphasize that I am not looking for technologies or mechanisms for accessing data (for example, LINQ, ORM tools, etc.), but rather existing libraries.)

Answer 1

If you are talking only with SQL Server, Linq to SQL is the best option . It is very easy to get up and work. You will get both a data layer and an abstraction. All you have to do is provide a Linq to SQL connection string and it will handle the rest.

If you are going to connect to a database other than SQL, you would like with NHibernate .

NHibernate , Linq to SQL . MS Visual Studio , SQL.

Answer 2

, , NHibernate. Enterprise Library 5 Data Access Block, . NHibernate , (, NHibernate ) - CodeSmith EntLib.

Answer 3

easyobjects . -:

EasyObjects.NET - .NET Framework. .

Answer 4

, crud, , - . SQL Server.

, Subsonic. , , , ORM, " ". CRUD , POCO , , .

Answer 5

Microsoft Entity Framework , , ", ".

, Visual Studio - - - T4.

microsoft, MS, SQL-.

3 , WCF . , , EF .

Answer 6

, ? , - , (winforms WPF ASP)... .

ORM, , , , . , , - , ?

" , crud, , - " : ADO.NET. , , , , , - - -, . , , , , .