SELECT statement on XML?

  • Thread starter Thread starter Zanna
  • Start date Start date
Z

Zanna

Hi all,

If I serialize a dataset with some tables on it can I execute some SELECT as
if it was a real database (with JOINs and so on)?

Thanks!
 
No, you can not execute SQL statements on XML file, but you can select rows
in the DataSet's tables.
It does not matter how data got into the DataSet (loaded from XML, SQL, SQL
CE or any other data source).

Even though DataSet supports selecting rows via DataTable.Select(), there's
no support for true SQL statements.
You can't join tables in traditional SQL way, but you can select rows you
need and to fetch related rows easily to access data in several tables.
You also can create a new table and map columns from different tables on to
it to get a JOIN like results.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
 
Back
Top