Skip to content

Main Navigation

Intro Document DB Event Store Migration Join Chat

Appearance

Sidebar Navigation

Introduction

What is Marten?

Configuration

Integration and Configuration Bootstrap with HostBuilder Do It Yourself IoC Integration Command Line Tooling Configuring Document Storage with StoreOptions Json Serialization Retry Policies Pre-Building Generated Types Development versus Production Usage Multi-Tenancy with Database per Tenant Environment Checks

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 Querying for Raw JSON Compiled Queries 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 PLv8 Support AspNetCore Support

Event Store

Marten as Event Store Quick Start Storage Appending Events Querying Events Metadata Archiving Streams Projections Aggregate Projections Live Aggregations Cross-Stream Aggregations Custom Aggregations Event Projections Custom Projections Inline Projections Asynchronous Projections Rebuilding Projections Event Versioning Multitenancy Aggregates, events and repositories

Diagnostics

Diagnostics and Instrumentation

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

On this page

Table of Contents for current page

Case Insensitive Data (under construction)

//TODO

Suggest changes to this page

Last updated:

Previous pageUnique values

Next pageQueries

Released under the MIT License.

Copyright © Jeremy D. Miller, Babu Annamalai, Oskar Dudycz, Joona-Pekka Kokko and contributors.