Entity framework core generic query

Question

I have a external DLL with my classes and I would like to make the query depending on the type. I explain better.

I get the type with the function GetType:

Type targetType = Type.GetType("...");

If there is any way to make a select like this:

_context.Set<targetType>().ToList()

Assuming that _context is my DBContext.

Thanks

I'm pretty sure that like statement is what you want _context.Set(typeof(targetType)).ToList() — johnny 5
– johnny 5, Commented Aug 30, 2017 at 15:57

Ricardo Peres · Accepted Answer · 2017-08-30 16:02:52Z

2

Indeed there is:

var method = typeof(DbContext).GetMethod("Set").MakeGenericMethod(targetType);
var query = method.Invoke(ctx, null) as IQueryable;
var list = query.OfType<object>().ToList();

answered Aug 30, 2017 at 16:02

Ricardo Peres

14.8k5 gold badges64 silver badges78 bronze badges

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

Comments

Alen.Toma · Accepted Answer · 2017-08-30 16:13:09Z

-2

Well i did something like that.
Here is an example

Public class repository: dbcontext
{
 public IDbset<car> Cras {get;  set;} 

Public IQueryable<T> Get<T>()
{
return this.gettype().getproberties().find(x=>.  x.propertytype== typeof(T)). Getvalue(this)  as IQueryable<T>;
}
}

Hop this get you started. Writen from moble :)

answered Aug 30, 2017 at 16:13

Alen.Toma

4,8782 gold badges19 silver badges37 bronze badges

Collectives™ on Stack Overflow

Entity framework core generic query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related