public void TestDifferentDefaultValuesReturnErrors()
{
//SETUP
using (var context = new Issue15DbContext(_options))
{
var comparer = new CompareEfSql();
//ATTEMPT
var hasErrors = comparer.CompareEfWithDb(context);
//VERIFY
//hasErrors.ShouldBeFalse(comparer.GetAllErrors);
hasErrors.ShouldBeTrue();
comparer.GetAllErrors.ShouldEqual(@"DIFFERENT: Message->Property 'BoolRequiredDefaultFalse', default value sql. Expected = False, found = <null>
DIFFERENT: Message->Property 'BoolRequiredDefaultFalse', value generated. Expected = OnAdd, found = Never
DIFFERENT: Message->Property 'BoolRequiredDefaultTrue', default value sql. Expected = True, found = 1
DIFFERENT: Message->Property 'EnumRequiredDefaultOne', default value sql. Expected = One, found = 1
DIFFERENT: Message->Property 'EnumRequiredDefaultZero', default value sql. Expected = Zero, found = <null>
DIFFERENT: Message->Property 'EnumRequiredDefaultZero', value generated. Expected = OnAdd, found = Never
DIFFERENT: Message->Property 'IntRequiredDefault0', default value sql. Expected = 0, found = <null>
DIFFERENT: Message->Property 'IntRequiredDefault0', value generated. Expected = OnAdd, found = Never
DIFFERENT: Message->Property 'StringRequiredDefaultEmpty', default value sql. Expected = , found = N''
DIFFERENT: Message->Property 'StringRequiredDefaultSomething', default value sql. Expected = something, found = N'something'
DIFFERENT: Message->Property 'XmlRequiredDefaultEmpty', default value sql. Expected = , found = N''
DIFFERENT: Message->Property 'XmlRequiredDefaultSomething', default value sql. Expected = <something />, found = N'<something />'");
}
}
public Issue015Tests(ITestOutputHelper output)
{
_output = output;
_options = this
.CreateUniqueClassOptions <Issue15DbContext>();
using (var context = new Issue15DbContext(_options))
{
_connectionString = context.Database.GetDbConnection().ConnectionString;
context.Database.EnsureCreated();
}
}
public void TestDifferentDefaultValuesSuppressDefaultValueErrors()
{
//SETUP
using (var context = new Issue15DbContext(_options))
{
var config = new CompareEfSqlConfig();
config.AddIgnoreCompareLog(new CompareLog(CompareType.Property, CompareState.Different, null, CompareAttributes.DefaultValueSql));
config.AddIgnoreCompareLog(new CompareLog(CompareType.Property, CompareState.Different, null, CompareAttributes.ValueGenerated, "OnAdd", "Never"));
var comparer = new CompareEfSql(config);
//ATTEMPT
var hasErrors = comparer.CompareEfWithDb(context);
//VERIFY
hasErrors.ShouldBeFalse(comparer.GetAllErrors);
}
}
public void TestDifferentDefaultValuesReturnErrors()
{
//SETUP
using (var context = new Issue15DbContext(_options))
{
var comparer = new CompareEfSql();
//ATTEMPT
var hasErrors = comparer.CompareEfWithDb(context);
//VERIFY
//hasErrors.ShouldBeFalse(comparer.GetAllErrors);
hasErrors.ShouldBeTrue();
comparer.GetAllErrors.ShouldEqual(@"DIFFERENT: Message->Property 'BoolRequiredDefaultFalse', default value sql. Expected = CAST(0 AS bit), found = CONVERT([bit],(0))
DIFFERENT: Message->Property 'BoolRequiredDefaultTrue', default value sql. Expected = CAST(1 AS bit), found = CONVERT([bit],(1))
DIFFERENT: Message->Property 'EnumRequiredDefaultZero', default value sql. Expected = 0, found = <null>
DIFFERENT: Message->Property 'EnumRequiredDefaultZero', value generated. Expected = OnAdd, found = Never
DIFFERENT: Message->Property 'IntRequiredDefault0', default value sql. Expected = 0, found = <null>
DIFFERENT: Message->Property 'IntRequiredDefault0', value generated. Expected = OnAdd, found = Never");
}
}
