Logo Marten
  • v3.x
Intro
Config
Document Database
Event Store
Migration
Release Notes
Join Chat
Twitter
GitHub
  • v3.x
Intro
Config
Document Database
Event Store
Migration
Release Notes
Join Chat
Twitter
GitHub
  • Introduction
  • 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
  • Document Database
    • Identity
    • Storage
    • Metadata
    • Sessions
    • Storing
    • Deleting
    • Querying
      • Load Documents by Id
      • Querying with Linq
        • Supported Linq Operators
        • Querying within Child Collections
        • 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
      • Calculated Indexes
      • Duplicated Fields
      • Unique Indexes
      • Foreign Keys
      • GIN or GiST Indexes
      • Metadata Indexes
    • Document Type Hierarchies
    • Multi-Tenanted Documents
    • Initial Baseline Data
    • Optimistic Concurrency
    • Full Text Searching
    • Noda Time Support
    • PLv8 Support
    • AspNetCore Support
  • Event Store
    • Quick Start
    • Storage
    • Appending Events
    • Querying Events
    • Metadata
    • Archiving Streams
    • Projections
      • Aggregate Projections
      • Live Aggregations
      • View Projections
      • Event Projections
      • Custom Projections
      • Inline Projections
      • Asynchronous Projections
      • Rebuilding Projections
    • Event Versioning
    • Multitenancy
    • Advanced

      • Aggregates, events and repositories
      • Copy and transform stream
      • Immutable projections as read model
  • Diagnostics and Instrumentation
  • Database Management
    • How Documents are Stored
    • Schema Migrations
    • Exporting Schema Definition
    • Schema Feature Extensions
    • Tearing Down Document Storage
  • FAQ & Troubleshooting
  • Scenarios
    • Aggregates, events and repositories
    • Copy and transform stream
    • Dynamic data
    • Immutable projections as read model
    • Using sequences for unique identifiers
  • 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
    • Backup and restore
      • Local
      • Remote

Queries (under construction) #

//TODO

Suggest changes to this page
Case insensitive data
Using duplicate fields