Entity framework core generic query

Question

Entity framework core generic query

c# entity-framework-core

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

Sergi Riera Sau

Popular Answer

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 :)

Alen.Toma

Related Questions

View more on Stack Overflow

Ricardo Peres · Accepted Answer · 8/30/2017 4:02:52 PM

Accepted Answer

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();

Ricardo Peres

Entity framework core generic query

Question

Fastest Entity Framework Extensions

Accepted Answer

Popular Answer

Related Questions

Fastest Entity Framework Extensions

Performance

Expression Evaluator

Related