Installation

NuGet Package

Install DataProvider via NuGet:

dotnet add package DataProvider

Or using the Package Manager Console:

Install-Package DataProvider

Database Providers

Install the provider for your database:

SQL Server

dotnet add package DataProvider.SqlServer

MySQL

dotnet add package DataProvider.MySql

SQLite

dotnet add package DataProvider.Sqlite

LQL (Lambda Query Language)

Install LQL packages for cross-database query transpilation:

# Choose your target database
dotnet add package Lql.SQLite
dotnet add package Lql.Postgres
dotnet add package Lql.SqlServer

F# Type Provider

For F# projects, install the type provider for compile-time LQL validation:

dotnet add package Lql.TypeProvider.FSharp

This enables compile-time validated queries:

open Lql

type GetUsers = LqlCommand<"Users |> select(Users.Id, Users.Name)">
let sql = GetUsers.Sql  // Invalid LQL = build error

Requirements

  • .NET 9.0 or later
  • C# 13 or later
  • Nullable reference types enabled

Project Configuration

Add the following to your .csproj:

<PropertyGroup>
  <TargetFramework>net9.0</TargetFramework>
  <Nullable>enable</Nullable>
  <LangVersion>latest</LangVersion>
</PropertyGroup>

Next Steps