Linq dynamic where count?

c# dynamic-linq linq where

Question

Is it possible to use list in where. I want somethink like this:

public class Customer
{
    string FirtsName;
    string LastName;
    int Number;
    .....
}

I want to filter customers with using checkboxes. If I select FirstName and Number then where clause will be generated

.where(x=> x.FirstName == "SomeFirstName" && x.Number == someNumber)

If I select only number then where clause will be generated

.where(x.Number == someNumber)

If I select FirstName, LastName and Number then where clause will be generated

.where(x=> x.FirstName == "SomeFirstName" && x.Number == someNumber && x.LastName == "LastName")

I mean not only dynamic column names, also I want to generate where clauses count, too. Column names and values are came from list:

I hope, I can explain. Thanks in advance.

1
1
12/14/2012 3:39:42 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You could give Dynamic LINQ a try. With this you could write something like:

var db = new NorthwindDataContext;
var query = db.Products.Where("CategoryID=2 And UnitPrice>3").OrderBy("SupplierId");
1
12/14/2012 3:55:12 PM

Popular Answer

Use more then one step to generate the query:

var query = originalList.AsQueryable();

if(/*Filtering on First Name*/)
{
  query = query.where(x => x.FirstName == FirstNameSearchString);
}

if(/*Filtering on Last Name */)
{
  query = query.where(x => x.LastName == LastNameSearchString);
}

if(/*Filtering on Number*/)
{
  query = query.where(x => x.Number== NumberSearchString);
}

//..And so on

//Do stuff with query

If you don't want to do the multiple if statements I can think of two other ways:

  • Build your own expression trees by hand:

Expression Trees (C# and Visual Basic) How to: Use Expression Trees to BUild Dynamic Queries (C# and Visual Basic)

The other method is to create a complex where clause that used ANDs and ORs to only filter if this column searc option is selected:

.where(x => (IsFirstNameFilter == true && x.FirstName = FirstNameData) || (IsLastNameFilter == true && x.LastName = LastNameData) || ...);

With this one, you want to be careful about the execution time, hook up SQL Profiler to see what is happening.

I still recommend the first option.

SBurris

Related Questions

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

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 work together with dynamic Where in dynamic LINQ?

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

Dynamic table name linq-to-sql dynamic LINQ

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

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

Can any body tell me how can I use a LIKE operator using ...System.Linq.Dynamic...?...I need to add more than one ...LIKE... expression in my dynamic ...where query.../* var query = db.Customers. Where("CityName Like @0 or CityName Like @1", "London", "USA") */ var query = db.Customers. Where("CityName Like @0 or CityName Like @1%", "London", "USA"...
asp.net c# dynamic-linq linq
asked by Kiarash

Counting percent of rows with category out of total number of rows using Dynamic Linq

Desired result is in q and q2.... q shows combination of aggregates from different levels of grouping in one expression.... q2 uses calculated agg from prev levels and generates shorter SQL query....var grp=(db.A as IQueryable).GroupBy("grp","it"); var grp2=grp.Select("new(key as key,new(count() as cnt) as agg)"); foreach(dynamic r in grp2) Console...
dynamic dynamic-linq grouping linq
asked by alpav

Use Any() and Count() in Dynamic Linq

If you HAVE to use Dynamic Linq, your query should look like that:...db.Customers.Where("Orders.Count(ShipVia == 2) > 3");
asp.net c# dynamic-linq linq linq-to-sql
asked by ITmeze

LINQ (Dynamic): OrderBy within 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

Aggregate function Count() using dynamic linq query

The following two queries will give you the exact same result: first with lambda second result without.... var Table1 = new List<Row>(); for (int i = 0; i < 10; i++) { for (int m = 0; m < 5; m++) { for (int x = 0; x < i + m; x++) { Table1.Add(new Row...
c# dynamic-linq linq linq-to-entities sql
asked by MichaC

How to write dynamic Linq to count matching numbers

I have two tables in database. Ticket and TicketNumbers. I would like to write Linq to count the number of tickets that have numbers matching those passed into this function. Since we don't know how many numbers must be matched, the Linq has to be dynamic ... to my understanding....public int CountPartialMatchingTicket(IList<int> numbers) { // ...
asp.net-mvc-4 c# dynamic-linq entity-framework linq
asked by Peter Mercury

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