Re: [sqlite] Fw: sqlite + EF4 + 'on cascade delete' = not working

2012-10-13 Thread David Richardson
Ok I found a solution a week ago.  It was really simple to do: ModelEntities1 ModelData = new ModelEntities1(connString.ConnectionString);                ModelData.Connection.Open();                 ModelData.ExecuteStoreCommand("PRAGMA foreign_keys = ON"); EF has its own open and close

Re: [sqlite] EXT :Re: System.Data.SQLite Field Name are surrounded by double quotes for Views

2012-10-13 Thread Black, Michael (IS)
And if you don't quote the 2nd select it comes out OK. This is 3.6.13: sqlite> SELECT "id" FROM "TESTVIEW"; -- Observe the results here. "id" -- test sqlite> SELECT id FROM "TESTVIEW"; -- Observe the results here. id -- Presumably a simple bug for the powers-to-be to fix.

[sqlite] AUTO: Bret Patterson/Austin/IBM is out of the office (returning 10/22/2012)

2012-10-13 Thread Bret Patterson
I am out of the office until 10/22/2012. I'm out of the office but checking email once a day and will respond to any high importance issues as quickly as possible. Note: This is an automated response to your message "sqlite-users Digest, Vol 58, Issue 13" sent on 10/13/2012 10:00:02 AM.

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

2012-10-13 Thread Joe Mistachkin
Vincent DARON wrote: > > http://pastebin.com/q2m5vJky > The double quotes are coming from the SQLite core native library. Run "sqlite3.exe :memory:" and execute the following commands: .mode columns .headers on CREATE TABLE TEST (id); CREATE VIEW TESTVIEW AS SELECT TEST.id FROM TEST; INSERT

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

2012-10-13 Thread Vincent DARON
Of course http://pastebin.com/q2m5vJky Best Regards, Vincent Le 12/10/12 14:24, Joe Mistachkin a écrit : Vincent DARON wrote: It seems the IDataReader.GetName(int i) method return name surrounded by double quotes for views. Example: For a table : "Id" For a view : "\"Id\"" Is it the

Re: [sqlite] Sqlite, Is it possible to calculate the length of the longest increasing subsequence using an UDF?

2012-10-13 Thread Elefterios Stamatogiannakis
Sorry for hijacking the thread, but i have an answer for that. IMHO having the computation application and the data management on different domains incurs a very high data transfer cost. The traditional thinking of shipping the data from the DB to somewhere else (application code) to do the