ado.net - SQL Server CE and C#; Populate a DataSet with ALL the Tables from a SQL Server CE DB -


how populate dataset tables sql server ce database. possible in 1 sql select statement?

i know can call separate select statements names of table need data need generic solution dumps tables sql server ce database dataset.

thanks

select 'select * ' + table_name information_schema.tables 
  1. run queries.
  2. run each query, dumping in same dataset.

this works easy.

edit: think had problems trying run multiple queries in single go sql ce (even line terminator ;).


Comments

Popular posts from this blog

unicode - Are email addresses allowed to contain non-alphanumeric characters? -

c++ - Convert big endian to little endian when reading from a binary file -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -