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
>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"
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
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
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
...@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
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"
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
8 matches
Mail list logo