Entity Framework - How to load data by name of Entity

Question

Can i load entity data by name as:

using (var db = new DatabaseEntities())
            {
                db["NameOfEntity"].ToList();
            }

Thanks

There is an answer here: http://stackoverflow.com/questions/12455389/entity-framework-get-entity-by-name — sachin, Aug 02 '16 at 08:20
@TimSchmelter: I want build a class that load data dynamic for an entity. Input is name of entity. Do you have any solution? Thank — Hoang Tung, Aug 02 '16 at 09:18

score 0 · Answer 1 · answered Aug 02 '16 at 08:24

0

You can get them by Type

public class DatabaseEntities : DbContext
{

    public object GetList(string entityName)
    {
        return GetList(Type.GetType(entityName));
    }

    private List<TEntity> GetList<TEntity>(TEntity type) where TEntity : class
    {
        return Set<TEntity>().ToList();
    }
}

answered Aug 02 '16 at 08:24

Kahbazi

14,331
3
45
76

Well, if i use say "Employee" for type it'll get type object for Employee and use this type object as generic parameter. Then it'll execute line `Set().ToList();` and it'll obviously throw – Fabjan Aug 02 '16 at 08:56
Thank @Arvin, it's worked – Hoang Tung Aug 02 '16 at 09:20

Entity Framework - How to load data by name of Entity

1 Answers1