Sql query builder c# for windows mobile

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..

Answer 1

check this
http://www.codeproject.com/KB/database/CEQuery.aspx
http://www.eggheadcafe.com/software/aspnet/30291390/desktop-query-tool.aspx

Answer 2

The OpenNETCF.ORM Framework may do what you want.