Concat the string with linq to entities

.net c# dynamic-linq entity-framework-5

Question

I'm using the Dynamic Linq with Linq to Entities

So, I tested the normal List<Person> with this code and everything's work:

 List<Person> per = new List<Person>();
 per.Add(new Person { IdNo = "1", LastName = "test", MiddleName = "go", FirstName = "let" });
 per.Add(new Person { IdNo = "2", LastName = "hope", MiddleName = "is", FirstName = "way" });
 per.Add(new Person { IdNo = "3", LastName = "must", MiddleName = "be", FirstName = "human" });
 per.Add(new Person { IdNo = "4", LastName = "thing", MiddleName = "anywhere", FirstName = "can" });
 per.Add(new Person { IdNo = "5", LastName = "bird", MiddleName = "fly", FirstName = "away" });

 List<object> paramObjects = new List<object>();
 List<string> fields = new List<string>();
 fields.Add("IdNo == @0");
 paramObjects.Add("1");

 fields.Add("or (LastName + \", \" + MiddleName + \" \" + FirstName).Contains(@1)");
 paramObjects.Add("m");

 var where = string.Join(" ", fields.ToArray());
 var toParam = paramObjects.ToArray();

 var query = per.AsQueryable().Where(where, toParam).ToList();

and when I'm in Linq To Entities approach.

using(var con = new DbContext())
{
   var query = con.Person.Where(where, toParam).ToList();
}

I got this error:

LINQ to Entities does not recognize the method 'System.String Concat(System.Object, System.Object)' method, and this method cannot be translated into a store expression.

My question is:

How to Concat the string using the Linq To Entities base in my example using the Dynamic Linq? Anyone can help me?

1
1
3/7/2013 5:14:39 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

  • Option 1:

    Change the line...

    fields.Add("or (LastName + \", \" + MiddleName + \" \" + FirstName).Contains(@1)");

    ...to

    fields.Add("or string.Concat(LastName, \", \", MiddleName, \" \", FirstName).Contains(@1)");

  • Option 2:

    Open the Dynamic.cs file of the Dynamic LINQ library, search for "GenerateStringConcat" in that file. You should find this method:

    Expression GenerateStringConcat(Expression left, Expression right) {
    return Expression.Call(
        null,
        typeof(string).GetMethod("Concat",
            new[] { typeof(object), typeof(object) }),
        new[] { left, right });
}

    Change the object parameter types to string, that is:

    Expression GenerateStringConcat(Expression left, Expression right) {
    return Expression.Call(
        null,
        typeof(string).GetMethod("Concat",
            new[] { typeof(string), typeof(string) }),
        new[] { left, right });
}

Keep in mind that Dynamic LINQ is not a special "LINQ-to-Entities library", but a general library for IQueryable. There might be Queryable providers that support string.Concat(object, object) with the general object parameter, but LINQ-to-Entities does not. It only supports the string parameter versions of string.Concat. Looking through the Dynamic LINQ file when GenerateStringConcat is actually called (only once) I believe the change above is safe as long as you only want to use the library with LINQ-to-Entities/Entity Framework.

Edit

Option 1 does not work because Concat gets more than four string parameters in the example. It only works up to four parameters because string.Concat has an overload with four explicit string parameters. It doesn't seem to be possible to use the overload with the array parameter params string[] in Dynamic LINQ.

4
3/7/2013 6:20:20 PM

Popular Answer

I had the same problem but with NHibernate, my solution was to modify GenerateStringConcat Method

I change this:

static Expression GenerateStringConcat(Expression left, Expression right)
    {   
        return Expression.Call(
            null,
            typeof(string).GetMethod("Concat", new[] { typeof(object), typeof(object) }),
            new[] { left, right });
    }

For this:

static Expression GenerateStringConcat(Expression left, Expression right)
    {            
        return Expression.Add(
            left,
            right,
            typeof(string).GetMethod("Concat", new[] { typeof(object), typeof(object) })
        );
    }

He has worked quite well :)

Luis Felipe Balam Chan

Related Questions

Generic method for constructing a string Dynamic Linq query. includes strings that have been tokenized

I am using ...Expression.And... and ...Expression.Or... to build dynamic linq queries. When the property/field being queried is a string, and the string contains spaces I would like to tokenize the string on the spaces and create an "And'd" sub query on the tokens....Here is what I mean in a non generic fashion...var tokens = Code.Split(new []{" "}...
dynamic-linq linq
asked by Simon Fox

Linq to Entities does not function with Dynamic Linq.

Test with this code :...var q = adent. ...Contacts.OrderBy("it.FirstName"). Select("New(Title, FirstName, LastName)");
dynamic-linq linq-to-entities
asked by PierrickM

How can I convert a LINQ query to a string and transmit it to a remote server to be parsed into an expression using Roslyn?

Roslyn will eventually give you the ability to take a LINQ expression in string form, parse it, and evaluate it. However, the current public CTP (the one released October 2011) does not support LINQ expressions.
.net c# dynamic-linq linq roslyn
asked by Jason Malinowski

Is it feasible to use string concatenation instead of IDs in a Linq query?

You are missing quotes:....Where("Name = @0 AND AuthoredDate = \"" + dateKey + "\"") ...It seems like a really bad idea to spoil your code like this though. Your original query seems much better.
c# dynamic-linq
asked by Mark Byers

Dynamic LINQ DateTime Comparison String Building - Linq To Entities

I'm using the dynamic LINQ library by Scott Guthrie together with Entity Framework and C#....I have to build my where string into a variable based on several factors and then pass the string variable to the where clause. For some reason, this will work:...ContactList = ContactList.Where("DateAdded >= @0", DateTime.Parse("12/1/2012")); ...But this w...
c# dynamic-linq entity-framework linq string
asked by Ricketts

Get an Entity Object with its child Entity with a condition (using Dynamic Linq)

I figured out how ...Dynamic Expression API... works. As I said I am new to these technologies, I am still learning things....I had to achieve - ...c.CPNDocs.Where(d => d.L_STAT==true).Count()...I thought we have to write an expression in string and ...Dynamic Expression API... will parse it to a real Expression, But I was wrong. we actually have t...
asp.net-mvc-4 c# dynamic-linq entity-framework-5 lambda
asked by dPatel1582

How to construct dynamic LINQ query string be for a query that looks like *abc*def*

It looks like what you need is ...IndexOf.... This returns the starting index of the substring, if it exists, otherwise -1....var.Contains("abc") && var.Contains("def") && var.IndexOf("abc") > var.IndexOf("def") ...For example, if we use the string ...XabcXdefXabc..., ...var.IndexOf("abc")... will yield ...1... and ...var.IndexOf("def")... will...
c# dynamic-linq linq regex
asked by gnalck

Linq Dynamic Query Issue - Operator 'OR' incompatible with operand types 'Boolean' and 'String'

Try this-... You cannot pass string inside a linq statement... valuesList = valuesList.Where(x=>x.position == 1 || x.value.Contains(3))
c# dynamic-linq linq
asked by ISHIDA

Ordering by ICollection property using its name as string with Dynamic Linq Library

You can replace the ...t => t.table2.Select(t2 => t2.field).FirstOrDefault()... with a supported function, ...Min()...:...OrderBy("table2.Min(field)");
asp.net-mvc-5 c# dynamic-linq linq
asked by NetMage

How to do Group Concat in System.Linq.Dynamic

if you are using ...System.Linq.Dynamic... you can concat in your ...Select new... this way...Select("new(name,courseID, (name + courseID.ToString()) as y)") ...Below you have a complete console application so you can test the entire code...class Program { static void Main(string[] args) { List<course> Courses = new...
c# dynamic-linq
asked by Victor Hugo Terceros

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