AdvantageCMS.Core.Common.BaseClasses Namespace
Build With Advantage

SqlProviderResolver Class

Resolves the active ISqlProviderFactory from configuration.

Namespace:  AdvantageCMS.Data
Assembly:  AdvantageCMS.Data (in AdvantageCMS.Data.dll)

Syntax


public static class SqlProviderResolver

Remarks


The provider is determined per connection string via the standard providerName attribute:
C#
<connectionStrings>
  <add name="MainDB" connectionString="..." providerName="System.Data.SqlClient" />
  <add name="AzureDB" connectionString="..." providerName="Microsoft.Data.SqlClient" />
</connectionStrings>
When providerName is absent, falls back to AppSettings["DataProvider"] ("Microsoft" → Microsoft.Data.SqlClient; anything else → System.Data.SqlClient).

Inheritance Hierarchy


Object
  AdvantageCMS.Data..::..SqlProviderResolver