Entity Framework, Make SystemVersioning Columns as NotMapped for Temporal tables Automatically

Question

Entity Framework does not seem to handle System Versioning columns well (StartDate, EndDate) for temporal tables. When we scaffold a database automatically, we want to place SystemVersioning Columns as NotMapped. Is there a parameter in commandline to make System Versioning Columns automatically as not mapped? Company literally 1000s of tables, and need way to make them automatically NotMapped, everytime we rescaffold. Scaffolding is done very week.

dotnet ef dbcontext scaffold

Are you scaffolding from a database project? In that case EF Core Power Tools may be able to assist — ErikEJ, Jun 10 '20 at 19:04
hi @ErikEJ we are scaffolding from existing database in localhost, however we have database project also — , Jun 10 '20 at 19:06
Do you want the columns no mapped or rather not scaffolded at all? — ErikEJ, Jun 11 '20 at 05:18

score 0 · Accepted Answer · edited Jun 15 '20 at 05:22

0

Make the columns HIDDEN, and they will not be scaffolded.

ALTER TABLE [dbo].[Account] ALTER COLUMN [StartDate] ADD HIDDEN;

hide a column from table in MS SQL Server

edited Jun 15 '20 at 05:22

julianstark999

3,450
1
27
41

answered Jun 11 '20 at 08:02

ErikEJ

40,951
5
75
115

Entity Framework, Make SystemVersioning Columns as NotMapped for Temporal tables Automatically

1 Answers1