System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 2df93690e896db2da4061d8d7a3741357510df16
Title: Linq and Lambda expression on EF DBContext object don't work
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: LINQ Resolution: Need_More_Info
Last Modified: 2018-04-26 16:45:29
Version Found In: 1.0.103.0
User Comments:
anonymous added on 2017-03-01 09:20:12:
I have Model edmx file generated some time ago for my SQLite DataBase.
I've changed SQLite from 1.0.81.0 to 1.0.103.0 and all my DB queries stopped working
I have problem with Linq and Lambda expression on DBContext EntityFramework object.

Doesn't work (First, Single, FirstOrDefault, SingleOrDefault):
1) var x = context.DBTable.SingleOrDefault(a => a.Id.Equals("some guid here")); // doesn't work (Sequence contains no elements)
2) var scans = from r in context.DBTable
                                where r.Id == "some guid here"
                                select r;

This is not option for me but lambda expression work on List object
1) var x = context.DBTable.ToList().SingleOrDefault(a => a.Id.Equals(some guid)); // works (return item)

Can anyone help me somehow with that?
Thx

mistachkin added on 2017-03-08 04:06:21:
I think the solution may be to use the BinaryGUID connection string property.

Please see ticket [33b39f05ae41dda31266] for more information on doing this
from within the context of a LINQ query.

mistachkin added on 2017-04-03 23:26:10:
This issue will not block the 1.0.105.0 release.