Entity Framework Core - Knowledge Base (KB)

Generate Enum from Lookup Tables - EF 6

This might sound repeated but I have gone through all the available posts but could not figure out the best method in EF 6 version....I have two tables...PersonPhone (PersonID, PhoneTypeID) PhoneType(PhoneTypeID, Description) ...PhoneTypes as just look u...

Entity Framework - DB-First - Composite Foreign Keys

I have a database that has a table with a 2-column primary composite key (one int, one bigint.) I have two tables that have a composite foreign key, referencing the first table's composite primary key. The relationships are (as far as I know,) fine and ...

Use "Attach" as an Upsert in Entity Framework Core

According to ...oneunicorn...,...DbSet.Attach puts all entities in the graph into the Unchanged state. However, entities will be put in the Added state if they have store-generated keys (e.g. Identity column) and no key value has been set....I'm having tr...

Core 2 Keep domain models in sync with database changes

Need help! I am new to Core 2.0 and VS 2017 and haven't had much experience with MVC. I have an existing database that I need to use with a core 2.0 project at work. I was able to use the Scaffold-DbContect to initially create the domain models from the e...

EntityFramework Core database first, Scaffold-DbContext A positional parameter cannot be found that accepts argument '--use-database-names' error

I am trying to create the model from existing DB using EntityFramework Core, database first approach. The model was created, but the table name and column name were changed to C# style. Because I want the model still using exact table name and column name...