Link Search Menu Expand Document

BaseDbSetting


This class stands as the base class of all IDbSetting-based classes.

Use-Cases

To simplify your implementation, always use this class over the IDbSetting interface when overriding the default database settings.

How to Implement?

Simply create a class that inherits this class, then set the properties in the constructor.

public sealed class MyCustomSqlServerDbSetting : BaseDbSetting
{
    public MyCustomSqlServerDbSetting()
        : base()
    {
        AreTableHintsSupported = true;
        AverageableType = typeof(double);
        ClosingQuote = "]";
        DefaultSchema = "dbo";
        IsDirectionSupported = true;
        IsExecuteReaderDisposable = true;
        IsMultiStatementExecutable = true;
        IsPreparable = true;
        IsUseUpsert = false;
        OpeningQuote = "[";
        ParameterPrefix = "@";
        SchemaSeparator = ".";
    }
}

Additional benefits when using this class, you do not need to implement the GetHashCode() method as it is already implemented within the base class.

How to use?

Simply use the DbSettingMapper class to map it to the specific RDBMS data provider.

DbSettingMapper.Add(typeof(SqlConnection), new MyCustomSqlServerDbSetting(), true);