YesSql Documentation

YesSql is a .NET Core document database interface designed to run on top of existing relational databases (RDBMS). It allows you to define documents and indexes using plain old CLR objects (POCOs).

By using an RDBMS as the storage engine, YesSql provides the benefits of a document database (flexible schema via objects) combined with the features of SQL databases, such as:

• ACID transactions
• Replication
• Reporting capabilities
• No 'magic' (it uses pure SQL internally via Dapper)

YesSql maps its document model to relational tables using the following structure:

• Document Table: A single global Document table stores all documents.
• Index Tables: Each index is defined as a custom class and is stored in its own dedicated table.
• Reduce Indexes: For reduce indexes, YesSql adds a bridge table to facilitate the mapping of many documents.

Internally, YesSql uses Dapper to communicate with the database server.

To begin using YesSql, you can refer to the official documentation or explore the sample applications provided in the repository.

• Official Documentation: YesSql Wiki
• Sample Apps: Check the samples directory in the source code for implementation patterns.