Recommendation for creating DAL objects

Can you recommend a DAL object creator that is simple yet useful. I want something that creates and updates o开发者_开发百科bject 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

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.

If you are looking for an ORM, see here:

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.