ENTITY FRAMEWORK CORE

Use EF Core.
Keep PostgreSQL powerful.

Keep the DbContext, LINQ, migrations, and tooling you know while using PostgreSQL-specific types and features when they add value.

ONE SHARED CONNECTION POOL

Configure once. Use it everywhere.

Build one data source and share it with EF Core. Connections and PostgreSQL types stay consistent across your application.

View source evidence
AppDbContext.cs
await using var dataSource =
    new BlueTuskDataSourceBuilder(connectionString).Build();

var options = new DbContextOptionsBuilder<AppDbContext>()
    .UseBlueTusk(dataSource)
    .Options;

await using var context = new AppDbContext(options);
var active = await context.Customers
    .Where(customer => customer.Tags.Contains("active"))
    .ToListAsync();
WHAT YOU CAN BUILD

Explore EF Core features by task.

Choose a task to see the PostgreSQL features available through EF Core.

LINQ TRANSLATION

Write LINQ that uses PostgreSQL well

Use PostgreSQL-specific operations in LINQ and inspect the SQL that EF Core generates.

CollectionsQuery arrays, ranges, multiranges, lateral joins, and set-returning functions
DocumentsRead and filter JSON/JSONB documents and complex types
Search + networkUse full-text search, network types, and PostgreSQL operators
DATABASE DESIGN

Keep PostgreSQL features in your EF model.

Partitions + inheritanceMigrations + scaffolding

Table partitions and inheritance remain visible in the EF model.

Row-level securityMigrations

Create PostgreSQL row-level security policies through migrations.

CHECK + exclusionMigrations + discovery

Create and discover PostgreSQL CHECK and exclusion constraints.

Publications + subscriptionsMigrations

Create logical replication publications and subscriptions in migrations.

Extensions + custom typesMigrations + mapping

Installed extensions connect to the same types used by the provider.

Views + foreign dataMigrations + scaffolding

Discover views and foreign tables when generating a model.

Routines + operatorsMigrations

Create PostgreSQL functions and operators without renaming them.

Property graphsPG 19 guarded

Graph features stay off on servers that do not support them.

EF CORE TEST RESULTS

See exactly what was tested.

BlueTusk runs the official EF Core relational tests and its own live PostgreSQL tests. Version-specific cases are checked across PostgreSQL 15–19.

Inspect all evidence
PASS1,987
UPSTREAM SKIP124
UNEXPECTED FAIL0
Source: docs/ef-core/specification-tests.md