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
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 expected
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 INTO
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.
This
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.
Michael D. Black
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