Ridavei.Settings.SqlServer 1.0.0.1

Ridavei.Settings.SqlServer

Latest release

Builder extension to store and retrieve settings keys and values in SQL Server.
To work properly it is needed to add the procedures and functions from the Scripts folder.

Example of use

Get and set value in SQL Server using ConnectionString.

using Ridavei.Settings;
using Ridavei.Settings.SqlServer;

namespace Example
{
    class Program
    {
        public static void Main(string[] args)
        {
            const string connectionString = "YOUR_CONNECTIONSTRING";
            var builder = SettingsBuilder
                .CreateBuilder()
                .UseSqlServerManager(connectionString);
            using (var settings = builder.GetSettings("DictionaryName"))
            {
                //You can use settings.Get("ExampleKey", "DefaultValue") if you want to retrieve the default value if the key doesn't exists.
                var value = settings.Get("ExampleKey");
                settings.Set("AnotherKey", "NewValue");
            }
        }
    }
}

Get and set value in SQL Server using SqlConnection.

using System.Data.SqlClient;

using Ridavei.Settings;
using Ridavei.Settings.SqlServer;

namespace Example
{
    class Program
    {
        public static void Main(string[] args)
        {
            const string connectionString = "YOUR_CONNECTIONSTRING";
            var builder = SettingsBuilder.CreateBuilder();
            using (var connection = new SqlConnection(connectionString))
            {
                connection.Open();
                using (var settings = builder
                    .UseSqlServerManager(connection)
                    .GetSettings("DictionaryName"))
                {
                    //You can use settings.Get("ExampleKey", "DefaultValue") if you want to retrieve the default value if the key doesn't exists.
                    var value = settings.Get("ExampleKey");
                    settings.Set("AnotherKey", "NewValue");
                }
            }
        }
    }
}