Linq.Expression.Optimizer 1.0.29

.NET Standard 2.0 This package targets .NET Standard 2.0. The package is compatible with this framework or higher. .NET Framework 4.7.2 This package targets .NET Framework 4.7.2. The package is compatible with this framework or higher. 
dotnet add package Linq.Expression.Optimizer --version 1.0.29
                    


                    

                
NuGet\Install-Package Linq.Expression.Optimizer -Version 1.0.29
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="Linq.Expression.Optimizer" Version="1.0.29" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="Linq.Expression.Optimizer" Version="1.0.29" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="Linq.Expression.Optimizer" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add Linq.Expression.Optimizer --version 1.0.29
                    


                    

                
#r "nuget: Linq.Expression.Optimizer, 1.0.29"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#addin nuget:?package=Linq.Expression.Optimizer&version=1.0.29
                    


                            Install Linq.Expression.Optimizer as a Cake Addin
                        

                    

                
#tool nuget:?package=Linq.Expression.Optimizer&version=1.0.29
                    


                            Install Linq.Expression.Optimizer as a Cake Tool

Issue Stats Issue Stats

Linq.Expression.Optimizer

Lightweight optimizer of System.Linq.Expression expressions. Just basic boolean algebra and reductions, constant and tuple/anonymous type eliminations. For side-effect-free Expressions. No compilation-subjective optimizations. This is meant to be used with expressions that are not compiled but transferred to other domains.

Supported frameworks: Net 3.5, Net 4.5-... (and Mono), .NET Standard 1.6 (so also .NET Core)

Supported optimizations

Example as a quote. There are various other cases also.

  • Replace constants comparisons: 3 < 4 -> true
  • Remove anonymous types: new AnonymousObject(Item1 = x, Item2 = "").Item1 --> x
  • Cut not used condition: if false then x else y -> y
  • Remove not: not(false) -> true
  • Binary tree balancing: a or (b or (c or (d or (e or (f or (g or h)))))) -> ((a or b) or (c or d)) or ((e or f) or (g or h))
  • Captured closure constant ("free variable") evaluation: y = 3 and (y + x) -> (3 + x)
  • Execute simple math: 5 * 3 -> 15
  • Boolean algebra reductions:
    • gather (x or y) and (x or z) -> x or (y and z)
    • identity false or y -> y
    • annihilate true or x -> true
    • absorb x and (x or y) -> x
    • idempotence y or y -> y
    • complement x and not(x) -> false
    • doubleNegation not(not(y)) -> y
    • deMorgan not(x) and not(y) -> not(x or y)

Background

This is a side-track from SQLProvider, excellent tool that is kind of OR-mapper with auto-generated objects, so it compiles any databases to .NET-language, and works fast on design time in Visual Studio or other editors.

But I needed better SQL-queries. So this optimises .NET LINQ-expressions. These expressions were not meant to be compiled, so Nessos LinqOptimizer was not the right tool. I thought that .NET would optimize these automatically, but no.

Read the Getting started tutorial to learn more.

Documentation: http://thorium.github.io/Linq.Expression.Optimizer

Maintainer(s)

If you want more optimizations, please feel free to send PRs!

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 is compatible. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 is compatible.  net48 was computed.  net481 is compatible. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (4)

Showing the top 4 NuGet packages that depend on Linq.Expression.Optimizer:

Package Downloads
SpeedyCourse.Entities

Package Description
Dosaic.Plugins.Persistence.EfCore.NpgSql

A plugin-first dotnet framework for rapidly building anything hosted in the web.
Dosaic.Plugins.Persistence.EfCore.Abstractions

A plugin-first dotnet framework for rapidly building anything hosted in the web.
XSpecification.Linq

XSpecification is an implementation of Specification pattern for Linq and Elasticsearch

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on Linq.Expression.Optimizer:

Repository Stars
rnwood/smtp4dev
smtp4dev - the fake smtp email server for development and testing
scottksmith95/LINQKit
LINQKit is a free set of extensions for LINQ to SQL and Entity Framework power users.
zzzprojects/System.Linq.Dynamic.Core
The .NET Standard / .NET Core version from the System Linq Dynamic functionality.
Version Downloads Last updated
1.0.29 2,009 3/31/2025
1.0.28 1,223 3/26/2025
1.0.27 360 3/18/2025
1.0.24 2,859 11/7/2024
1.0.23 25,279 6/26/2024
1.0.22 133 6/26/2024
1.0.21 7,199 4/5/2024
1.0.20 197 4/2/2024
1.0.18 5,782 3/11/2024
1.0.16 34,300 10/8/2023
1.0.15 20,879 3/7/2023
1.0.13 184,782 5/27/2019
1.0.12 37,201 8/31/2018
1.0.11 31,476 1/1/2018
1.0.10 1,592 1/1/2018
1.0.9 26,965 6/5/2017
1.0.8 1,748 5/10/2017
1.0.7 29,126 10/7/2016
1.0.6 1,568 10/6/2016
1.0.5 1,514 10/5/2016
1.0.4 1,711 10/3/2016
1.0.3 1,752 8/30/2016
1.0.2 1,561 8/30/2016
1.0.1 1,488 8/30/2016
1.0.0 1,605 8/27/2016

Further Improved boolean algebra optimisation
Initial implementation of "remove duplicate condition", "remove mutually exclusive condition"