Sql query builder c# for windows mobile
- by pdiddy
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..
