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
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.
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.
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
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
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
6 matches
Mail list logo