public void GetDbRows_Good(string connString, string tableName, string appIdCol, string keyCol, string valCol, string appIdVal, string testCase) { DbSourceOptions options = new DbSourceOptions() { ConnString = connString, TableName = tableName, AppIdCol = appIdCol, KeyCol = keyCol, ValCol = valCol, AppIdVal = appIdVal }; ISqlClientAdo sqlClientDAL = new SqlClientAdo(options); var actual = sqlClientDAL.GetDbRows(); var expected = JsonConvert.DeserializeObject <List <ConfigSetting> >(File.ReadAllText($"TestCases\\DbSource\\SqlClientAdo\\GetDbRows\\Good\\expected{testCase}.json")); Assert.True(TestHelper.SettingsAreEqual(expected, actual)); }
// Accepts configuration parameter for non-default database options public DbConfigSource(IConfigurationBuilder builder, IConfiguration config, bool optional) { _optional = optional; try { // Create new dboptions object DbSourceOptions dbOptions = new DbSourceOptions(config, optional); // Initialize Sql client with dbOptions object _sqlClient = new SqlClientAdo(dbOptions); } catch (Exception e) { if (!optional) { throw e; } return; } }
// public DbConfigSource(IConfigurationBuilder builder, string conKeyVar, string appId, int sqlCommandTimeout, bool optional) { _optional = optional; try { // Create new dboptions object DbSourceOptions dbOptions = new DbSourceOptions(conKeyVar, appId, optional, sqlCommandTimeout); // Initialize Sql client with dbOptions object _sqlClient = new SqlClientAdo(dbOptions); } catch (Exception e) { if (!optional) { throw e; } return; } }
public SqlClientAdo(DbSourceOptions options) { _options = options; }