Dynamic Linq to add LIKE to where clause

dynamic-linq entity-framework linq

Question

I'm trying to perform a LIKE clause in an entity query. The examples I've seen use dynamic linq to do this kind of thing, but my code...

var query = context.StudySet
    .Where("it.PatientName LIKE @patientName", new ObjectParameter("patientName", patientName);

...gives me a System.Linq.Dynamic.ParseException with 

Additional information: Expression of type 'Boolean' expected

context is a DbContext from EF 6 code-first, patientName is a string

Please tell me what's wrong with my code?

1
2
5/23/2017 10:30:09 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I've realised my mistake.

I had assumed the method to pass the query was part of Dynamic Linq but actually it's just a variant of the standard Where method on ObjectQuery. If I get the ObjectContext from my (code first) DbContext it's all good.

ObjectContext objectContext = ((IObjectContextAdapter)context).ObjectContext;
ObjectSet<Study> studySet = objectContext.CreateObjectSet<Study>();

var query = studySet.
    Where("it.PatientName LIKE @patientName", new ObjectParameter("patientName", patientName));
2
5/12/2014 8:02:26 AM

Popular Answer

if you want use DynamicLINQ you need change your code like this

var query = context.StudySet.Where("it.PatientName.Contains(@0)", patientName);

because DynamicLinq can't parse LIKE operator

Grundy

Related Questions

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

Found it, ...db.Table1.AsQueryable()... fixed it, so ...db.Table1.AsQueryable().Where("it.FieldA>10").GroupBy("it.FieldB", "it").Select("key") ... works without exception....The problem was that Microsoft Dynamic Linq library extends ...IQueryable<Table1>..., so it does not take effect on... ObjectQuery<Table1>... which is the type of ...db.Table1....
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

LINQ-to-SQL dynamic table name LINQ-to-SQL

Looks like ...this... is the link you need. ...Update.... Some details: you can use the SearchType method from the post to obtain a type using the table name and then use ...Dynamic LINQ... to write queries you like.
dynamic-linq linq-to-sql
asked by Devart

Multiple table dynamic, Entity Data Model, Dynamic Linq Strongly typed return types, when clause

The solution to my particular query was to do this:... var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute on new {pl.ProductID, pl.WebCategoryID, pl.ParentProductID} equals new {pla.Pro...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

How can I utilize System.Linq.Dynamic for the LIKE operation?

This will allow the ...LIKE... operator on integer fields:....Where(searchField + ".ToString().Contains(@0)", searchString);
asp.net c# dynamic-linq linq
asked by Dino

OrderBy inside a GroupBy using dynamic LINQ?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

Converting a LINQ clause to a dynamic LINQ clause

With all your help I have managed to get the conversion to function. ...Install Dynamic LINQ (I used NUGET. Search online for System.Linq.Dynamic)...Add ...using System.Linq.Dynamic...Query should be of the form... var selectData = (from i in data select i).AsQueryable().Where("Name = @0","Bob1");//@0 is called an identif...
c# dynamic-linq
asked by P.Brian.Mackey

Linq Dynamic Error with Dynamic Where clause

The error points to the place where the LINQ query is evaluated and, as the message says, the problem is that a character is expected but several characters were provided....Check whenever ...ddl_AreaFilter.SelectedValue..., ...ddl_SubAreaFilter.SelectedValue... or ...ddl_AllocFilter.SelectedValue... actually contain a character or a string. If the...
dynamic-linq linq vb.net
asked by jnovo

Dynamic Linq Library can't handling one on many relationship in select clause

This should do it I think. ...var queryBuilder = (from q in db.Questions.Include(itm => itm.Answers) join a in db.Answers on q.QuestionID equals a.QuestionID where a.Email.equals(SearchCriteria) select q).Distinct().ToList(); var questionVM = new List<QuestionVM>(); foreach(var q in queryBuilder) { questionVM.add(new QuestionVM { Que...
asp.net dynamic-linq linq linq-expressions predicatebuilder
asked by Edwin van Vliet

System.Linq.Dynamic.Core vs System.Linq.Dynamic

System.Linq.Dynamic.Core... is more up to date and has more functionality and does also support NET Core / NETStandard (besides net35, net40 and net45 and up)...SelectMany... is indeed supported....For more information see the ...github... page and browse the examples, unit-tests and help page....Note: I'm the maintainer from this project.
dynamic-linq
asked by Stef Heyenrath

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