Dynamic Querying for edmx file

Hi,

this can be achieve by Building Predicate dynamically...

for example, I have department master table and I want to retrieved data from this table where department id = 1 then code like....

using (Entities Context = new Entities())
{
    ParameterExpression c = Expression.Parameter(typeof(DepartmentMaster), "dep");

    Expression left = Expression.Property(c, "DepartmentId");
    Expression right = Expression.Constant(1);
    Expression exp = Expression.Equal(left, right);

    var queryableData = Context.DepartmentMasters.Where(Expression.Lambda>(exp, c).Compile()).ToList();

}

also refer
http://drc.ideablade.com/xwiki/bin/view/Documentation/dynamic-projection
http://msdn.microsoft.com/en-us/library/bb882637.aspx

hope this will help you.