public void TestBin2CollationOnProjectRule()
{
using (BaselinedRuleTest test = new BaselinedRuleTest(
TestContext,
"TestBin2CollationOnProjectRule",
new TSqlModelOptions(),
SqlServerVersion.Sql120))
{
test.DatabaseOptions.Collation = "SQL_Latin1_General_CP437_BIN2";
test.RunTest(InMemoryTableBin2CollationRule.RuleId);
}
}
public void TestAvoidWaitForDelay()
{
using (BaselinedRuleTest test = new BaselinedRuleTest(
TestContext,
"AvoidWaitForDelayRule",
new TSqlModelOptions(),
SqlServerVersion.Sql120))
{
// Since this test verifies results against a baseline file, we don't need to do any extra verification
test.RunTest(AvoidWaitForDelayRule.RuleId);
}
}
public void TestNonBin2CollationOnProjectRule()
{
// Test with the default (non-BIN2) collation
using (BaselinedRuleTest test = new BaselinedRuleTest(
TestContext,
"TestNonBin2CollationOnProjectRule",
new TSqlModelOptions(),
SqlServerVersion.Sql120))
{
// Since this test verifies results against a baseline file, we don't need to do any extra verification
test.RunTest(InMemoryTableBin2CollationRule.RuleId);
}
}
public void TestStoredProcedureNamingRule()
{
// Test with a BIN2 collation to ensure character indexes work successfully
using (BaselinedRuleTest test = new BaselinedRuleTest(
TestContext,
"TestStoredProcedureNamingRule",
new TSqlModelOptions()
{
Collation = "SQL_Latin1_General_CP437_BIN2"
},
SqlServerVersion.Sql120))
{
test.RunTest(CapitalizedNamesRule.RuleId);
}
}
public void TestViewOnMemoryOptimizedTableRule()
{
// Test with a BIN2 collation to ensure character indexes work successfully
using (BaselinedRuleTest test = new BaselinedRuleTest(
TestContext,
"TestViewOnMemoryOptimizedTableRule",
new TSqlModelOptions()
{
Collation = "SQL_Latin1_General_CP437_BIN2"
},
SqlServerVersion.Sql120))
{
test.RunTest(ViewsOnMemoryOptimizedTableRule.RuleId);
}
}