SOLID DDD ORM request (to use clean entities and repositories) for .NET

Question

Is there a ORM that would

• leave my entities classes clean, withouth any attributes for properties and classes
• would not be ActiveRecord pattern so it should not have entity.Save/Delete etc.

optional: able to execute stored procedures and parse the result into entityies

Answer 1

Sounds like NHibernate is what you need. This uses a mapping file (in XML) to map the properties of classes to the database. Entities are managed through a SessionManager interface.

Documentation is here.

A mapping file can also map from a stored procedure to your persistent objects. Details here.

Answer 2

What you are looking for is commonly referred to as Persistence Ignorance. It seems that the preferred framework for that is NHibernate, so I second Jeremy McGee's answer.

For completeness' sake I'd like to point out Microsoft's Entity Framework will get Persistence Ignorance in the next version (.NET 4) - they call it POCO support. Whether it will actually turn out to be any good remains to be seen...