ctrlalt313373
Reputation: 4065
Batch Select Sql in SQLite or SqlCE with C#
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?
Upvotes: 1
Views: 934
Answers (2)
Samuel Neff
Reputation: 74909
Separate the queries with a semicolon and load the results into a DataSet or use IDataReader.NextResult().
Upvotes: 1
Related Questions
- Sqlite using command line
- How do you run a batch of SQL statements using the SQLite.NET PCL
- How to query an SQLite db in batches
- Execute query on multiple sqlite databases in C#
- Using SQLite with C#
- Performing just SELECT commands on SQLite
- sqlite select record one by one in vb.net
- how to run batch queries in sql ce?
- sqlite and batch file
- Execute multiple queries in one shot in SQLite C#?