How to create two table from one class by EF Core

Question

I have a class for users :

public class users
{
    public int UserId { get; set; } 
    public string UserName { get; set; }
    // ....
}

I want to create a table called users. I write this line in AppDbContext.cs:

public Dbset<users> Users { get; set; }

it works correctly.

But when I add this line after the previous one:

public Dbset<users> UserChanges { get; set; }

no change happened in the migration file.

How I can have both users and userchanges tables in database, generated by EF Core with a code-first approach?

Why do you want this? Please provide some background. Either way, EF maps classes to tables, not DbSet names. — Gert Arnold
– Gert Arnold, Commented Feb 26 at 8:44

Vishal Solanki · Accepted Answer · 2025-02-26 11:00:19Z

3

Yes, you can modify your UserChanges class to inherit from users.

public class UserChanges : users
{
    public DateTime ChangeDate { get; set; }
}

After that, you need to Update AppDbContext.

public class AppDbContext : DbContext
{
    public DbSet<users> Users { get; set; }
    public DbSet<UserChanges> UserChanges { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<users>().ToTable("users");
        modelBuilder.Entity<UserChanges>().ToTable("userchanges");
    }
}

answered Feb 26 at 11:00

Vishal Solanki

1502 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vishal Solanki · Accepted Answer · 2025-02-26 08:42:25Z

1

you need to define a separate entity class for UserChanges, even if it shares similar properties.

public class users
{
    public int UserId { get; set; } 
    public string UserName { get; set; }
    // ....
}

public class UserChanges
{
    public int UserId { get; set; } 
    public string UserName { get; set; }
    // ....
}

public Dbset<users> Users { get; set; }
public Dbset<UserChanges> UserChanges { get; set; }

answered Feb 26 at 8:42

Vishal Solanki

1502 bronze badges

2 Comments

Hosein Ghasemi Feb 26 at 9:51

It's OK, but my user class has over 80 property and may change over time, Isn't any way to use one class?? Can I create a separate class inherited from Users? public class UserChanges:users {};??

Gert Arnold Feb 26 at 10:24

even if it shares similar properties -- Why?

Collectives™ on Stack Overflow

How to create two table from one class by EF Core

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related