Setting unique Constraint with fluent API?
I’m trying to build an EF Entity with Code First, and an EntityTypeConfiguration using fluent API. creating primary keys is easy but not … Read more
entity-framework
How to add/update child entities when updating a parent entity in EF
The two entities are one-to-many relationship (built by code first fluent api). public class Parent { public Parent() { this.Children = new List<Child>(); … Read more
Getting exact error type in from DbValidationException
I have the situation where I’m initializing my model in DatabaseInitializer() for EF 4.1 and get this annoying error “Validation failed for one … Read more
Update Row if it Exists Else Insert Logic with Entity Framework [closed]
Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be … Read more
Entity framework linq query Include() multiple children entities
This may be a really elementry question but whats a nice way to include multiple children entities when writing a query that spans … Read more
The cast to value type ‘Int32’ failed because the materialized value is null
I have the following code. I’m getting error: “The cast to value type ‘Int32’ failed because the materialized value is null. Either the … Read more
ASP.NET Identity DbContext confusion
A default MVC 5 App comes with this piece of code in IdentityModels.cs – this piece of code is for all the ASP.NET … Read more
The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
Basically I got a table in my EF database with the following properties: public int Id { get; set; } public string Title … Read more
What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
I know some differences of LINQ to Entities and LINQ to Objects which the first implements IQueryable and the second implements IEnumerable and … Read more
How to force LINQ Sum() to return 0 while source collection is empty
Basically when I do the following query, if no leads were matched the following query throws an exception. In that case I’d prefer … Read more