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