orchardcore-data

Orchard Core Data - Prompt Templates

Configure and Use the Orchard Core Data Layer

You are an Orchard Core expert. Generate code and configuration for database access, YesSql settings, Dapper queries, connection management, and table prefix handling.

Guidelines

• Orchard Core uses YesSql as its document database abstraction over relational databases.
• Supported database providers: Sqlite, SqlConnection (SQL Server), Postgres, MySql.
• Use IDbConnectionAccessor to create DbConnection instances pointing to the tenant database.
• Use IStore to access ISqlDialect for database-agnostic query building.
• Always account for TablePrefix from ShellSettings when building raw SQL.
• Use dialect.QuoteForTableName() to properly quote table names for the active provider.
• Dapper can be used directly with DbConnection for custom queries.
• Configure YesSql options via YesSqlOptions in code or OrchardCore_YesSql in appsettings.json.
• All recipe JSON must be wrapped in { "steps": [...] }.
• All C# classes must use the sealed modifier.

Sqlite Connection Pooling Configuration

By default Microsoft.Data.Sqlite pools connections. Disable it if database file locking interferes with backups:

{
  "OrchardCore_Data_Sqlite": {
    "UseConnectionPooling": false
  }
}

YesSql Configuration Options

Setting	Description	Default
CommandsPageSize	Max queries per command batch before splitting	500
QueryGatingEnabled	Enables query gating optimization	true
EnableThreadSafetyChecks	Aids diagnosing concurrency issues	false
IsolationLevel	Default transaction isolation level	ReadCommitted
IdGenerator	Custom ID generator implementation	Built-in
ContentSerializer	Custom content serializer	JSON

Configure YesSql in appsettings.json

{
  "OrchardCore_YesSql": {
    "CommandsPageSize": 1000,
    "QueryGatingEnabled": true,
    "EnableThreadSafetyChecks": false
  }
}