LinQ query Simple Where clause and many filter criteria

.net c# ef-code-first entity-framework-6 linq

Question

I need to filter data entity but there is no predefined columns, which I will have to filter.

public class EventDocument
{
    public string ID1 { get; set; }
    public int ID2 { get; set; }
    public string FirstName { get; set; }
    public string LastName { get; set; }
    public string Number { get; set; }
    public virtual ICollection<Event> Events { get; set; }
}

I created all needed properties: SearchFirstName, SearchLastName, SearchNumber

And now I am trying to filter EventDocument by these parameters entered by user. If user enters value into SearchFirstName, my query will look like this:

var query = from b in DBContext.EventDocuments
                    where b.FirstName.Contains(SearchFirstName)
                    select b;

If user enters values to SearchFirstName and SearchLastName, my query will look like this:

var query = from b in DBContext.EventDocuments
                        where b.FirstName.Contains(SearchFirstName) 
                        && b.LastName.Contains(SearchLastName)
                        select b;

And how to construct query if I don't know - which filed user will fill? Maybe he will enter value to SearchLastName and SearchNumber...

1
2
4/26/2018 6:44:39 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Predicate Builder is an effective way.

Put following code in static PredicateBuilder class,

 public static Expression<Func<T, bool>> ContainsPredicate<T>(string memberName, string searchValue)
        {
            var parameter = Expression.Parameter(typeof(T), "m");
            var member = Expression.PropertyOrField(parameter, memberName);
            var body = Expression.Call(
                member,
                "Contains",
                Type.EmptyTypes, // no generic type arguments
                Expression.Constant(searchValue)
            );
            return Expression.Lambda<Func<T, bool>>(body, parameter);
        }

In your cs file, 

var filterResults = PredicateBuilder.ContainsPredicate<Employee>(columnName, searchName);

And yourLinqQuery.Where(filterResults);

For Reference: Predicate Builder Details

2
7/18/2017 12:15:50 PM

Popular Answer

You could do something like this

var query = DBContext.EventDocuments;

if(!string.IsNullOrEmpty(SearchFirstName))
{
    query = query.Where(x => x.FirstName.Contains(SearchFirstName));
}
if(!string.IsNullOrEmpty(SearchLastName))
{
    query = query.Where(x => x.LastName.Contains(SearchLastName));
}

var result = query.ToList();

and building your query based on what conditions you need.

Mighty Badaboom

Related Questions

Where IN clause in LINQ to Entities query

I think answer lies somewhere along these lines......Array a = {1,2,3,4,5} ...WHERE a.Contains(ID)
c# entity-framework sql
asked by Peter Perháč

Delete From DataContext Using ID == ID with a simple LINQ query

DataContext.Items.DeleteObject((Item)DataContext.Items.Where(item => item.ItemId == selectedId).First()); ...Don't forget to prevent error you'll need to ensure that the id you're checking on is of an actual ...Item.... Something like this, for example:...var item = (Item)DataContext.Items.Where(item => item.ItemId == selectedId).FirstOrDefault(); ...
c# entity-framework linq
asked by doctorless

WHERE clause with many criteria in a LINQ query

According to your logic, if x.Class1 is not null, but x.Class1.SomeNumber is 3, it won't check all the other clauses....If you want to check, if just some ...ClassN.SomeNumber == SomeNumber..., then you should do it like this:...int SomeNumber = 1; // some number List<SomeClass> retValue = result .Where(x => { if (x.Clas...
entity-framework linq
asked by LueTm

How can I build a LINQ IN clause query that also acts as a LIKE operator?

In order to fulfil your requirement about returning all items if none are specified, you need to check for the lists being empty. ...var brands = brandid.Split(',').Select(x => Int32.Parse(x)); var styles = bodystyleid.Split(',').Select(x => Int32.Parse(x)); var result = from c in car where (!brands.Any() || brands.Contains(c.brandid)...
entity-framework in-clause linq linq-to-entities sql-like
asked by Richard

Building dynamic where clauses in LINQ to EF queries

Here's an example using ...System.Linq.Expressions.... Although the example here is specific to your ...Claim... class you can make functions like this generic and then use them to build predicates dynamically for all your entities. I've been using recently to provide users with a flexible search for entities on any entity property (or groups of pr...
entity-framework linq
asked by user1914530

Simple SELECT WHERE LINQ Query to a list

This will work...return db.sims.Where(x=>x.has_been_modified).ToList(); ...method Linq looks cleaner here ...you don't need to check your bool against true...in your previous answer you used ...s... as context and selected ...x..., changing to ...select s... should work also...Consider using lazy loading and don't add ...ToList... at the end of eve...
c# entity-framework linq
asked by Kamil Budziewski

Call custom function in EF LINQ query Where clause

Just to answer my own question:...I'm going to follow this thread to create a AndAlso expression to solve my problem....Extension method in where clause in linq to Entities
code-first ef-code-first entity-framework-6 linq
asked by ozstudent

Linq Query with a Where clause in an Include statement

You cant have a ...Where... inside the ...Where..., but you can use ...Any... which will return a boolean...var result = ctx.Offenders .Include(o => o.Fees) .Include(o => o.ViolationOffenders) .Include(o => o.ViolationOffenders.Select(of => of.Violation)) .Where(o => o.YouthNumber != "" && o.FirstName != "" && o.Fees.Any(f=...
asp.net c# entity-framework linq
asked by Jamiec

Why does this linq query fail when I change the select clause to select new Model

That's cause ...Room... is one of your mapped entity and projecting to a mapped entity is not allowed. You will have to use a DTO or project to an anonymous type.
ado.net-entity-data-model asp.net-mvc-5 c# entity-framework-6 linq
asked by Rahul

How to pass an Expression into Entity Framework LINQ query OrderBy clause

This isn't as simple as it seems. You need to combine ...Expression...s or build ...Expression...s to generate what you want, and unfortunately C# doesn't include a lot of help in that area....The easiest approach is to use an extension method for ...LambdaExpression... composition. It depends on some ...Expression... extension methods for replacin...
c# entity-framework-6 expression lambda linq
asked by NetMage

Fastest Entity Framework Extensions

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

Prime Library

Performance

Expression Evaluator

More Projects...

Related

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