AgentPrismSqlServerOptions
AgentPrism.SqlServer.dllSettings for AgentPrism’s SQL Server persistence layer.
public sealed class AgentPrismSqlServerOptionsInheritance
Section titled “Inheritance”object ← AgentPrismSqlServerOptions
Inherited Members
Section titled “Inherited Members”object.GetType(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()
Remarks
Section titled “Remarks”Validation is done by hand in AgentPrismSqlServerOptionsValidator;
DataAnnotations is not used.
Constructors
Section titled “Constructors”AgentPrismSqlServerOptions()
Section titled “ AgentPrismSqlServerOptions()”public AgentPrismSqlServerOptions()Fields
Section titled “Fields”SectionName
Section titled “ SectionName”The full path of the configuration section settings are read from.
public const string SectionName = "AgentPrism:SqlServer"Field Value
Section titled “Field Value”Properties
Section titled “Properties”AutoApplyMigrations
Section titled “ AutoApplyMigrations”Whether pending migrations are applied automatically at application startup.
public bool AutoApplyMigrations { get; set; }Property Value
Section titled “Property Value”Remarks
Section titled “Remarks”Can be set to false in production and MigrationRunner run as a separate deployment step, so a long-running migration does not block application startup.
CommandTimeoutSeconds
Section titled “ CommandTimeoutSeconds”The upper time limit for a single SQL command (seconds). 0 means unlimited.
public int CommandTimeoutSeconds { get; set; }Property Value
Section titled “Property Value”ConnectionString
Section titled “ ConnectionString”The SQL Server connection string.
public string? ConnectionString { get; set; }Property Value
Section titled “Property Value”Remarks
Section titled “Remarks”This value is a secret and is never written to a file. Use
dotnet user-secrets, an environment variable, or a secret manager.
SchemaName
Section titled “ SchemaName”The schema AgentPrism’s tables are created in. The consumer’s dbo
schema is never touched, under any circumstances.
public string SchemaName { get; set; }Property Value
Section titled “Property Value”Remarks
Section titled “Remarks”Even though SQL Server allows a wider set of identifiers, AgentPrism enforces the same strict rule: starts with a lowercase letter or underscore, contains lowercase letters, digits, and underscores, at most 63 characters. This way the same schema name carries over between PostgreSQL and SQL Server without changes.