How to build Dynamic Linq from Request.QueryString?

Question

I'm currently working on feature to implement/build a filter through Request.QueryString. The idea here is the filter can be on any property with in the Model For ex.,

public class Alert{
    public string Name;
    public string Status;
    public Datetime StartDate;
    public Datetime EndDate;
    public bool IsActive;
}

so the calling client wants to pass something like this in the query string startdate >=2013-10-1&Name=John&IsActive=false. I'm using System.Linq.Dynamic from Scottgu to build the where clause which takes a string but the format to build is kind of killing me. I need some pointers on the format and I'm doing the type checking through reflection before executing this and also I'm filtering this against the data that came back from DB and not passing this into the db.Any help is really appreciated!

Actually this is a Rest API :) but this is how they want to do it — Ram, Oct 19 '13 at 20:16

DarcyThomas · Answer 1 · 2013-10-21T20:00:05.050

0

Don't reinvent the wheel if you don't need to :P

Have a look at Odata, and the .net web.api

That should do what you need.

edited Oct 21 '13 at 20:00

answered Oct 21 '13 at 08:45

DarcyThomas

1,218
13
30

How to build Dynamic Linq from Request.QueryString?

1 Answers1