Wrapper for SQL queries

Question

I have one idea to write library for .NET. This library will be object wrapper for SQL queries, this is not ORM, this is easy tool to avoid hardcode SQL in small projects. For example of using:

var query = Query.Select("Name")
                 .From("Product")
                 .Where("Price", Operator.MoreThan, 5);
string result = query.Build();

in result you get generated SQL code:

SELECT Name FROM Product WHERE Product.Price > 5

Does anybody know similar libraries for .NET ?

Answer 1

Entity Framework or LINQ to SQL. It should be noted that EF is seeing much more active development.