Mapper V2 Request

[Omzig]

It would be really awesome if the mapper was upgraded to a "Fluent" version. E.G.

var sqlMapper = new SqlMapper<MockEntity>();

var sqlString = sqlMapper.Select(rec => rec.Id) .From("MockEntity") .Where(rec => rec.Id = "1") .ToString()

Or somehow merge it into a LINQ type statement to form the SQL string. Or maybe create an SQLBuilder that accepts a type.

var sqlQuery = new SqlBuilder<MockEntity>() .Select(rec => rec.Id) .From("MockEntity") .Where(rec => rec.Id = "1");

I really like how LINQ works, it is a shame that we cannot use that same concept here.