Dapper.Net–StackOverflow’s Open Source ORM

 

This ORM is specialized in converting and mapping query result into a strongly typed List.

public static List<T> ExecuteMapperQuery<T>(this IDbConnection cnn, string sql, 
object param = null, SqlTransaction transaction = null)

Example usage:
public class Dog
{
    public int? Age { get; set; }
    public Guid Id { get; set; }
    public string Name { get; set; }
    public float? Weight { get; set; }

    public int IgnoredProperty { get { return 1; } }
}            
            
var guid = Guid.NewGuid();
var dog = connection.ExecuteMapperQuery<Dog>("select Age = @Age, Id = @Id", 
new { Age = (int?)null, Id = guid });
            
dog.Count()
    .IsEqualTo(1);

dog.First().Age
    .IsNull();

dog.First().Id
    .IsEqualTo(guid);

http://code.google.com/p/dapper-dot-net/

Link to Source code : http://code.google.com/p/dapper-dot-net/source/browse/Dapper/SqlMapper.cs