Using dynamic where clauses in Entity Framework

Question

I am trying to re-design a data access layer that was originally built using Raptier. Raptier generats methods that accept a where clause as a parameter to be passed in to a stored proc. I really need to retain the existing mesthos signatures, so my new DAL needs to accept where clauses as well. I want to use the more up-to-date data access technologies and techniques, so was thinking about using Entity Framework from .Net 4.0.

However, it doesn't look like I can accept dynamic where clauses without implementing some intense reoutines to parse them into lamba expressions. Is there something I've missed? Am I out of luck with Entity Framework?

Thanks, Marc

Perhaps you should show us some code. I don't think many people know how that Raptier stuf looks like. — Steven
– Steven, Commented Nov 16, 2010 at 19:55

Steven · Accepted Answer · 2010-11-17 14:21:53Z

7

Two ideas come in mind.

1). Dynamic LINQ, which allows you to define where operators as strings.

var result = Northwind.Products
    .Where("CategoryId=2 And UnitPrice>3")
    .OrderBy("SupplierId");

2). Use something as the EntityFilter<T> (see code here), which allows you to define a filter like this:

IEntityFilter<Person> entityFilter =
    from person in EntityFilter<Person>.AsQueryable()
    where person.Name.StartsWith("a")
    where person.Id < 100
    select person;

You can supply the IEntityFilter<Person> to a business method that will be able to filter that query:

public static Person[] GetAllPersons(
    IEntityFilter<Person> filter)
{
    using (var db = ContextFactory.CreateContext())
    {
        IQueryable<Person> filteredList =
            filter.Filter(db.Persons);

        return filteredList.ToArray();
    }
}

edited Nov 17, 2010 at 14:21

answered Nov 16, 2010 at 20:02

Steven

174k27 gold badges355 silver badges453 bronze badges

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

2 Comments

MCalder Over a year ago

Steven's option 1 looks closest to what we are doing now. This just might work! Thanks all for your responses!

The Muffin Man Over a year ago

Dynamic LINQ looks really neat.

Artemiy · Accepted Answer · 2010-11-16 20:01:17Z

0

You can use ExecuteStoreQuery method to execute raw commands against the database. http://msdn.microsoft.com/en-us/library/ee358769.aspx

answered Nov 16, 2010 at 20:01

Artemiy

1,97914 silver badges19 bronze badges

Comments

Antony · Accepted Answer · 2010-11-16 20:05:58Z

0

Check out Rick Strahl's blog post here: http://www.west-wind.com/weblog/posts/160237.aspx. His demo uses Linq to SQL but it wouldn't be far different in EF. This approach involves exposing the IQueryable to the business layer. It is not without controversy, but it's something to consider.

With the IQueryable exposed, you can write LINQ queries against the returned collection. I'm not promising that you'll be able to make it work with sprocs, but give it a try.

edited Nov 16, 2010 at 20:05

answered Nov 16, 2010 at 20:00

Antony

1,4611 gold badge12 silver badges25 bronze badges

Comments

zaheer · Accepted Answer · 2014-03-07 14:07:18Z

-1

face same problem,, now the raptier discontinued might be,, well so

i have a clue,, as i am using lite version which support only 15 tables/views.. here is a short cut,,

always take a dummy test db in the server,, and generate the classes which you want, then merge it with your class library solution, rebuild the solution, and move on like that to the extent you want,,

its laborious but its work.

need more help,, with glad...

answered Mar 7, 2014 at 14:07

zaheer

791 silver badge1 bronze badge

Collectives™ on Stack Overflow

Using dynamic where clauses in Entity Framework

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related