Recommendation for creating DAL objects

views:

187

answers:

+3 Q:

Recommendation for creating DAL objects

Hello There,

Can you recommend a DAL object creator that is simple yet useful. I want something that creates and updates object the way LINQ does. It should be in c# and much better if it splits object's properties and data access methods in partial classes.

We've used CSLA before but I want something more simplier for our next project.

Thanks in advance

+2 A:

Just a humble recommendation as there are plenty of great products out there - we have been using EntitySpaces (an ORM) for a couple of years at our shop and like it.

thedugas 2010-03-01 05:52:26

@thedugas - It looks good I will take a look at it. Have you used something free?

Jojo Sardez 2010-03-01 06:57:16

I am currently investigating using entityspaces and would love it if you expanded on what you liked about it in particular.

Russell 2010-03-01 11:52:51

@Jojo - no, I haven't, but you might find this post of interest:http://stackoverflow.com/questions/206197/best-free-orm-tools-to-use-with-net-2-0-3-5

thedugas 2010-03-01 13:24:41

@Russell - a couple of things I like in particular:1. Hierarchical Data Model2. Dynamic Query API

thedugas 2010-03-01 13:34:35

+2 A:

If you are looking for an ORM, see here:

http://stackoverflow.com/questions/1377236/nhibernate-entity-framework-active-records-or-linq2sql/

Are you just looking to use raw ADO.NET and also maybe datasets? If so, do you want a code generator to generate your data layer for you without a full blown ORM?

If you want to use Linq (not Linq-To-Sql), then you need an ORM at this point.

CSLA is not really an ORM and doesn't really do much from a data layer perspective. It is more of a business layer tool.

Michael Maddox 2010-03-01 11:49:10

Thanks dude i'll take a look at it.

Jojo Sardez 2010-03-01 11:59:36

ansaurus

tags:

views:

answers:

Recommendation for creating DAL objects

related questions