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"); } }