private static IDbConnectionProvider CreateSqlConnectionProvider(DbConfig dbConfig) { return new QcDbConnectionProvider(() => { SqlConnectionStringBuilder csBuilder = new SqlConnectionStringBuilder(); if (!string.IsNullOrEmpty(dbConfig.DataSource)) csBuilder.DataSource = dbConfig.DataSource; if (!string.IsNullOrEmpty(dbConfig.Database)) csBuilder.InitialCatalog = dbConfig.Database; csBuilder.IntegratedSecurity = dbConfig.IntegratedSecurity > 0; if (!string.IsNullOrEmpty(dbConfig.UserId)) csBuilder.UserID = dbConfig.UserId; if (dbConfig.EncryptedPassword != null) csBuilder.Password = Encryption.LocalEncryption.DecryptString(dbConfig.EncryptedPassword); csBuilder.Pooling = false; return new SqlConnection(csBuilder.ConnectionString); }); }
return new SqlConnection(csBuilder.ConnectionString);
DbConfig configDbConfig = new DbConfig { Database = codeFile.ConfigurationDb, DataSource = codeFile.DataSource, IntegratedSecurity = sqlCredentials.UseWindowsAuthentication ? 1 : 0, UserId = sqlCredentials.UseWindowsAuthentication ? null : sqlCredentials.SqlUserName, ClearTextPassword = sqlCredentials.UseWindowsAuthentication ? null : sqlCredentials.SqlUserPassword };
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)