Dynamic Linq Order By user defined sequence

dynamic-linq linq sorting sql-order-by

Question

I have dynamic linq query with OrderBy. 

 .AsQueryable().OrderBy("FullName", asc)

After sorting by FullName, I need to sort by status (something like ThenBy()). Status may have vales e.g. "A", "B", "C", "D" But I need to sort in following sequence "B", "A", "D", "C". As result can't use asc/desc in this case.

1
1
6/26/2012 3:15:34 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

You need to do the following:

a) Define the collection of your keys in the order you want

var keys = new string[]{"B", "A", "D", "C"};

b) Use the above keys to define the custom order of your data

var result = yourCollection.AsQueryable()
                           .OrderBy("FullName", asc)
                           .ThenBy(x=>keys.IndexOf(x.Status));
2
6/26/2012 3:27:19 PM

Related Questions

Dynamic LINQ with direct user input, any dangers?

Just a thought, but have you looked at ADO.NET Data Services? This provides a REST-enabled API much like the above with a lot of standard LINQ functionality built in....I can't think of an interest dynamic LINQ exploit of the top of my head, but if this was me I'd be ...at least... white-listing members (...OrderID..., ...CustomerName..., etc) - bu...
c# dynamic-linq linq sql-injection
asked by Marc Gravell

How to do the following in Dynamic Linq using System.Linq.Dynamic namespace

I just want to know how to do the following in Dynamic Linq using System.Linq.Dynamic namespace...var query2 = db.Customers.Select( cust => new Customer { FirstName = cust.FirstName, LastName = cust.LastName Tags="sampleTag,Tag" ...
dynamic-linq linq
asked by emem

Does dynamic GroupBy work together with dynamic Where in dynamic LINQ?

I use this ...dynamic LINQ library... together with Linq-to-Entities.... I build query and after that iterate it with ...foreach(object e in query){}...query=db.Table1.Where("it.FieldA>10").Select("it.FieldB");... works....query=db.Table1.Where(e=>e.FieldA>10).GroupBy("it.FieldB", "it").Select("key")... works.... But ...query=db.Table1.Where("it.Fi...
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

Dynamic table name linq-to-sql dynamic LINQ

I want to construct my query dynamically based on the contents user has selected, and I want to do this in LINQ-t0-SQL. I have seen ...this..., but I don't want to use SQL statements with datacontext....On Googling a bit I have a feeling that this can be done using dynamic LINQ. Would someone provide an example of similar scenario with dynamic LINQ...
dynamic-linq linq-to-sql
asked by Muhammad Adeel Zahid

How to use Dynamic LINQ (System.Linq.Dynamic) for LIKE operation?

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

LINQ (Dynamic): OrderBy within a GroupBy using dynamic linq?

I had the following query using normal linq and it was working great (using anonymous type),... var result = from s in Items group s by s.StartTime into groupedItems select new {groupedItems.Key, Items= groupedItems.OrderBy(x => x.Name) }; ...But using Dynamic Linq I cannot get it to order by within the groupby.... r...
dynamic-linq linq linq-to-objects
asked by Martin

Dynamic linq unable to parse ordering

Say I have a query that selects into a defined type like so:...public class SomeObject { public DateTime CreatedDate { get; set; } } private class MyType { internal SomeObject Object1 { get; set; } internal SomeThing Object2 { get; set; } internal DateTime SomeDate { get; set; } } var query = from bla in context.Melp join ...
dynamic-linq entity-framework linq
asked by Oxymoron

System.Linq.Dynamic.Core vs System.Linq.Dynamic

What is the difference between System.Linq.Dynamic.Core and System.Linq.Dynamic? I am currently using System.Linq.Dynamic and it does not contain support for ...Select... and ...SelectMany... (among other extension methods). Does System.Linq.Dynamic.Core support these methods?
dynamic-linq
asked by jjf1978

Define an array in a dynamic linq expression

How can I define an array inside of a dynamic linq expression string, that I can pass into ....Where(string)... ? I already tried ...{ "val a", "val b", "val c" }..., but this does not work....Here's an example of what I want to achieve:...public class Person { String Name { get; set; } int Age { get; set; } } ...Now I want to query an ...I...
.net c# dynamic-linq
asked by Slayer

Ordering by ICollection property using its name as string with Dynamic Linq Library

I've searched pretty much every question, blog or documentation I could find to help me get to this question's answer. A few actually helped me get closer to it, but I still haven't solved it yet, since most were either outdated or not really on point with what I needed. Don't bother telling me about Expressions, since if I were to take the longer ...
asp.net-mvc-5 c# dynamic-linq linq
asked by Tiramonium

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow