string script =
@"CREATE TABLE DEPT (
DEPTNO INTEGER PRIMARY KEY,
DNAME VARCHAR(14),
LOC VARCHAR(13)
);"+
"INSERT INTO DEPT VALUES (10,'ACCOUNTING','NEW YORK');"+
"INSERT INTO DEPT VALUES (20,'RESEARCH','DALLAS');"+
"INSERT INTO DEPT VALUES (30,'SALES','CHICAGO');"+
"INSERT INTO DEPT VALUES (40,'OPERATIONS','BOSTON');"+
"SELECT * FROM DEPT";
SQLiteConnection sqConn = new SQLiteConnection(
"DataSource=mydatabase.db;");
SQLiteScript sqScript = new SQLiteScript(script,sqConn);
IDataReader sqReader;
sqConn.Open();
while (sqScript.ExecuteNext(out sqReader))
{
Console.WriteLine("Records affected " + sqReader.RecordsAffected);
while (sqReader.Read())
{
Console.WriteLine(sqReader.GetString(0));
}
sqReader.Close();
}
sqConn.Close();