We are hitting an issue using projections from entity framework to DTOs in an OData project. The exception is: Cannot compare 'member 'xxx' of type 'yyy''. Only primitive types, enumeration types...

Id #2595 | Release: None | Updated: Wed at 4:49 PM by evilgamr | Created: Wed at 4:49 PM by evilgamr

Unique Index for NOT NULL values

Hello, If the Index attribute is used with IsUnique=true, NULL values are considered and unique. It should be specified "IgnoreNullValue" in attribute to create UNIQUE INDEX WHERE IS NOT NULL o...

Id #2594 | Release: None | Updated: Wed at 4:19 PM by ZahY | Created: Wed at 4:19 PM by ZahY

EF6.1.2 tools failed model update from MSSQL2008

Failed update model from SQLServer 2008 with EF6.1.2 tools Beta 2 for VS14, while it's OK for beta1. Unable to generate the model because of the following exception: 'System.Data.Entity.Core.Enti...

Id #2593 | Release: None | Updated: Wed at 8:35 AM by ErikEJ | Created: Wed at 7:38 AM by yyjdelete

[Index]/[Unique] data annotation should be a class/table attribute

Currently, for a multi-column index, one has to repeat the index name for each IndexAttribute data annotation over and over again. This requirement is rather error prone (in regard to typos) and it...

Id #2592 | Release: None | Updated: Tue at 4:27 PM by SetTrend | Created: Tue at 4:27 PM by SetTrend

[Required] / [MinLength] data annotations insufficient

To my knowledge, the RequiredAttribute data annotation for string types only results in the corresponding database table column being created as NOT NULL. I believe this is not sufficient. Moreov...

Id #2591 | Release: None | Updated: Tue at 4:19 PM by SetTrend | Created: Tue at 4:18 PM by SetTrend

Investigate impact of DBCC TRACEON

According to this article, there might be a potential permissions issue when a low-privileges account executes a query that uses a QUERYTRACEON option. For example: SELECT * FROM [AdventureWorks20...

Id #2590 | Release: None | Updated: Wed at 8:58 AM by yyjdelete | Created: Tue at 12:20 AM by DavidObando

Custom Convention ignore replacement of the DbUpdateCommandTree

I'm writing custom convention which replace the DbUpdateCommandTree it's change both the set clauses and the returning. unfortunately the ExecuteAsync (DynamicUpdateCommand) ignore the new DbUp...

Id #2589 | Release: None | Updated: Mon at 7:06 PM by RoMiller | Created: Mon at 5:36 PM by Bnaya

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: Tue at 2:37 AM by guibirow | Created: Nov 21 at 10:17 PM by guibirow

UpForGrabs: Add the SQL Format function to Entity Framework

Add the SQL 2012+ FORMAT function to System.Data.Entity.SqlServer.SqlFunctions

Id #2586 | Release: Future | Updated: Tue at 2:39 PM by drmcclelland | Created: Nov 19 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: Mon at 6:26 PM by emilcicos | Created: Nov 18 at 9:21 AM by farlop