Simple data access level

Can anyone suggest a simple level of data access (C # .NET)? Not keen on using the Microsoft Application Application data access block, it seems very bloated and redundant. You also don’t want to use LINQ to SQL for various reasons. I want to build on this and create my own ORMs, again for various reasons. Previously, I always had a level of access to data, so he never participated in the creation ....

+3
source share
9 answers

Here is the complete list: ORM ".Net" Tools

ADO.NET Entity Framework, Microsoft ORM (released with .NET 3.5 SP1)
Foundation Foundation Database, free or commercial
BCSEi ORM Code Generator, free or commercial
Business Logic Toolkit for .NET, open source
Lock ActiveRecord, ActiveRecord for. NET, open source
DataObjects.Net v4.0, open source, commercial
DevForce, commercial, N-Tier
Developer Express, permanent eXpress objects (XPO)
EntitySpaces, commercial
Euss, open source
Habanero, free open source source code
iBATIS, free open source open source
Invist, free inst A tool for creating ORM and code

LLBLGen, open source drivers, commercial
LightSpeed, free or commercial
Neo, open source
NConstruct, commercial
NHibernate, open source
Opf3, free and commercial
ObjectMapper.NET, GPL and commercial
OpenAccess license , free or commercial TierDeveloper, free tool for creating ORM and
Persistor.NET code generation, free or commercial
Fast objects, free or commercial
Sooda, open source; BSD
Subsonic license , open source
Orasis, free trial or buy.
Telerik, buy or buy.
CSLA.NET, for free.
ECO, free or commercial
nhydrate, open source
.netTiers, open source
dapper-dot-net, open source
codemithtools plinqo, open source

+2
source

Other people and organizations have spent months or years developing their own ORMs and technologies, many of which you have indicated, and many of which are free to use. You should devote your resources to your main application logic, and not try to build another beast called ORM. There are enough offers to satisfy all kinds of applications.

, DAL. , ORM ( , ) . , , , .

, ORM , . 2 .

: ORM , , , ORM ...

public interface IBusinessDataOperations {
   // hides any ORM of choice
}

- ORM, , , .

+7

Linq?

DataSet/DataTables?

( )?

?

, DAL/ORM , - , . , .:)

, - SubSonic, EntityFramework NHibernate, , .

+3

SubSonic 2.x, linq. / ORM, . , , .

+1

SQLHelper, , 2000- MS Application Access Application Block. , SQLHelper.cs, ADO, DAL . ( ) .net 2.0 framework . , SQLHelper , CRUD, - .

, , , , . , , , factory, , , . SQL Server, . , .

.

, , .

+1

DbExtensions, DAL ORM .

+1

( !) DAL , sql , POCO ( CLR) .

sprocs SQL. poco ( SQLDataReader)

, , , , , DAL/ORM .

0

, , , , , linq ms, :

  • , () , DAL ?
  • XML DAL ?
  • , ?

DAL , , , , , ORM, , SqlServer, Oracle, PostgreSql SqLite, , .

- DAL ( ), , Sql , .

...

0

Source: https://habr.com/ru/post/1722001/


All Articles