Dynamic Querying for edmx file

Question

Hi, In mvc i am working with database first approach,in 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 };

Dynamic Querying for edmx file

Answers (2)