Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Data.SQLite;
- namespace TestSQLite
- {
- class Program
- {
- static void Main(string[] args)
- {
- using(IDbConnection conn = new SQLiteConnection("Data Source=:memory:"))
- {
- conn.Open();
- IDbCommand cmd = conn.CreateCommand();
- cmd.CommandText = "CREATE TABLE TEST (id)";
- cmd.ExecuteNonQuery();
- cmd.CommandText = "CREATE VIEW TESTVIEW AS SELECT TEST.id FROM TEST";
- cmd.ExecuteNonQuery();
- cmd.CommandText = "INSERT INTO TEST (ID) VALUES('test')";
- cmd.ExecuteNonQuery();
- cmd.CommandText = "SELECT \"id\" FROM \"TEST\"";
- using(IDataReader reader = cmd.ExecuteReader())
- {
- reader.Read();
- Console.WriteLine(reader.GetName(0));
- }
- cmd.CommandText = "SELECT \"id\" FROM \"TESTVIEW\"";
- using (IDataReader reader = cmd.ExecuteReader())
- {
- reader.Read();
- Console.WriteLine(reader.GetName(0));
- }
- Console.ReadLine();
- }
- }
- }
- }
- // Output
- // id
- // "id"
Advertisement
Add Comment
Please, Sign In to add comment