LINQ to DB is a LINQ database access library offering a simple, light, fast, and type-safe layer between your POCO objects and your database.
Architecturally it is one step above micro-ORMs like Dapper, Massive, or PetaPoco, in that you work with LINQ expressions, not with magic strings, while maintaining a thin abstraction layer between your code and the database. Your queries are checked by the C# compiler and allow for easy refactoring.
This is free and open source software.
Key Features
- Rich Querying API:
- Explicit Join Syntax (In addition to standard LINQ join syntax). LINQ To DB supports all standard SQL join types: INNER, LEFT, FULL, RIGHT, CROSS JOIN.
- CTE Support – this lets you reuse the same SQML part in complex query, and recursive table processing.
- Bulk Copy/Insert – takes data and operation options, then perform inserts and return operation status.
- Window/Analytic Functions – window functions are implemented as extension methods for static Sql.Ext property.
- Merge API which contains four groups of methods:
- Merge, MergeInto, Using, UsingTarget methods to configure merge command’s source and target.
- On, OnTargetKey methods to configure merge command’s match condition.
- InsertWhenNotMatched*, UpdateWhenMatched*, DeleteWhenMatched*, UpdateWhenNotMatchedBySource*, DeleteWhenNotMatchedBySource*, UpdateWhenMatched*ThenDelete methods to add operations to merge command
- Merge and MergeAsync methods to execute command against database
- Extensibility:
- Ability to Map Custom SQL to Static Functions.
Website: linq2db.github.io
Support: GitHub Code Repository
Developer: Igor Tkachev, Ilya Chudin, Svyatoslav Danyliv, Dmitry Lukashenko
License: MIT License
LINQ to DB is written in C#. Learn C# with our recommended free books and free tutorials.
Related Software
| C# Object-Relational Mapping Software | |
|---|---|
| Entity Framework Core | Modern object-database mapper for .NET. |
| Dapper | Simple object mapper for .NET |
| NHibernate | Mature, open source object-relational mapper for .NET |
| LINQ to DB | LINQ database access library |
| RepoDB | Hybrid ORM library for .NET |
| Venflow | Fast and lightweight ORM for PostgreSQL |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |