Dynamic LINQ - Knowledge Base (KB)

ASP.NET MVC Authorization based on role membership or data relation (ownership)

I'd like to extend the AuthorizeAttribute in ASP.NET MVC so that it supports the concept of a user's authorization being based on their role membership OR "ownership" of the data in question. I'm using LINQ2SQL for data access. There is a similar question...

Make a dynamic query with Linq using a drop down list selected option in Asp.net MVC

I'm trying to accomplish this with Linq to Sql and Asp.Net MVC: ...I have a Drop Down List with options Country, City and State. And beside it, there is a textbox. So, an user will, for instance, select City and will type "new york city" in the textbox an...

How can I sort a list based on a user's selections in ASP.NET MVC?

I have a list of customers that can be sorted by anywhere from 1 to 6 fields based on a user's selection. The sort fields can be in any order. If I know the fields and the sequence ahead of time, sorting is easy:...customers = customers .O...

Dynamic Linq/ Dynamic Query: cannot get data for jqGrid

I'm using jqGrid and I have a problem getting Dynamic Linq to work. I used NuGet to install Dynamic and added "using System.Linq.Dynamic;"....Using VS 2010 Pro, MVC 3.0...This works:...var s = context.testdata; var c = s.Count(); ...c shows 5136 items....

At least one object must implement IComparable?

Model:...return (from m in meterReadings group m by new { date = m.ReadDate } into g select new { ReadDate = g.Key.date.ToString("dd.MM.yyyy - HH:mm:ss"), T1 = from t1 in g where t1.Name == "T1" ...

Cannot check the same property twice using dynamic linq

I'm building an MVC app which will have to build dynamic linq queries to the server, and I'm facing something that puzzles me....Up to now I'm able to make a query like this:...var objQry = from o in m_DB.OBJECTS.Where(whereConditions) select...

Dynamic Linq Query not working with DateTime field

I am using Dynamic linq to provide my MVC app with data and I have trouble with DateTime fields....The objects I'm parsing through has a System.Datetime field and I want to check if the dates correspond....So I try to build the string like this (I'm parsi...

How to build Dynamic Linq from Request.QueryString?

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 Dat...

Pass in a field name at run time using Dynamic LINQ library?

This is a small application used on a company intranet by 4 people at the most, and I am new to C# and .NET, so the solution does not have to be grandiose....I am trying to create a search field for simple .NET C.R.U.D app where the user can pick a catego...

Querying dynamic in asp.NET with SQL server

(If the title isn't representative for this question please say so, I couldn't come up with a good short description)...I'm trying to implement an advanced search function for my web application. This search has to be able to search on a lot of possible c...

how to order by a dynamic column name in EntityFramework?

I am trying to get following code working , This was working fine for MSSQL , but since i changed to use mySql it is not working... records.Content = db.areas .Where(x => x.Name.Contains(filter))) .Orde...

Orderby not working

I am sorting on multiple criteria using dynamic sorting, here's my code:... public ActionResult WebGrid(int page = 1, int rowsPerPage = 10, string sortCol = "OrderID", string sortDir = "ASC", string sortSecCol = "OrderID", string sortSecDir = "ASC") ...

How to fix 'No property or field exists in type' error?

I got this error when trying to sort any columns that are not in the Order table, if I use ...OrderBy("Customer.CompanyName" + " " + sortDir)... the error will gone but all the columns will become unable to sort. The ...OrderBy... method used below come f...