Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-13 Thread Scott Robison
On Thu, Sep 13, 2018 at 2:05 AM Urs Wagner wrote: > > SQLite 3.24.0 > Entity Framework 6.2.0 > > The result cannot be coerced into a string (compiler error). Maybe I'm misreading this, but the subject line shows "foreign_keys = [zero][en]" ... it appears the word ON ([oh][en]) is being written

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-13 Thread Keith Medcalf
>To: SQLite mailing list >Subject: Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0 > > >Thanks for Your help > >I get three lines > >explain pragma foreign_keys = on > >"0""Init" "0" "1" "0"

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-13 Thread Clemens Ladisch
Urs Wagner wrote: > I get three lines With some other tool, or executed through the EF? Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-13 Thread Urs Wagner
uot;" "00" "1" "Halt" "0" "0" "0" "" "00" Is think it has to do with the entity framework. When I am using ExceuteStoreQuery or SqlQuery the foreign_keys is always 0. Regards Urs

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-13 Thread Clemens Ladisch
Urs Wagner wrote: > Simon Slavin: >> On 12 Sep 2018, at 2:04pm, Urs Wagner wrote: >>> The following code is returning 0. Why? >>> >>> ExecuteStoreQuery("PRAGMA foreign_keys;").First(); >> >> You coerce the result of the call into an integer. Can you make the call >> and display (or use a

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-13 Thread Urs Wagner
...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Wednesday, September 12, 2018 7:10 PM To: SQLite mailing list Subject: Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0 On 12 Sep 2018, at 2:04pm, Urs Wagner wrote: > The following code is returning 0. Why? Which version of SQLite ? You coe

Re: [sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-12 Thread Simon Slavin
On 12 Sep 2018, at 2:04pm, Urs Wagner wrote: > The following code is returning 0. Why? Which version of SQLite ? You coerce the result of the call into an integer. Can you make the call and display (or use a debugger to see) exactly what it's returning ? If you do "PRAGMA compile_options"

[sqlite] foreign_keys = 0N with Entity Framework 6.2.0

2018-09-12 Thread Urs Wagner
The following code is returning 0. Why? var objectContext = ((IObjectContextAdapter) this).ObjectContext; objectContext.ExecuteStoreCommand("PRAGMA foreign_keys = ON;"); var foreignKeys = objectContext.ExecuteStoreQuery("PRAGMA foreign_keys;").First(); I explicitely