Using reflection to get select fields in linq query

Question

I use Linq for my queries and want to get a list of properties that I want to return in the "select" section using reflection. I tried the following to no avail:

string[] paramList = new[]{"AppId","Name"};
var query =
                from entity in
                    _ctx.App
                select new {entity.GetType().GetProperties().Where(prop=>paramList.Contains(prop.Name) )};

What am I missing here?

Answer 1

When working with reflection inside an EF request, you will need to write the expression yourself. Look at this existing question for more information.

• Linq and Generics help. Using GetValue Inside a Request
• How to reflect T to build an expression tree for a query?
• IQueryable <> dynamic ordering / filtering with GetValue fails

Linq, , , Entity Framework .

Answer 2

, , , , . , ( ) . , , - select ( API- , System.Linq.Expressions), , , Select() ( , ).

, , , - , , , .

, ?