.NET ORM required

Question

I have a db sql server ready using simple tables (not many restrictions). Now I need to create DAL and object classes for tables.

How much can .NET ORM (e.g. NHibernate or any other free FW)? It mainly helps with the time-consuming tasks of writing class and db access functions. I'd rather spend time creating business logic for these classes of objects.

Will it be easy to add / modify tables later? I have a conceptual idea about ORM, but there is no practical experience in using any.

Answer 1

You can use Linq to Sql or Entity Framework to auto-generate your classes, as well as a data access function.

DBML (L2S) EDMX (EF) Visual Studio, , , .

Linq to Sql Classes ADO.NET Entity Data Model, :

• Visual Studio .
• = >
• Linq to Sql Classes ADO.NET Entity Data Model
• .
• Server Explorer,
• DBML EDMX , .

:

• table User User
• User FirstName, FirstName
• User Contact, IList<Contact> Contacts User. user.Contacts.Where(c => c.ContactId == 7000) DataContext

, SQLMetal, , . , int enums.

---

NHibernate .

Answer 2

, DAL .

SubSonic ORM, , DAL .

Entity Framework Linq to SQL ( Microsoft), DAL , .

DAL, .

Answer 3

Linq2Sql Entity . : , . , , ( ).

Answer 4

Nhibernate . , . .

, T4. , , , , .

, - , DAL. , .

Answer 5

, Cocoon ORM Nuget Github . . http://guidelinetech.imtqy.com/cocoon-orm/

-:

• AutoCrud ()
• SQL, .
• , Entity Framework
• ( )
• .
• , GUID UID.
• SQL Server 2008/2012/20014/+ Azure SQL ( TSQL)
• Use the Cocoon ORM libraries in your own proprietary code under the weak copyleft LGPL license (changes to Cocoon ORC must be shared. Please let us know so that we can combine brains!)