Skip to content

Marten

Main Navigation

v6.x

v5.x

v4.x

v3.x

Intro Document DB Event Store Migration Support Plans Join Chat

Appearance

Sidebar Navigation

Introduction

What is Marten?

Getting Started

Configuration

Bootstrapping Marten

Configuring Document Storage

Json Serialization

Resiliency Policies

Pre-Building Generated Types

Command Line Tooling

Optimized Development Workflow

Multi-Tenancy with Database per Tenant

Environment Checks

Custom IoC Integration

Document Database

Marten as Document DB

Document Identity

Database Storage

Marten Metadata

Opening Sessions

Storing Documents

Deleting Documents

Querying Documents

Loading Documents by Id

Querying Documents with Linq

Supported Linq Operators

Querying within Child Collections

Querying including Related Documents

Querying to IAsyncEnumerable

Extending Marten's Linq Support

Searching on String Fields

Projection Operators

Paging

Mixing Raw SQL with Linq

Searching with Boolean Flags

Searching for NULL Values

Querying with Postgres SQL

Advanced Querying with Postgres SQL

Querying for Raw JSON

Compiled Queries and Reusable Query Plans

Batched Queries

Indexing Documents

Calculated Indexes

Duplicated Fields

Unique Indexes

Foreign Keys

GIN or GiST Indexes

Metadata Indexes

Ignore Indexes

Execute custom SQL in session

Document Type Hierarchies

Multi-Tenanted Documents

Initial Baseline Data

Optimistic Concurrency

Full Text Searching

Noda Time Support

Partial updates/patching

PLv8 Support

AspNetCore Support

Event Store

Marten as Event Store

Quick Start

Storage

Appending Events

Querying Events

Metadata

Archiving Streams

Optimizing Performance

Projections Overview

Aggregate Projections

Live Aggregations

Multi-Stream Projections

Explicit Aggregations

Reading Aggregates

Event Projections

Custom Projections

Inline Projections

Flat Table Projections

Asynchronous Projections

Testing Projections

Rebuilding Projections

Projections and IoC Services

Async Daemon HealthChecks

Event Subscriptions

Event Versioning

Multitenancy

Removing Protected Information

Aggregates, events and repositories

Understanding Event Sourcing

Testing

Integration Testing

DevOps

Diagnostics

Diagnostics and Instrumentation

Open Telemetry and Metrics

Schema

Database Management

How Documents are Stored

Schema Migrations

Exporting Schema Definition

Schema Feature Extensions

Tearing Down Document Storage

Troubleshoot

FAQ & Troubleshooting

Scenarios

Aggregates, events and repositories

Copy and transform stream

Dynamic data

Using sequences for unique identifiers

Command Handler Workflow for Capturing Events

Postgres for SQL Server users

Naming conventions

Escaping

Types

Casting

Casing

Unique values

Case insensitive data

Queries

Using duplicate fields

Slow queries

Indexing

Indexing JSONB

If statements

Working with dates

Community

Tools and Libraries

On this page

The search box in the website knows all the secrets—try it!

For any queries, join our Discord Channel to reach us faster.

JasperFx provides formal support for Marten and other JasperFx libraries. Please check our Support Plans for more details.

Unique Values (under construction)

//TODO

Suggest changes to this page

Last updated: 4/7/25, 3:09 AM

Pager

Previous pageCasing

Next pageCase insensitive data

Released under the MIT License.

Aggregate Projections

Unique Values (under construction) ​

Unique Values (under construction)