Popularity

2.6

Growing

Activity

0.0

Stable

Stars 88

Watchers 12

Forks 7

Last Commit 7 months ago

Description

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

Programming language: F#

License: The Unlicense

Tags: Linq ORM SQL Performance Expression-tree Optimization Expression

Latest version: v1.0.13

Linq.Expression.Optimizer alternatives and similar packages

Based on the "ORM" category.
Alternatively, view Linq.Expression.Optimizer alternatives based on common mentions on social networks and blogs.

TypeORM

10.0 8.8 Linq.Expression.Optimizer VS TypeORM

ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Dapper

9.9 5.1 L1 Linq.Expression.Optimizer VS Dapper

Dapper - a simple object mapper for .Net [Moved to: https://github.com/DapperLib/Dapper]

Free Global Payroll designed for tech teams

Building a great tech team takes more than a paycheck. Zero payroll costs, get AI-driven insights to retain best talent, and delight them with amazing local benefits. 100% free and compliant.

Promo try.revelo.com

Entity Framework

9.8 9.4 L1 Linq.Expression.Optimizer VS Entity Framework

EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
SqlSugar

9.2 9.4 Linq.Expression.Optimizer VS SqlSugar

.Net ORM Fastest ORM Simple Easy Sqlite orm Oracle ORM Mysql Orm postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm
FreeSql

8.9 0.0 Linq.Expression.Optimizer VS FreeSql

🦄 .NET orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm.
FluentMigrator

8.5 0.0 L3 Linq.Expression.Optimizer VS FluentMigrator

Fluent migrations framework for .NET
NHibernate

8.4 0.0 L3 Linq.Expression.Optimizer VS NHibernate

NHibernate Object Relational Mapper
EFCore.BulkExtensions

8.4 0.0 Linq.Expression.Optimizer VS EFCore.BulkExtensions

Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite
LINQ to DB

8.3 0.0 L1 Linq.Expression.Optimizer VS LINQ to DB

Linq to database provider.
PetaPoco

8.0 0.0 L2 Linq.Expression.Optimizer VS PetaPoco

Official PetaPoco, A tiny ORM-ish thing for your POCO's
ServiceStack.OrmLite

8.0 4.5 L2 Linq.Expression.Optimizer VS ServiceStack.OrmLite

Fast, Simple, Typed ORM for .NET
Fluent NHibernate

8.0 0.0 L5 Linq.Expression.Optimizer VS Fluent NHibernate

Fluent NHibernate!
Dapper Extensions

7.8 0.0 L5 Linq.Expression.Optimizer VS Dapper Extensions

Dapper Extensions is a small library that complements Dapper by adding basic CRUD operations (Get, Insert, Update, Delete) for your POCOs. For more advanced querying scenarios, Dapper Extensions provides a predicate system. The goal of this library is to keep your POCOs pure by not requiring any attributes or base class inheritance.
Entity Framework 6

7.6 0.0 Linq.Expression.Optimizer VS Entity Framework 6

This is the codebase for Entity Framework 6 (previously maintained at https://entityframework.codeplex.com). Entity Framework Core is maintained at https://github.com/dotnet/efcore.
Massive

7.4 0.0 L3 Linq.Expression.Optimizer VS Massive

A small, happy, dynamic MicroORM for .NET that will love you forever.
LINQKit

6.8 0.0 L4 Linq.Expression.Optimizer VS LINQKit

LINQKit is a free set of extensions for LINQ to SQL and Entity Framework power users.
RepoDb

6.8 7.7 Linq.Expression.Optimizer VS RepoDb

A hybrid ORM library for .NET.
NPoco

6.6 0.0 L2 Linq.Expression.Optimizer VS NPoco

Simple microORM that maps the results of a query onto a POCO object. Project based on Schotime's branch of PetaPoco
SmartSql

6.5 0.0 Linq.Expression.Optimizer VS SmartSql

SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
MicroOrm.Dapper.Repositories

6.0 0.0 L4 Linq.Expression.Optimizer VS MicroOrm.Dapper.Repositories

CRUD for Dapper
SQLProvider

5.5 0.0 Linq.Expression.Optimizer VS SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
LINQ to Twitter

5.4 0.0 L3 Linq.Expression.Optimizer VS LINQ to Twitter

LINQ Provider for the Twitter API (C# Twitter Library)
Dapper.FastCRUD

5.2 0.0 L3 Linq.Expression.Optimizer VS Dapper.FastCRUD

fast & light .NET ORM for strongly typed people
MongoDB Repository pattern implementation

5.0 0.3 L5 Linq.Expression.Optimizer VS MongoDB Repository pattern implementation

Repository abstraction layer on top of Official MongoDB C# driver
BL Toolkit

4.8 0.0 L1 Linq.Expression.Optimizer VS BL Toolkit

Business Logic Toolkit for .NET
MongoDB.Entities

4.8 0.0 Linq.Expression.Optimizer VS MongoDB.Entities

A data access library for MongoDB with an elegant api, LINQ support and built-in entity relationship management
JsonFlatFileDataStore

4.5 0.0 Linq.Expression.Optimizer VS JsonFlatFileDataStore

Simple JSON flat file data store with support for typed and dynamic data.
MongoFramework

4.3 0.0 Linq.Expression.Optimizer VS MongoFramework

An "Entity Framework"-like interface for MongoDB
LINQtoCSV

4.2 0.0 Linq.Expression.Optimizer VS LINQtoCSV

Popular, easy to use library to read and write CSV files.
Tortuga Chain

3.9 0.0 Linq.Expression.Optimizer VS Tortuga Chain

A fluent ORM for .NET
DbExtensions

3.8 0.0 L3 Linq.Expression.Optimizer VS DbExtensions

Data-access framework with a strong focus on query composition, granularity and code aesthetics.
NReco.Data

3.6 0.0 L3 Linq.Expression.Optimizer VS NReco.Data

Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM).
AsyncPoco

3.2 0.0 L1 Linq.Expression.Optimizer VS AsyncPoco

A long-"awaited" fully asynchronous PetaPoco fork
Venflow

3.0 0.0 Linq.Expression.Optimizer VS Venflow

A brand new, fast and lightweight ORM, build for PostgreSQL.
MicroLite ORM

2.7 5.1 L4 Linq.Expression.Optimizer VS MicroLite ORM

MicroLite ORM framework
KonfDB

2.1 0.0 L3 Linq.Expression.Optimizer VS KonfDB

Configuration as a Service for multi-tenant, cross-platform applications
Dashing

2.0 0.0 Linq.Expression.Optimizer VS Dashing

Dashing is a simple to use mini ORM built on top of Dapper
MapDataReader

1.8 10.0 Linq.Expression.Optimizer VS MapDataReader

Super fast mapping DataReader to strongly typed object, Using AOT source generator.
Jerrycurl

1.6 0.0 Linq.Expression.Optimizer VS Jerrycurl

Razor-powered ORM for .NET
Limebean

1.6 0.0 L4 Linq.Expression.Optimizer VS Limebean

Hybrid-ORM for .NET
Dapper.MicroCRUD

1.5 0.0 Linq.Expression.Optimizer VS Dapper.MicroCRUD

CRUD Extensions for Dapper.Net
ObjectStore

1.4 1.7 Linq.Expression.Optimizer VS ObjectStore

.Net Or-Mapper working with dynamically implemented abstract Classes
MongoRiver.NET

1.2 0.0 L5 Linq.Expression.Optimizer VS MongoRiver.NET

A library for writing .NET MongoDB oplog tailers.
Zonkey

1.1 0.0 Linq.Expression.Optimizer VS Zonkey

Zonkey ORM (and then some) libraries for .Net
DatabaseObjects

1.1 0.0 L2 Linq.Expression.Optimizer VS DatabaseObjects

.NET Object Relational Mapping Tool
EntityFramework.DatabaseMigrator

1.0 0.0 L4 Linq.Expression.Optimizer VS EntityFramework.DatabaseMigrator

EntityFramework.DatabaseMigrator is a WinForms utility to help manage Entity Framework 6.0+ migrations.
Dapper.CX

0.9 0.0 Linq.Expression.Optimizer VS Dapper.CX

A Crud library based on Dapper
AutoClutch

0.9 0.0 L2 Linq.Expression.Optimizer VS AutoClutch

Generic repository and generic service.
Exodus

0.9 0.0 Linq.Expression.Optimizer VS Exodus

Simple C# database migrator for .NET Core.
Excel2SqlServer

0.7 0.0 Linq.Expression.Optimizer VS Excel2SqlServer

Library for importing Excel spreadsheets into SQL Server tables

* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.

Do you think we are missing an alternative of Linq.Expression.Optimizer or a related project?

Add another 'ORM' Package

Popular Comparisons

README

Linq.Expression.Optimizer

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, excelent 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 optimses .NET LINQ-expressions. These expressions were not ment 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