Unable to cast object of type 'System.Data.Entity.Core.Query.InternalTrees.SortOp' to type 'System.Data.Entity.Core.Query.InternalTrees.ProjectOp.
Getting this when running the query:
Id #2834 | Release:
| Updated: Thu at 12:09 PM by emilm | Created: Thu at 12:09 PM by emilm
When I use COALESCE in a View EF creates a nullable property for the entity. For ISNULL EF correctly creates a not nullable property.
CREATE VIEW dbo.vwExample
Id #2833 | Release:
| Updated: Thu at 7:47 AM by rezzonico | Created: Thu at 7:47 AM by rezzonico
I have a database named: LA_ARI
I'm unable to connect to this database.
I can connect to any other database that does not have an underscore ( _ ) in the db name.
Does EF support connecting ...
Id #2832 | Release:
| Updated: Wed at 2:24 PM by molenator | Created: Wed at 2:34 AM by molenator
I reported this at https://github.com/aspnet/EntityFramework/issues/3277 by accident as it looks like this is an EF6 issue.
Looks to be an issue with the generated SQL when trying to drop a fore...
Id #2831 | Release:
| Updated: Oct 2 at 11:06 PM by ianschmitz | Created: Oct 2 at 11:06 PM by ianschmitz
I get this error
The ResultType of the specified expression is not compatible with the required type. The expression ResultType is 'MyApp.Model.Suppliers' but the required type is 'Edm.Int32'. Pa...
Id #2830 | Release:
| Updated: Oct 1 at 8:58 AM by AndersM | Created: Oct 1 at 8:58 AM by AndersM
EF 5.x or 6.x
I am getting a DbUpdateConcurrencyException on DBContext.SaveChanges() after inserting a new (Detached) object with an identity column which is not part of the pri...
Id #2829 | Release:
| Updated: Mon at 6:27 PM by RoMiller | Created: Sep 30 at 11:38 PM by TitanApps
I am working with view
Entity Framework 6.1.3 Version
As EF always need Key attribute on atleast one attribute Here I apply that attribute to Id.
Following is the sample code.
DB Level View ( ...
Id #2828 | Release:
| Updated: Sep 30 at 7:16 AM by jinal | Created: Sep 30 at 7:16 AM by jinal
InvalidOperationException was thrown when run the following code.
Id #2827 | Release:
| Updated: Sep 28 at 8:51 AM by zakky | Created: Sep 28 at 8:50 AM by zakky
VB.NET considers String.IsNullOrEmpty(" ") to be False however once the code is converted to SQL, it evaluates to True
' ==> False
Dim SpaceQry = ...
Id #2826 | Release:
| Updated: Wed at 7:58 PM by VincentSaelzler | Created: Sep 24 at 7:33 PM by VincentSaelzler
I have profiled my app that uses latest Entity framework 6.1.3 (but 6.1.0 and older have the same problem I believe).
There is lots of queries within calculations and evaluations, but the one sin...
Id #2825 | Release:
| Updated: Sep 26 at 7:21 PM by pbehin | Created: Sep 18 at 8:05 AM by vdohnal