Dynamic LINQ - Knowledge Base (KB)

Sortable JqGrid using LINQ to MySQL (DbLinq) and Dynamic LINQ - Orderby doesn't work

I've got problem with sorting entries in JqGrid. Orderby seem to not work. I set breakpoint in code and I noticed, that orderby doesn't change order of elements. Any idea what could be wrong?...I'm using LINQ to SQL with MySQL (DbLinq project)....My actio...

JSON results are returned in a different order than expected

I am following ...Phil Haack's example on using jQuery Grid with ASP.NET MVC.... I have it working and it works well...except for one minor problem. When I sort the columns by something other than the ID, the JSON data returned from the server is very...w...

LINQ Dynamic Query Library

I am building an ASP.Net MVC 3 application with Entity Framework 4. When the two pieces of code below are executed, both variables (query1 and query2) have a return type of...System.Data.Objects.ObjectQuery<Asset.Model.Equipment> ...Query1 uses a direct i...

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

How to execute a LINQ to Entities query, pulling values from an existing resultset variable instead of against the DB

To provide some context, I'm using jqGrid to conduct a server side search on a datetime field, truncating the time portion server side, and then fetching results via a stored procedure. This is being done using System.Dynamic.Linq, which I've modified sli...