How to create e.ID == id lambda expression dynamically

c# dynamic-linq lambda linq reflection

Question

I've read many great answers here on stack about dynamic creation of lambda expression, but cannot make my own.

I need to select entity from DB by ID, but I don't know its type beforehand. Only name of a type. So: 

var modelType = Assembly.Load("Models").GetTypes().First(t => t.Name == type + "Model"); 
MethodInfo method = typeof(CommonRepository).GetMethod("GetByExpression",
                           BindingFlags.Instance | BindingFlags.Public);



var arg = Expression.Constant(null, modelType);
var body = Expression.Convert(Expression.PropertyOrField(arg, "ID"),
    typeof(int));
var lambda = Expression.Lambda<Func<object, bool>>(body);

var model = method.Invoke(this, new object[] { lambda });

var field = modelType.GetProperty("Disable", BindingFlags.Instance);
field.SetValue(model, false);

this.marathonRepository.SaveOrUpdate(model);

I guess in my code I've made "e.ID" part of lambda. How to make "== id" part?

1
0
9/19/2017 1:22:48 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I try to break the expression up into its parts, using comments to help understand the expression to be built.

Consider the following...

// id
var id = 2;
var idConstant = Expression.Constant(id);
// (object e) => ...
var param = Expression.Parameter(typeof(object));
// (object e) => ((modelType)e).ID
var property = Expression.PropertyOrField(Expression.Convert(param, modelType), "ID"));
// (object e) => ((modelType)e).ID == id
var body = Expression.Equal(property, idConstant);

var lambda = Expression.Lambda<Func<object, bool>>(body, param);
1
9/19/2017 11:53:44 AM

Related Questions

lambdas expressions generated dynamically + linq + OrderByDescending

how can I create a dynamic lambda expression to pass to use in my orderby function inside linq?...I basically want transform ...queryResults.OrderByDescending();... in ...queryResults.OrderByDescending(myCustomGeneratedLambdaExp);... where ...myCustomGeneratedLambdaExp... shall be a string containning ...x => x.name.......Thanks
c# dynamic-linq lambda linq
asked by byte_slave

To Take A Dynamically Built Search Expression As An Extension Method?

We solved this issue without having to use a extension method. We were able to use a similar query that works inside a Where method....So instead of......SelectMany("Names").Where("LastName.Contains(@0)", "Smith").Select("Person") ...We were able to get the same result with the following query that can be inside a Where method....Where.("Names.Sel...
dynamic-linq extension-methods linq
asked by Blane Bunderson

during runtime, dynamically add numerous linq expressions

Ok, I figured it out....I needed to use the "Expand()" method on ALL places where I was calling a predicate in the lines where I was appending the predicate. Here is the new fixed version of the foreach loop in my second method:...foreach (Criteria.SegmentCriteria x in myCriteria) { Criteria.SegmentCriteria item = x; ...
c# dynamic-linq entity-framework linq predicatebuilder
asked by Amanda Kitson

In C#, how do you make a dynamic lambda-based Linq expression from a string?

A similar question was asked here:...Is there an easy way to parse a (lambda expression) string into an Action delegate?...As I understand it, this 'Dynamic Query' is actually a framework for passing in restrictions for a Where clause without using a lambda expression. ...The significance of that is that lambda expressions are not dynamic methods, ...
c# dynamic-linq expression-trees lambda linq
asked by Sprague

How do I create this expression tree (dynamic lambda) in C#?

Are you trying to consolidate your expression tree into a single delegate? If so, here is an example:...public static bool IsOlderThanThreeAndHasAbcProductType(Contract contract) { if (contract.account.Age > 3 && contract.productList.Any(a => a.ProductType == "abc")) { return true; } return false; } List<Contract> ...
c# dynamic-linq linq
asked by Aaron Hawkins

Add second group by key field to existing Lambda Expression

You have a problem, because what the compiler does on a regular ...GroupBy... call is generate a new anonymous type with the properties you define. If the type doesn't exist, we cannot create an expression creating an object of the type....However, given that you are using this for LINQ-to-Objects, we can use the ...Tuple<>... type to generate the ...
c# dynamic-linq lambda linq
asked by felipe

DataTable - Dynamic Linq OrderBy using Lambda expressions

I assume the array you're talking about is an array of strings....var columns = new string[] { "Category", "Country" }; var rows = dt.AsEnumerable().OrderBy(x => 0); foreach(var columnName in columns) { rows = rows.ThenBy(r => string.IsNullOrEmpty(Convert.ToString(r[category]))) .ThenBy(r => Convert.ToString(r[category])); } ...
.net c# dynamic-linq linq
asked by MarcinJuraszek

How to create dynamic entity framework filter expression like Expression<Func<T, bool>>

Yes, you can. One approach I've used uses an object which is the same as your return type as a search filter. So if you want to search for the customer name of "Bill", then you set ...Order.Customer.Name... to Bill. Passing that object to a method then applies all applicable searches....To do this, start by defining a list of searchable fields:...F...
c# dynamic-linq entity-framework lambda linq
asked by Daniel

Extract input parameter name from lambda expression

LambdaExpression... has ...a ...Parameters... property..., which you can use to access information about lambda's parameters. In your case, that could be something like:...string GetParameterName(LambdaExpression expression) => expression.Parameters.Single().Name;
dynamic-linq expression-trees linq linq-to-nhibernate
asked by svick

Dynamically Create WHERE Clause in Razor Page Linq

Ok, I found that I was trying to add another ".Where" (which is possible) but not returning an iList which the data was sucked into. By adding ".ToList()" on the end of my dynamic I was able and will be able to add any dynamic ".Where" criteria I want....at the top: Courses = await _context.Courses .Select(p => new CoursesVM ...
dynamic-linq linq razor-pages
asked by JustJohn

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow