How to use dynamic DbSet in Entity Framework?

Question

PHP

Good afternoon. Can you please tell me how to select a DbSet depending on a string type variable? What is in short:

public class DataContext : DbContext
    {
        public DataContext() : base("myDb") { }
        public DbSet<User> Users { get; set; }

        public DbSet<Entry> RurEntries { get; set; }
        public DbSet<Entry> UsdEntries { get; set; }
        public DbSet<Entry> EurEntries { get; set; }
    }

There is a table for each of the currencies: RUR, USD, EUR, all tables are identical in the fields.
There is a variable of type string CurrentCurrency, which takes the value of one of the currencies.
It would be desirable that depending on CurrentCurrency one of DbSet'ov was used.
Thanks in advance for your advice.

Answer 1

photoshop - use filters along the path

Answer 2

You need to define this in the OnModelCreating method of the class

protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
           string table = "USD" //Здесь сделать выбор строки-имени таблицы по нужному параметру
           modelBuilder.Entity<Entry>().ToTable(table);

            base.OnModelCreating(modelBuilder);
        }