Wrapper for SQL queries
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 usin开发者_运维问答g:
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 ?
Entity Framework or LINQ to SQL. It should be noted that EF is seeing much more active development.
iBatis.Net and NHibernate do similar things.
精彩评论