entity-framework Archives

entity-framework, Programming

IT Nursery

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 ...

May 29, 2022
0 Comments

entity-framework, Programming

IT Nursery

The relationship could not be changed because one or more of the foreign-key properties is non-nullable

I am getting this error when I GetById() on an entity and then set the collection of child entities to my new list ...

May 29, 2022
0 Comments

How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?

Let’s just suppose I have a valid need for directly executing a sql command in Entity Framework. I am having trouble figuring out ...

May 24, 2022
0 Comments

Entity Framework 6 Code first Default value

is there “elegant” way to give specific property a default value ? Maybe by DataAnnotations, something like :...

May 23, 2022
0 Comments

Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [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 ...

May 22, 2022
0 Comments

Unique Key constraints for multiple columns in Entity Framework

I’m using Entity Framework 5.0 Code First; public class Entity {...

May 18, 2022
0 Comments

Reset Entity-Framework Migrations

I’ve mucked up my migrations, I used IgnoreChanges on the initial migration, but now I want to delete all my migrations and start ...

May 12, 2022
0 Comments

Entity Framework: “Store update, insert, or delete statement affected an unexpected number of rows (0).” [closed]

Closed. This question needs debugging details. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic ...

May 12, 2022
0 Comments

EF Migrations: Rollback last applied migration?

This looks like a really common task, but I can’t find an easy way to do it. I want to undo the last ...

May 2, 2022
0 Comments

No Entity Framework provider found for the ADO.NET provider with invariant name ‘System.Data.SqlClient’

After downloading the EF6 by nuget and try to run my project, it returns the following error: No Entity Framework provider found for ...

April 30, 2022
0 Comments