sql statements required

[Eric Sabine]

In an upcoming application, the software will run on a client pc or PPC.
The software downloads a few tables from a web service and then the user can
choose to go offline. When the program closes, the user will be given an
option to save the downloaded data locally so that next time they launch it,
they aren't required to do a download. My problem is the tables will
contain FK relationships and the user can do many types of SQL statements
against the data. I _really_ wanted to keep it as lightweight as possible
and store the data in XML and likewise work with the data in datasets, but I
know I can't perform SQL statements, i.e., joins, aggregates, etc., against
datatables. Is my only option to install a local database, i.e., MSDE, SQL
CE, Access, etc., and run my SQL statements against that RDBMS? Are
datasets ever going to allow me to write SQL statements against them?

Eric

 

[William Ryan]

Eric:

That's not entirely true. Granted that you don't have the whole SQL Spec
supported, but you can use DataRelaion Objects from Joins and you have a ton
of stuff available in the Expressions like ISNull, Sum etc. Google on
Expression Column ADO.NET