SQL Settings Provider

Despite the fact that the provider is written in pure ADO.NET stored procedures are used to interact with tables so it's unlikely that the provider will work with another DBMS other than Microsoft SQL Server.

To interact with data source stored procedures are used. That's why you can add personal logic or expand specific settings for plugins proceeding from user and plugin.


Before you start to use the plugin you need to add tables and stored procedures that will be needed for the plugin to work. All necessary tables and stored procedures are located along with the assembly in a separate folder.

Plugin contains 2 required configuration parameter:

  1. ConnectionString — Connection string to data source. (Examples)
  2. ProviderName — ADO.NET provider. For Microsoft SQL Server → System.Data.SqlClient.

Settings will be stored in the parent settings provider.




Родительские файлы