Make EF load data from database, not cache

I have asked this question here, but got no response. So, here's the problem. I have lots of tables and lots of columns in them. The program is used by many users, so that each of them must see th...

Id #2588 | Release: None | Updated: Sat at 3:59 PM by Sekktor | Created: Sat at 10:28 AM by Sekktor

Linq.Any() throw NullReferenceException

I couldn't understand what was happening when I use Linq.Any() method to check if EF object contains a specific value, the code throws a NullReferenceException on variable with data prior it's use....

Id #2587 | Release: None | Updated: Sat at 5:24 PM by divega | Created: Fri at 10:17 PM by guibirow

Add the SQL Format function to Entity Framework

Add the SQL 2012+ FORMAT function to System.Data.Entity.SqlServer.SqlFunctions http://msdn.microsoft.com/en-us/library/hh213505(v=sql.110).aspx

Id #2586 | Release: None | Updated: Fri at 10:41 PM by rjperes | Created: Wed at 2:01 PM by goroth

Not optimal query using GroupBy and Average

On Entity Framework 6.1.1, given this expression: db.GEN_PARTEOEEPERDIDAS .Where(p => (!p.MK_BAJA.HasValue || (p.MK_BAJA.HasValue && p.MK_BAJA.Value != 1)) && p.GEN_PARTEOEE.MK_VALIDADO.HasValue &&...

Id #2584 | Release: Investigation | Updated: Sun at 7:13 AM by emilcicos | Created: Nov 18 at 9:21 AM by farlop

Add support for SQL STUFF function inside CSDL

The SQL STUFF function works fine in LINQ to Entity but will not work inside CSDL. For example the following inside CSDL will not work. I get "STUFF cannot be resolved into a valid type of functi...

Id #2583 | Release: Investigation | Updated: Nov 17 at 7:09 PM by RoMiller | Created: Nov 17 at 1:38 PM by goroth

DateTimeOffset comparison generates an Internal Compiler Error

I had the following Linq query (where ‘PublishedOn’ is a System.DateTimeOffset for a datetimeoffset(7) SQL Server type): var alerts = from a in db.vDocument where a.Published == false && a.Publ...

Id #2582 | Release: None | Updated: Nov 17 at 10:32 PM by RoMiller | Created: Nov 16 at 5:24 AM by bmatusz

Security hole in EF during migrations?

I have a experienced some very strange problem with entity framework, which I have finally been able to reproduce in a small testsetup. I have a subclass of DBContext called DataLyaetDataContext ...

Id #2579 | Release: EF 6.1.2 | Updated: Nov 17 at 10:37 PM by ajcvickers | Created: Nov 12 at 7:24 AM by paal12345

It is not possible to load an entity with a complex inheritance structure using the TPT Inheritance feature

I would like to report a scenario where it is not possible to load an entity with a complex inheritance structure. I took the example from: http://msdn.microsoft.com/en-us/data/jj618293.aspx. You c...

Id #2578 | Release: Investigation | Updated: Nov 10 at 7:22 PM by RoMiller | Created: Nov 9 at 4:00 PM by HardyHo

EF generates unnecessary SQL

I have a DbSet<File> Files. Folder definitely does not inherit from File. Why is SQL predicates generated for Folder? I have this pretty simple LINQ query that has been generated from a helper func...

Id #2577 | Release: Investigation | Updated: Nov 7 at 5:09 PM by divega | Created: Nov 6 at 8:53 PM by emilm

UpForGrabs: Support projections to strongly typed collections in LINQ to Entities VB.NET

This is a followup issue with work item https://entityframework.codeplex.com/workitem/808 It seems that the fix does indeed work with C# code but will not work with VB.NET code. I have posted a e...

Id #2576 | Release: Future | Updated: Nov 10 at 6:28 PM by RoMiller | Created: Nov 4 at 7:46 PM by goroth