Custom string in linq to entity select new

Question

Is there any way to customize it?

This is what Im trying to do:

string customSelect = "c.person_name";
int per = PersonID();
var RetrievItem = (from c in db.person where c.person_id == per select new { customSelect }).FirstOrDefault();

I've tried to debugging it but it just ended up retrieving given string instead of value from database

Any suggestions @_ @?

@Mostafiz cause that string is coming dynamically and is gonna be different every time @_ @ — Harugawa
– Harugawa, Commented Oct 12, 2016 at 9:32
@gayan1991 yeah, it says that my db model does not contains definition of fk — Harugawa
– Harugawa, Commented Oct 12, 2016 at 10:09

bkaf · Accepted Answer · 2016-10-12 09:42:06Z

3

In addition to Hamlet's comment about an expression based solution, you can have a look at the Dynamic Linq library. It supports lamba expressions defined as strings, which is exactly what you need.

edited Oct 12, 2016 at 9:42

answered Oct 12, 2016 at 9:36

bkaf

4866 silver badges16 bronze badges

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

5 Comments

Ivan Stoev Over a year ago

I would rather say this is the only possible dynamic select solution so far because you cannot create anonymous types at runtime, which Dynamic LINQ solves by creating dynamic classes at runtime. +1

Adil Mammadov Over a year ago

@IvanStoev, no it is possible to create dynamic type at runtime

Ivan Stoev Over a year ago

@AdilMammadov It's possible, but hard. And not anonymous type which is compiler feature.

Adil Mammadov Over a year ago

@IvanStoev, I agree with that it is hard, especially, when you add properties instead of fields (link) :).

Ivan Stoev Over a year ago

@AdilMammadov Yeah :) Dynamic LINQ has a handy DynamicExpression.CreateClass() method which does all that, and also implements correctly Equals and GetHashCode plus the caching.

Collectives™ on Stack Overflow

Custom string in linq to entity select new

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related