public SqlNullValuesTests(PlatformSpecificTestContext context) { fixture = context.Fixture; tableName = fixture.SqlNullValuesTable.Name; // Disable the cache to avoid false failures. SqlConnection.ColumnEncryptionQueryMetadataCacheEnabled = false; foreach (string connStr in DataTestUtility.AEConnStringsSetup) { // Insert data and create functions for SqlNullValues test. using (SqlConnection sqlConnection = new SqlConnection(connStr)) { sqlConnection.Open(); using (SqlCommand cmd = new SqlCommand(string.Format("INSERT INTO [{0}] (c1) VALUES (@c1)", tableName), sqlConnection, null, SqlCommandColumnEncryptionSetting.Enabled)) { SqlParameter param = cmd.Parameters.Add("@c1", SqlDbType.Int); param.Value = DBNull.Value; cmd.ExecuteNonQuery(); param.Value = 10; cmd.ExecuteNonQuery(); } string sql1 = $"CREATE FUNCTION {UdfName}() RETURNS INT AS \n BEGIN \n RETURN (SELECT c1 FROM [{tableName}] WHERE c1 IS NULL)\n END"; string sql2 = $"CREATE FUNCTION {UdfNameNotNull}() RETURNS INT AS \n BEGIN \n RETURN (SELECT c1 FROM [{tableName}] WHERE c1 IS NOT NULL)\n END"; using (SqlCommand cmd = sqlConnection.CreateCommand()) { cmd.CommandText = sql1; cmd.ExecuteNonQuery(); cmd.CommandText = sql2; cmd.ExecuteNonQuery(); } } } }
public BulkCopyAE(PlatformSpecificTestContext context) { fixture = context.Fixture; tableName = fixture.BulkCopyAETestTable.Name; }
public End2EndSmokeTests(PlatformSpecificTestContext context) { fixture = context.Fixture; tableName = fixture.End2EndSmokeTable.Name; }
public SqlBulkCopyTruncation(PlatformSpecificTestContext context) { _fixture = context.Fixture; tableNames = _fixture.sqlBulkTruncationTableNames; }
public BulkCopyAEErrorMessage(PlatformSpecificTestContext context) { _fixture = context.Fixture; _tableName = _fixture.BulkCopyAEErrorMessageTestTable.Name; _columnName = "c1"; }