Friday, 1 October 2021

Dynamic Linq query in Core

Dynamic Linq:

namespace System.Linq.Dynamic.Core

https://dynamic-linq.net/

Example in Fiddler:

https://dotnetfiddle.net/GdxsMG


var context = new EntityContext();

// Example 1: Strongly styped = normal LINQ

var example1 = context.Customers

.OrderBy(c => c.City).ThenBy(c => c.CompanyName)

.ToList();

FiddleHelper.WriteTable(example1);


// Example 2: Dynamic

var example2 = context.Customers

.OrderBy("City, CompanyName")

.ToList();

FiddleHelper.WriteTable(example2);


// Example 3: Dynamic

var example3 = context.Customers

.OrderBy("City").ThenBy("CompanyName desc")

.ToList();

FiddleHelper.WriteTable(example3);


// Example 4: Dynamic

var example4 = context.Customers

.OrderBy("City, CompanyName desc")

.ToList();

FiddleHelper.WriteTable(example4);



No comments:

Post a Comment