Guest User

System.Data.SQLite Field Name are surrounded by double quote

a guest
Oct 13th, 2012
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.03 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Data.SQLite;
  5.  
  6. namespace TestSQLite
  7. {
  8.     class Program
  9.     {
  10.         static void Main(string[] args)
  11.         {
  12.             using(IDbConnection conn = new SQLiteConnection("Data Source=:memory:"))
  13.             {
  14.                 conn.Open();
  15.                 IDbCommand cmd = conn.CreateCommand();
  16.                 cmd.CommandText = "CREATE TABLE TEST (id)";
  17.                 cmd.ExecuteNonQuery();
  18.                 cmd.CommandText = "CREATE VIEW TESTVIEW AS SELECT TEST.id FROM TEST";
  19.                 cmd.ExecuteNonQuery();
  20.                 cmd.CommandText = "INSERT INTO TEST (ID) VALUES('test')";
  21.                 cmd.ExecuteNonQuery();
  22.                 cmd.CommandText = "SELECT \"id\" FROM \"TEST\"";
  23.                 using(IDataReader reader = cmd.ExecuteReader())
  24.                 {
  25.                     reader.Read();
  26.                     Console.WriteLine(reader.GetName(0));
  27.                 }
  28.  
  29.                 cmd.CommandText = "SELECT \"id\" FROM \"TESTVIEW\"";
  30.                 using (IDataReader reader = cmd.ExecuteReader())
  31.                 {
  32.                     reader.Read();
  33.                     Console.WriteLine(reader.GetName(0));
  34.                 }
  35.  
  36.  
  37.                 Console.ReadLine();
  38.             }
  39.         }
  40.     }
  41. }
  42.  
  43. // Output
  44. // id
  45. // "id"
Advertisement
Add Comment
Please, Sign In to add comment