Cannot find plural form of table

cannot "Add or Update" Entity because Primery key cannot be changed

I am implementing an import routine, where a user pastes a specific formatted string into an input field, which in turn gets tranformated into an entity and then put into a database....The algorithm checks if the entity already exists and either tries to update it or insert it into the database. Inserting works fine - updating fails....//considered...

How to find a List<Object> using Find method of entity framework passing Array as parameter?

You are looking for a ...Contains... query...:...var lServicosInformados = db.Servicos.Where(x => lCodigoServicos.Contains(x.PKId)); ...This assumes ...PKId... is the name of your primary id column (you didn't specify the name).

Cannot override OnConfiguring in beta5 - no suitable method found to override

After updating EF7 to beta5 from beta4 my OnConfiguring stopped working....protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) ...I can't figure out what I need to write instead....Here's my ...project.json..., just in case...{ "dependencies": { "EntityFramework.SqlServer": "7.0.0-beta5", "EntityFramewo...

ADO.NET provider with invariant name 'System.Data.SqlClient;' cannot be found (Entity Framework MVC)

I cannot seem to resolve what appears to be a common issue with Entity Framework 6. I have reviewed the many topics related to this issue on SO, and am unable to find a solution that works for my particular case....I have up until this point been developing using localdb with code first migrations, which worked fine. But now that I am moving this t...

How to scaffold DbContext with plural DbSet property names in Entity Framework Core?

I use ...Scaffold-DbContext... command in ...Package Manager Console... to create and re-create context and entities for an existed SQL Server database:...Scaffold-DbContext -provider EntityFramework.MicrosoftSqlServer -connection "my connection string" ...It works perfectly except one thing: ...DbSet...'s have property names in singular form:...pu...

Identity DB context / hint no plural tables

modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();... doesn't work for Identity tables. So it is needed to resolve explicitly:... protected override void OnModelCreating(DbModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); // Configure Code First to ignore PluralizingTableName convention /...

Cannot insert explicit value for identity column in table 'xxx' when IDENTITY_INSERT is set to OF

Ensure to not overwrite the ...CriteriaGroup... with an untracked object, because in this case the ...CriteriaGroup... is considered new....The described issue could happen if for example you don't load the related ...CriteriaGroupFk... when loading the ...Accomplishment..., and afterwards assigning an untracked object to ...CriteriaGroupFk.... To ...

How do process form data and extract properties for two different models/tables using Entity Framework

To store two different databases in ef-core, you need to create two different dbcontexts. ...First, in the appsettings.json file：..."ConnectionStrings": { "DefaultConnection": "Connection string of the database where the quest table is located", "NewConnection": "Connection string of the database where the Heroes table is located" } ...

Oracle Table cannot be found via EF Core

Do you still use dotnet core 2 and EF core 2 ? The oracle ef provider does only support ef core as time of writing (2nd April 2020).. ...https://www.nuget.org/packages/Oracle.EntityFrameworkCore/...This could be an issue...

How do i scaffold DbContext with plural DbSet property names in as.net core EFCore 3?

If you are using Visual Studio, I recommend you use the following extension ...EF Core Power Tools...Among its features is generating code from an existing database and you can configure how to do reverse engineering....More details here