How can I get Class name using Table name on EntityFramework

Question

I can get Table name from Entity/Class name but I need to get Class name from Table name.

[Table("MyAccount")]
public class Account
{ public string abc {get; set;}}

I want to get Account class from controller using "MyAccount" string.

I want to get the class details like class name using table name parameter and DbContext. I don't want to access table.

Possible duplicate of [DbSet table name](https://stackoverflow.com/questions/6598857/dbset-table-name) — Alexander Derck, May 29 '18 at 08:17

score 0 · Answer 1 · answered May 29 '18 at 08:12

I am not sure that I understand your question. Normally you define a DbSet<Account> in your DbContext and use this set to access the table. No need to pass the table name anywhere!

public class MyDbContext : DbContext {
    public IDbSet<Account> Accounts { get; set; }
}

using (var context = new MyDbContext()) { 
    var theAccount = context.Accounts.Find(accountId);
    var abc = theAccount.abc;
}

If you need dynamic access, use the DbContext.Set method.

Type accountType = typeof(Account);
var allAccounts = context.Set(accountType).ToArray();

See Entity Framework Working with DbContext.

This answer shows how to get the DbSet by table name: Dynamically access table in EF Core 2.0

I want to get the class details like class name using table name parameter and DbContext. I don't want to access table. — deloyar, May 29 '18 at 08:38

How can I get Class name using Table name on EntityFramework

1 Answers1