views:

246

answers:

2

Is there anyway to batch two different select queries to either SQLite or SQLCE and get the two result sets back in C#? If not, is there an embedded database that handles this?

+1  A: 

Separate the queries with a semicolon and load the results into a DataSet or use IDataReader.NextResult().

Sam
+1  A: 

Batching is not available in SQL Compact

ErikEJ