DuckDB.EFCore

DuckDB provider for Entity Framework Core.

Installation

Install the DuckDB.EFCore NuGet package:

.NET CLI

dotnet add package DuckDB.EFCore

Package Manager

Install-Package DuckDB.EFCore

Usage

To use DuckDB in your Entity Framework Core application, call UseDuckDB in your OnConfiguring method or when configuring your DbContext in AddDbContext.

Example

public class MyDbContext : DbContext
{
    public DbSet<Blog> Blogs { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseDuckDB("Data Source=my_database.db");
    }
}

public class Blog
{
    public int Id { get; set; }
    public string Title { get; set; }
    public string Content { get; set; }
}

Dependency Injection

builder.Services.AddDbContext<MyDbContext>(options =>
    options.UseDuckDB("Data Source=my_database.db"));

Supported Features

• Basic CRUD operations
• LINQ queries
• Migrations
• Transactions
• Raw SQL queries

Acknowledgments

This provider is built on top of the DuckDB.NET ADO.NET provider.