public IPwmDbContext Create()
        {
            DatabaseData config = configuration
                                  .SetPath()
                                  .Create()
                                  .Load();


            var contextOptions = new DbContextOptionsBuilder <Context>();

            switch (config.Type)
            {
            case DataBaseType.Mssql:
                var connectionStringSql = sqlConnectionStringBuilder.Create();
                contextOptions.UseSqlServer(connectionStringSql);
                break;

            case DataBaseType.SqLite:
                var connectionStringSqLite = sqLiteConnectionStringBuilder.Create();
                contextOptions.UseSqlite(connectionStringSqLite);
                break;

            case DataBaseType.AccessDatabase:

                break;

            default:
                throw new ArgumentOutOfRangeException();
            }

            var context = new Context(contextOptions.Options);

            return(new PwmDbContext(context));
        }
        public string Create()
        {
            var configuration = configurationFactory
                                .SetPath()
                                .Create()
                                .Load();

            Microsoft.Data.SqlClient.SqlConnectionStringBuilder connectionStringBuilder = new Microsoft.Data.SqlClient.SqlConnectionStringBuilder();

            if (!configuration.IntegratedSecurity)
            {
                connectionStringBuilder.InitialCatalog = configuration.DatabaseName;
                connectionStringBuilder.DataSource     = configuration.ServerName;
                connectionStringBuilder.UserID         = configuration.Username;
                connectionStringBuilder.Password       = configuration.Password;
            }
            else
            {
                connectionStringBuilder.InitialCatalog     = configuration.DatabaseName;
                connectionStringBuilder.DataSource         = configuration.ServerName;
                connectionStringBuilder.IntegratedSecurity = true;
            }

            return(connectionStringBuilder.ToString());
        }
Example #3
0
 public DatabaseSettingService(IConfigurationFactory <DatabaseData> databaseDataConfigurationFactory)
 {
     this.config = databaseDataConfigurationFactory
                   .SetPath()
                   .Create();
 }
Example #4
0
 public ThemeSettingService(IConfigurationFactory <ThemeData> config)
 {
     this.config = config
                   .SetPath()
                   .Create();
 }