Dynamic Querying for edmx file

Question

Hi In mvc i am working with database first approachin this after adding tables it will generate edmx file.By using this can i do dynamic query?

Jignesh Trivedi · Answer

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.

Ramesh Maruthi · Answer

SasiReddyEntities ctx = new SasiReddyEntities(); var sasiItems = from p in ctx.sasiItems where p.Category.CategoryName == Beverages Select new { ID = p.ProductID Name = p.ProductName NumOrders = p.OrdersDetails.Count };