Entity Framework, extending adding "filters"

Question

I have lots of extended "filters" such as this one:

public static IQueryable<Customer> ByCustomerID(this IQueryable<Customer> qry, int customerID) 
{ 
    return from c in qry 
           where c.CustomerID == customerID 
           select c; 
}

To GetCustomers() (IQueryable), such as .ByCompanyID() etc etc, and I would like to add those filters depending on criterias.

Kinda like:

var result = _rep.GetCustomers();

if(useByCompanyID)
    // add .ByCompanyID(companyID) to "result"
if(useByCountry)
    // add .ByCountry(country) to "result"

 // etc etc....

 //do something with "result"

is that possible to do using the entity framework and linq?

/M

amaca · Accepted Answer · 2010-08-26 11:09:57Z

1

Just chain them together:

var result = _rep.GetCustomers();
if (useByCompanyId)
  _rep = _rep.ByCompanyID(companyId);
if (useByCountry)
  _rep = _rep.ByCountry(county);

answered Aug 26, 2010 at 11:09

amaca

1,48013 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Lasse Edsvik Over a year ago

_rep doesnt have any filters, just those methods like GetCustomers()

amaca Over a year ago

_rep is declared as being IQueryable<Customer> ? Then it does have any methods decalred as being extension methods with (this IQueryable<Customer>). And if _rep isn't of IQueryable<Customer> then it needs to be!

Lasse Edsvik Over a year ago

yep, that works. IQueryable<Customers> result = _rep.GetCustomers(); did the trick. Thanks

Collectives™ on Stack Overflow

Entity Framework, extending adding "filters"

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related