Dynamic LINQ: Use .NET Contains method to generate a dynamic search method

dynamic-linq linq

Question

I have a class Item like

public class Item
{
   public int Id {get;set;}
   public string Name {get;set;}
   public string PartialDescription {get;set;}
   public string FullDescription {get;set;} 
   public doulbe Price {get;set;}
}

I would like to have a dynamic custom query method SearchOverAnyFields() that can accept any number of Item object's properties like:

// key is an input string variable

// one query 
var results = myItems.SearchOverAnyFields(x => x.Name.Contains(key) || x.PartialDescription.Contains(key) || x.Price.ToString().Contains(key));

// or another query 
var results2 = myItems.SearchOverAnyFields(x => x.Name.Contains(key) || x.PartialDescription.Contains(key) || x.Price.ToString().Contains(key) 
|| x.FullDescription.Contains(key));

// or another query
var results3 = myItems.SearchOverAnyFields(x => x.PartialDescription.Contains(key) ||  x.FullDescription.Contains(key));

Please help.

1
1
2/21/2012 4:49:05 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I'm not really sure what you're looking for here - the functionality you want can be easily achieved with the Where operator.

var results = myItems.Where(x => x.Name.Contains(key) || 
    x.PartialDescription.Contains(key) || x.Price.ToString().Contains(key));

// or another query 
var results2 = myItems.Where(x => x.Name.Contains(key) || 
    x.PartialDescription.Contains(key) || x.Price.ToString().Contains(key) 
    || x.FullDescription.Contains(key));

// or another query
var results3 = myItems.Where(x => x.PartialDescription.Contains(key) ||  
    x.FullDescription.Contains(key));

Does this meet your requirement?

1
2/22/2012 1:02:42 AM

Related Questions

How to do the following in Dynamic Linq using System.Linq.Dynamic namespace

I just want to know how to do the following in Dynamic Linq using System.Linq.Dynamic namespace...var query2 = db.Customers.Select( cust => new Customer { FirstName = cust.FirstName, LastName = cust.LastName Tags="sampleTag,Tag" ...
dynamic-linq linq
asked by emem

Does dynamic GroupBy work together with dynamic Where in dynamic LINQ?

I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key")... works.... But ...query=db.Table1.Where("it.Fi...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

Dynamic table name linq-to-sql dynamic LINQ

I want to construct my query dynamically based on the contents user has selected, and I want to do this in LINQ-t0-SQL. I have seen ...this..., but I don't want to use SQL statements with datacontext....On Googling a bit I have a feeling that this can be done using dynamic LINQ. Would someone provide an example of similar scenario with dynamic LINQ...
dynamic-linq linq-to-sql
asked by Muhammad Adeel Zahid

Entity Data Model, Dynamic Linq, multiple table dynamic Where clause, strongly typed return types

When writing a method for an oData service I have the below linq, for which I need to have a dynamic "where" clause to filter the results (the "new"s in the joins are for composite PKs in the Entity Data Model):...var query = from pl in CurrentDataSource.ProductListing join pla in CurrentDataSource.ProductListingAttribute ...
anonymous-types c# dynamic-linq linq-to-entities
asked by rposbo

How to use Dynamic LINQ (System.Linq.Dynamic) for LIKE operation?

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

LINQ (Dynamic): OrderBy within a GroupBy using dynamic linq?

I had the following query using normal linq and it was working great (using anonymous type),... var result = from s in Items group s by s.StartTime into groupedItems select new {groupedItems.Key, Items= groupedItems.OrderBy(x => x.Name) }; ...But using Dynamic Linq I cannot get it to order by within the groupby.... r...
dynamic-linq linq linq-to-objects
asked by Martin

how I can get insert method more flexible using dynamic linq?

ScottGu has a ...Dynamic Linq... library you can use.
c# dynamic-linq entity-framework
asked by Robert Harvey

Using Linq.Dynamic where method with a dynamic list gives error

I am reading some JSON and converting it to a dynamic list. Below is My Code:...dynamic data = JObject.Parse(response); var result = data.result; var result = ((IEnumerable)arr).Cast<dynamic>().ToList(); var id = result[0].id; var filtereddata = result.Where("id==1"); ...The line...var filtereddata = result.Where("id==1"); ...Gives error ...No pro...
c# dynamic dynamic-linq linq
asked by Anshuman Jasrotia

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

What is the difference between System.Linq.Dynamic.Core and System.Linq.Dynamic? I am currently using System.Linq.Dynamic and it does not contain support for ...Select... and ...SelectMany... (among other extension methods). Does System.Linq.Dynamic.Core support these methods?
dynamic-linq
asked by jjf1978

C#, dynamic linq error No applicable method 'Contains' exists in type 'String'

I have a list of objects like this (I am using .NET 3.5)...public class MyObjects { public object Name { get; set; } public bool Case { get; set; } } List<MyObjects> test = new List<MyObjects> { new MyObjects { Name = "one" }, new MyObjects { Name = "two" }, new MyObjects { Name = "three" }, new MyObjects { Name = "four" ...
c# dynamic-linq linq
asked by orfruit

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