Dynamic queries in entity frame work

Question

0.00/5 (No votes)

See more:

Hello Friends,I'm interested in MVC I have one small Doubt.
I want to know how to generate dynamic queries for example.
If i want to retrive items <1500 then i write a query expression for that .now if i like to make more suggestions like size>8 and brand=='Reebok' delivery=2days then what i have to do.should i write query for all the chances.there will number of ways the user can ask query how to answer them dynamically.i heard about expression tress but.
Plz post any answers and real time usage of it.
Thanks.

Posted 3-Jun-14 18:17pm

A.Girish

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*Suvabrata Roy* · Answer 1 · 2014-06-03T18:33:00

Hi,

what you asking is very simple.

IQueryable is the type which will help you to do the same.

In depth details of IQueryable : http://blogs.msdn.com/b/mattwar/archive/2007/07/30/linq-building-an-iqueryable-provider-part-i.aspx[^]

In sort IQueryable will execute the query when you call (ToList,ToArray etc) till that time it will just build the query so you can manipulate the same.

Predicates Builder : http://www.albahari.com/nutshell/predicatebuilder.aspx[^]

It will serve your purpose :Dynamic Querying with LINQ-to-Entities and Expressions[^]