|Title:||Linq and Lambda expression on EF DBContext object don't work|
|Last Modified:||2018-04-26 16:45:29|
|Version Found In:||18.104.22.168|
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 22.214.171.124 to 126.96.36.199 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 188.8.131.52 release.