LINQ to DB – LINQ database access library

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

Read our verdict in the software roundup.

LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software. We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more. Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion. Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.