Repository files navigation

This is a.NET Core / Standard port of the Microsoft assembly for the .Net 4.0 Dynamic language functionality.

With this library it's possible to write Dynamic LINQ queries (string based) on anIQueryable:

varquery=db.Customers.Where("City == @0 and Orders.Count >= @1","London",10).OrderBy("CompanyName").Select("new(CompanyName as Name, Phone)");

Interpolated strings are supported on .NET 4.6(and above), .NET Core 2.1(and above), .NET Standard 1.3(and above) and UAP 10.0(and above).For example:

stringcityName="London";intc=10;db.Customers.WhereInterpolated($"City =={cityName} and Orders.Count >={c}");

ZZZ Projects owns and maintainsSystem.Linq.Dynamic.Core as part of ourmission to add value to the .NET community

ThroughEntity Framework Extensions andDapper Plus, we actively sponsor and help key open-source libraries grow.

A breaking change is introduced in this version which is related to calling methods on classes.Due to security reasons, it's now only allowed to call methods on the standard predefined classes like (bool,int,string ...).If you want to call a method on an own custom class, annotate that class with theDynamicLinqType.Example:

[DynamicLinqType]publicclassMyCustomClass{publicintGetAge(intx)=>x;}

If it's not possible to add that attribute, you need to implement a customCustomTypeProvider and set this to theParsingConfig and provide that config to all dynamic calls.Or provide a list of additional types in theDefaultDynamicLinqCustomTypeProvider.cs.

It's not allowed anymore to call any methods on theobject type. By default also theToString andEquals methods are not allowed.This is done to mitigate the risk of calling methods on theobject type which could lead to security issues (CVE-2024-51417).To allow these methods setAllowEqualsAndToStringMethodsOnObject totrue in theParsingConfig and provide that config to all dynamic calls.

By default theRestrictOrderByToPropertyOrField is now set totrue in theParsingConfig.Which means that only properties and fields can be used in theOrderBy /ThenBy.This is done to mitigate the risk of calling methods or other expressions in theOrderBy /ThenBy which could lead to security issues.To allow these methods setRestrictOrderByToPropertyOrField tofalse in theParsingConfig and provide that config to all dynamic calls.

TheDefaultDynamicLinqCustomTypeProvider has been changed to only return types which have the[DynamicLinqType] attribute applied.If it's not possible to add that attribute, you need to implement a customCustomTypeProvider and set this to theParsingConfig and provide that config to all dynamic calls.Or provide a list of additional types in theDefaultDynamicLinqCustomTypeProvider.cs.

• Website
• Documentation
• Online examples
• NuGet

Project
Chat
Issues
Quality
CI Workflow
SonarCloud
NuGet
System.Linq.Dynamic.Core
EntityFramework.DynamicLinq
Microsoft.EntityFrameworkCore.DynamicLinq
Z.EntityFramework.Classic.DynamicLinq
Z.DynamicLinq.SystemTextJson
Z.DynamicLinq.NewtonsoftJson

The following frameworks are supported:

• net35, net40, net45, net46 and up
• netstandard1.3, netstandard2.0 and netstandard2.1
• netcoreapp3.1, net5.0, net6.0, net7.0, net8.0 and net9.0
• uap10.0

This fork takes the basic library to a new level. Also adds unit tests to help ensure that it works properly.

Some background:I forked fromhttps://github.com/NArnott/System.Linq.Dynamic and added some more functionality there.
My fork is still visible on github [https://github.com/StefH/System.Linq.Dynamic], however I decided to start a new project + NuGet to avoid confusion and create the project according to the new VS2017 + .NET Core rules / standards.

However, currently there are multiple nuget packages and projects available:

The best way to contribute is byspreading the word about the library:

• Blog it
• Comment it
• Star it
• Share it

AHUGE THANKS for your help.

• Projects:
  • EntityFramework Extensions
  • Dapper Plus
  • C# Eval Expression
• Learn Websites
  • Learn EF Core
  • Learn Dapper
• Online Tools:
  • .NET Fiddle
  • SQL Fiddle
  • ZZZ Code AI
• and much more!

To view all our free and paid projects, visit our websiteZZZ Projects.