EF Core: In a Db first project standardizing Id properties in order to implement a generic repository

Asked Aug 17 '22 at 08:37

Active Aug 17 '22 at 08:37

Viewed 40 times

I have just scaffolded a new database, I want to create a generic repository for crud, but the problem is; DbModels have different Unique Id variable types and names. e.g. Customer.Id, User.UserId, Company.ActuallyRandomPropertyNameId etc.

So I want to rename all of them as 'UniqueId' in DbModels and keep their table column name counterpart as they were, In code first I know 2 different methods to do it. One is giving a [Column("Id")] attribute to the Primary Key property,

the other method is using Fluent API

modelBuilder.Entity<Contact>()
            .Property<int>("ContactId")
            .HasColumnName("Id");

but upon my research data annotations and fluent API are both viable only for code first approach. Is there really no reliable way to this other than manually converting them one by one?

asked Aug 17 '22 at 08:37

Cenko

Maybe EF Core Power Tools regex based renaming could be used? – ErikEJ Aug 17 '22 at 09:58
1

First time I've heard of it but it looks very interesting, I'll look into that! Thanks – Cenko Aug 17 '22 at 15:34

EF Core: In a Db first project standardizing Id properties in order to implement a generic repository

0 Answers0