Ticket Hash: | 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:
(text/x-fossil-plain)
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: (text/x-fossil-plain) 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: (text/x-fossil-plain) This issue will not block the 1.0.105.0 release. |