public void ReverseNavigation_Standard()
{
var db = new TestDatabaseStandard.TestDbContext();
var boo = db.Stafford_Boos.First(b => b.Id == _fooStd.Stafford_Boo.Id);
Assert.IsNotNull(boo.Stafford_Foo);
}
public void NormalNavigation_Standard()
{
var db = new TestDatabaseStandard.TestDbContext();
var foo = db.Stafford_Foos.First(f => f.Id == _fooStd.Id);
Assert.IsNotNull(foo.Stafford_Boo);
}
public void ReverseNavigation_Standard()
{
Console.WriteLine(_fooStd.Stafford_Boo.Id);
using var db = new TestDatabaseStandard.TestDbContext();
var boo = db.Stafford_Boos.Include(x => x.Stafford_Foo).First(b => b.Id == _fooStd.Stafford_Boo.Id);
Assert.IsNotNull(boo);
Assert.IsNotNull(boo.Stafford_Foo);
}
public void SetUp()
{
using var std = new TestDatabaseStandard.TestDbContext();
std.Database.ExecuteSqlRaw("DELETE FROM Stafford.Foo; DELETE FROM Stafford.Boo;");
_fooStd = new TestDatabaseStandard.Stafford_Foo {
Name = "Foo", Stafford_Boo = new TestDatabaseStandard.Stafford_Boo {
Name = "Boo"
}
};
std.Stafford_Foos.Add(_fooStd);
std.SaveChanges();
}
public void Standard_test()
{
// Arrange
using var db = new TestDatabaseStandard.TestDbContext();
// Act
var data = db.CsvToInt("123,456", "").ToList();
// Assert
Assert.AreEqual(2, data.Count);
Assert.AreEqual(123, data[0].IntValue);
Assert.AreEqual(456, data[1].IntValue);
}
public void Standard_FunctionInNonDefaultSchemaCanBeCalled()
{
// Arrange
using var db = new TestDatabaseStandard.TestDbContext();
// Act
var data = db.CustomSchema_CsvToIntWithSchema("123,456", "").ToList();
// Assert
Assert.AreEqual(2, data.Count);
Assert.AreEqual(123, data[0].IntValue);
Assert.AreEqual(456, data[1].IntValue);
}
public void Validation_WhenEntityHasComputedColumn_ShouldValidate_Standard()
{
var db = new TestDatabaseStandard.TestDbContext();
var entity = new TestDatabaseStandard.Stafford_ComputedColumn {
MyColumn = "something"
};
db.Stafford_ComputedColumns.Add(entity);
var validationErrors = db.GetValidationErrors()
.SelectMany(p => p.ValidationErrors)
.Select(p => $"{p.PropertyName} - ${p.ErrorMessage})");
Assert.IsEmpty(validationErrors);
}
public void SetUp()
{
var std = new TestDatabaseStandard.TestDbContext();
std.Database.ExecuteSqlCommand("DELETE FROM Stafford.Foo; DELETE FROM Stafford.Boo;");
_fooStd = std.Stafford_Foos.Add(new TestDatabaseStandard.Stafford_Foo {
Name = "Foo", Stafford_Boo = new TestDatabaseStandard.Stafford_Boo {
Name = "Boo"
}
});
std.SaveChanges();
var da = new TestDatabaseDataAnnotation.TestDbContext();
_fooDa = da.Stafford_Foos.Add(new TestDatabaseDataAnnotation.Stafford_Foo {
Name = "Foo", Stafford_Boo = new TestDatabaseDataAnnotation.Stafford_Boo {
Name = "Boo"
}
});
da.SaveChanges();
}
