because I get an error “InvalidOperationException: Collection was modified; enumeration operation may not execute” after the first object. In other words, .Remove removes only one object. This has nothing to do with EF Core, and, yes, .Remove() only removes one object. However, you are attempting to modify a collection that you are iterating through. There … Read more
Lazy loading is now available on EF Core 2.1 and here is link to the relevant docs: https://learn.microsoft.com/en-us/ef/core/querying/related-data#lazy-loading
It used to be the case for older versions of EF core. Now string.Contains is case sensitive, and for exemple for sqlite it maps to sqlite function `instr()’ ( I don’t know for postgresql). If you want to compare strings in a case-insensitive way, you have DbFunctions to do the jobs. context.Counties.Where(x => EF.Functions.Like(x.Name, $”%{keyword}%”)).ToList(); … Read more
There is no convention for this as of EF RC2 build. This is from EF Core team: In past pre-release of EF Core, the table name for an entity was the same as the entity class name. In RC2 we now use the name of the DbSet property. If no DbSet property is defined for … Read more
A note from documentation on the call to db.Database.EnsureCreated(): Note that this API does not use migrations to create the database. In addition, the database that is created cannot be later updated using migrations. If you are targeting a relational database and using migrations, you can use the DbContext.Database.Migrate() method to ensure the database is … Read more
1- Make sure to set your web project as Set as Startup Project 2- In Package Manager Console, set your data access layer (if any) as a default project 3- Then run the command again
First we install the Microsoft.EntityFrameworkCore.SqlServer NuGet Package: PM > Install-Package Microsoft.EntityFrameworkCore.SqlServer Then, after importing the namespace with using Microsoft.EntityFrameworkCore; we add the database context: services.AddDbContext<AspDbContext>(options => options.UseSqlServer(config.GetConnectionString(“optimumDB”)));
In case you have base class or interface defining the IsActive property, you could use the approach from Filter all queries (trying to achieve soft delete). Otherwise you could iterate entity types, and for each type having bool IsActive property build dynamically filter expression using Expression class methods: foreach (var entityType in modelBuilder.Model.GetEntityTypes()) { var … Read more
You need custom ApplicationUser inherit from IdentityUser<TKey> and custom Role inherit from IdentityRole<TKey> public class ApplicationUser : IdentityUser<Guid> { } public class Role : IdentityRole<Guid> { } Custom context class inherit from IdentityDbContext<ApplicationUser, Role, TKey> and use fluent api for auto generate guid keys. public class ApplicationDbContext : IdentityDbContext<ApplicationUser, Role, Guid> { protected override void … Read more