LINQ to DB MCP server

LINQ to DB

) )

LINQ to DB is the fastest LINQ database access library offering a simple, light, fast, and type-safe layer between your POCOs 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.

However, it's not as heavy as LINQ to SQL or Entity Framework. There is no change-tracking, so you have to manage that yourself, but on the positive side you get more control and faster access to your data.

In other words LINQ to DB is type-safe SQL.

LINQ to DB also very nice for F# developers (see Tests/FSharp and Source/LinqToDB.FSharp project for details).

Development version nugets feeds (how to use)

Standout Features

• Rich Querying API:
• Explicit Join Syntax (In addition to standard LINQ join syntax)
• CTE Support
• Bulk Copy/Insert
• Window/Analytic Functions
• Merge API
• Extensibility:
• Ability to Map Custom SQL to Static Functions

See Github.io documentation for more details.

<!-- You can visit our blog -->

Code examples and demos can be found here or in tests.

Release notes page.

Related Linq To DB and 3rd-party projects

• linq2db.EntityFrameworkCore (adds support for linq2db functionality in EF.Core projects)
• LinqToDB.Identity - ASP.NET Core Identity provider using Linq To DB
• LINQPad Driver
• DB2 iSeries Provider
• ASP.NET Core Template
• PostGIS extensions for linq2db

Notable open-source users:

Shortened. The full README is on GitHub.