How to get DbSet from entity name in EF Core / .NET Core 2.0 [duplicate]

Question

I have a DbContext with several DbSet<T> properties:

public virtual DbSet<A> A { get; set; }
public virtual DbSet<B> B { get; set; }
public virtual DbSet<C> C { get; set; }
...

In certain scenarios I must now be able to retrieve a specific DbSet with the entity name as string (e.g. when the user enters "A", I need to get the Dbset<A>).

In previous EF versions, the following was possible:

var dbset = Context.Set(Type.GetType(A));

Is there a similar way to do so with the current versions of EF core? I've tried several ways to achieve that, but the only way I have it working at the moment is using a rather ugly switch/case and I would like to get rid of that.

I've found several posts with similar issues around here, but all of them relate to early .NET Core versions or EF5 / EF6.

Answer 1

Do this to add de extension Set(Type t) method to de dbcontext class.

using Microsoft.EntityFrameworkCore;

namespace ApiWebApplication.Utils
{
    public static class MyExtensions 
    {
        public static IQueryable<object> Set (this DbContext _context, Type t)
        {
            return (IQueryable<object>)_context.GetType().GetMethod("Set").MakeGenericMethod(t).Invoke(_context, null);
        }
    }
}

Example:

    // GET: api/Employees
    [HttpGet]
    public IEnumerable<object> GetEmployees()
    {
        return _context.Set(typeof(Employee));
    }