EntityFramework – Center.is – Upplýsingatækniráðgjöf og Hugbúnaðarþróun

EF6 core association table schema definition

October 27, 2020 by Geir Sigurður, posted in .net5, English, EntityFramework, Technology

Had some problems with the EF6 – working with 2 tables in the UserManagement schema – created an automatic association table in the dbo schema. Look no further than here for an explanation and solution

#notetoself

EF6 core – reset migrations during development

October 27, 2020 by Geir Sigurður, posted in .net5, English, EntityFramework, Technology

In development and while testing various things in EF6 core – I tend to end up with a lot of migration garbage which occasionally I have to take out. This is how it’s done #notetoself

Delete all *. cs files in the Migrations Folder.
Delete the _MigrationHistory Table in the Database
Delete all database tables subject to the migration (take care of the data 🙂 ).
Run dotnet ef migrations add Reset
Run dotnet ef migrations list to get the full name of last migration
Run dotnet ef database update [migration-name]

#notetoself

EF6 core – load grandchildren in query – the key is ThenLoad

October 26, 2020October 26, 2020 by Geir Sigurður, posted in .net5, EntityFramework, Technology

Working with entity: Tournament

Which has children: TRound with Course as entity that needs to be loaded based on Id ( as each golf round is played on a Course 🙂 )

ctx.Tournaments.Include(c => c.Trounds).ThenInclude(c => c.Course)

Took me a while to figure out why ctx.Tournaments.Include(c => c.Trounds.Select(c => c.Course)) stopped working, but it is a (good) core thingy.