public void ShouldWriteQueryWithDBOSchemaAndWithValuesFalseForAddCheckConstrait() { var schemaName = "schemaName"; var tableName = "tableName"; var name = "constraintName"; var expression = "expression"; bool notForReplication = false; var op = new AddCheckConstraintOperation(schemaName, tableName, name, expression, notForReplication, false); Trace.WriteLine(op.ToQuery()); var expectedQuery = @"alter table [schemaName].[tableName] add constraint [constraintName] check (expression)"; Assert.AreEqual(expectedQuery, op.ToQuery()); }
public void ShouldWriteQueryForAddCheckConstraint() { var schemaName = "schemaName"; var tableName = "tableName"; var name = "constraintName"; var expression = "expression"; bool notForReplication = true; bool withNoCheck = true; var op = new AddCheckConstraintOperation(schemaName, tableName, name, expression, notForReplication, withNoCheck); var expectedQuery = @"alter table [schemaName].[tableName] with nocheck add constraint [constraintName] check not for replication (expression)"; Assert.AreEqual(expectedQuery, op.ToQuery()); }