What you ask is a pretty big question. Here's a similar question and my answer to this question can give you a lot of good reading for various .NET ORMs:
NHibernate, Entity Framework, Active Records, or linq2sql
. ADO.NET ADO.NET .
, . NHibernate , .
, , , . , NHibernate , , 1 2.
- ORM , ORM - ORM, .