System.Data.SQLite

Hello

There seems to be a problem when temporary table (Perhaps, view and trigger also :) is used.
It is necessary to refer to 'temp.sqlite_temp_master' instead of 'temp.sqlite_master'.

Thanks

private static void Main(string[ args)
{
    //Using System.Data.SQLite 1.0.47.1
    SQLiteConnection connection = new SQLiteConnection("Data Source=test.db");
    connection.Open();
    SQLiteCommand command1 = new SQLiteCommand("create temp table tmptbl (id integer,data text,primary key (id))", connection);
    command1.ExecuteNonQuery();

    SQLiteCommand command2 = new SQLiteCommand("select * from tmptbl", connection);
    SQLiteDataReader reader = command2.ExecuteReader();
    DataTable dataTable = new DataTable();
    dataTable.Load(reader);
    //SQLite error no such table: temp.sqlite_master

    connection.GetSchema("TABLES", new string[ { "temp" , null, null, null, null });
    //SQLite error no such table: temp.sqlite_master
}

 

Ugh -- this one got swept under the rug ... I'll have it fixed for the next release.

Robert

 Hello Mr. Simpson, I'm having the same problem the previous user reported while working with a temporary table.

I get the same SQLiteException:

              SQLite error no such table: temp.sqlite_master

This is still not fixed with version 1.0.48.0 and I really need support for this feature.

Could you please suggest a workarround for this issue?

Thanks,

Gonzalo Villa Cox

 This is something that I'm running into as well, is there any ETA on this?

Thanks,

Jeff