Sql query builder c# for windows mobile [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. 开发者_开发知识库

---

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question

I'm building a windows mobile app. And using SqlCe.

I'm looking for a good sql query builder. So instead of writing "SELECT COLUMNS FROM TABLE WHERE etc...

Is there a good free library that can build this sort of query?

EDIT: You know when you write your code with ADO.net something like this

SqlCeCommand command = new SqlCeCommand(Connection);
command.CommandText = "SELECT * FROM Orders WHERE customerId = @customerId";

Well i'm looking for some library that could build that SELECT statement using classes instead of writing it through string. So something like:

SqlCeCommand command = new SqlCeCommand(Connection);
SqlQueryBuilder query = new SqlQueryBuilder();
query.Table = "Orders";
query.AddWhere("customerId", myValue)
command.CommandText = query.toString();

Something like that .... so a class that will build the query..

---

The OpenNETCF.ORM Framework may do what you want.