ORM
nHibernate, learning curve, FluentNHibernate and/or Castle ActiveRecord to ease the steepness
Castle ActiveRecord - it uses nhibernate.dll in background, but configuration is done through attributes. It's like lite version of nhibernate
Linq-to-SQL, for SQL Server only
EF DbContext API
lightweight ORM (lite, micro)
Dapper (written for and used by StackOverflow itself).
MS Data Access Application Block, a part of ms enterprise library.
mybatis.net rename from iBatis.Net
ADOTemplate from the Spring Framework.net
Subsonic, good, but does not support join
CoolStorage.NET - I used it a lot with small projects. Works well with number of dbs
ServiceStack.NET OrmLite - Light, simple and fast convention-based POCO ORM
Vici Coolstorage, Supports SQL Server 2000-2010, MySQL, SQLite, MS Access and VistaDB on .NET
SOODA, Supports SQL Server, MySQL, PostgreSQL and Oracle,
ODX.NET - Distributed ORM Framework
Value Injecter, ValueInjecter is used in ASP.net MVC sample app for mapping models to viewmodels and back, see the app live.
Links:
A look at .NET Object Relational Mappers (ORM)s, part 1, 2
Done
NHibernate – The Good, the Bad, and the Ugly, that it gets!
Done
Small is Beautiful - .NET Micro ORMs, A quick look at Massive, Simple.Data, Peta Poco and Dapper
Done
5 reasons not to use a micro ORM
Done
Micro-ORMs War: Dapper vs. Massive vs. PetaPoco
done
When should you use NHibernate?
PetaPoco – Why I’m Using A Micro-ORM
How I learned to stop worrying and write my own ORM
Simplify Database Operations with Generic Fluent NHibernate
What are some of the benefits of a “Micro-ORM”?
Micro-ORMs for .NET Compared – Part 1, 2, 3
MicroORMs for .NET:
(Obligatory) Introduction (Post)
Done
PetaPoco – Why I’m Using A Micro-ORM
Using LINQ Expressions to Generate Dynamic Methods
Whose Data Access Layer do you use for .NET?
A Few of My Favorite Things... in the Entity Framework 4.2 DbContext