ModelBuilder | easy creation and data population

I have a DbContext named FileManagerContext in my DOTNET 6 API:

I get on creating Migration some Warnings like this one:

The foreign key property 'AppUserClaim.UserId1' was created in shadow state because a conflicting property with the simple name 'UserId' exists in the entity type, but is either not mapped, is already used for another relationship, or is incompatible with the associated primary key type. See https://aka.ms/efcore-relationships for information on mapping relationships in EF Core.

It applies to all entities with AppUser navigation property. Other navigation properties has no warning.

h2o version: h2o-3.34.0.3 (rel-zizler)

Java version: openjdk version "15.0.2" 2021-01-19 (installed with: FROM adoptopenjdk:15-jre-openj9-focal)

I want to build an XGBoost model using Java 15, but the same code with the same data which runs without issues on Java 14 (openjdk version "14.0.2" 2020-07-14) fails on Java 15, producing the following error messages:

So I am migrating a project from .NET Core 3.1 to .NET Core 6 and would like to scaffold a new context class. Here is the SQL for my db:

To seed type tables in Entity Framework Core, I am rewriting this same code in the function 'StopLightColorTypeList' for every database type table that I need seed. I'm looking to create a generic method.

Disclaimer:I am trying to learn more about net 6.0 and am a rookie.

Here is what i am trying to do:

• I am trying to access IConfiguration file in a TransparencyContext but i keep on getting configuration being null error:System.ArgumentNullException: 'Value cannot be null. (Parameter 'connectionString')'.

Here is what I did:

• updated the dbContext's constructor to inject IConfiguration config

Most of this Context file is automatically generated and the only thing i did was updated the public TransparencyContext(IConfiguration config) to include the Iconfig so i could access it in optionsBuilder.UseSqlServer(config.GetConnectionString("SQLDB"));

TransparencyContext.cs

We have recently upgraded our project to Microsoft.EntityFrameworkCore 6.0.0. This release enables SQL Server temporal tables out of the box.

https://devblogs.microsoft.com/dotnet/prime-your-flux-capacitor-sql-server-temporal-tables-in-ef-core-6-0/

https://stackoverflow.com/a/70017768/3850405

We have used temporal tables since Entity Framework Core 3.1 using custom migrations as described here:

https://stackoverflow.com/a/64776658/3850405

https://stackoverflow.com/a/64244548/3850405

Simply following Microsofts guide will of course not work since default column names are PeriodStart and PeriodEnd instead of our SysStartTime and SysEndTime. History table name does not match either.

I tried to build a drop-down list from the AspNetRoles table in register.cshtml and register.cshtml.cs but didn't get data from AspNetRoles in the register page.

.....................................................................................................................................................

RoleController:

My error in Package Manager Console:

The property or navigation 'MenuId' cannot be added to the entity type 'ThAmCo.Catering.Models.FoodBooking' because a property or navigation with the same name already exists on entity type 'ThAmCo.Catering.Models.FoodBooking'.

I am trying to create a database for an assignment, however, I am stuck on this error.

This is my current DbContext: