public void SetUp()
{
using (var db = new SampleWebAppDb())
{
DataLayerInitialise.InitialiseThis();
var filepath = TestFileHelpers.GetTestFileFilePath("DbContentSimple.xml");
DataLayerInitialise.ResetDatabaseToTestData(db, filepath);
}
}
public void SetUpFixture()
{
using (var db = new SampleWebAppDb())
{
DataLayerInitialise.InitialiseThis();
var filepath = TestFileHelpers.GetTestFileFilePath("DbContentSimple.xml");
DataLayerInitialise.ResetDatabaseToTestData(db, filepath);
}
new SimplePostDtoAsync(); //sets up the mapping
}
public void FixtureSetup()
{
//This remembers the SqlErrorTextDict
_rememberDefaultSqlErrorTextDict =
GenericServicesConfig.SqlErrorDict.Select(x => new KeyValuePair <int, string>(x.Key, x.Value))
.ToList();
GenericServicesConfig.ClearSqlHandlerDict();
using (var db = new SampleWebAppDb())
{
DataLayerInitialise.InitialiseThis();
var filepath = TestFileHelpers.GetTestFileFilePath("DbContentSimple.xml");
DataLayerInitialise.ResetDatabaseToTestData(db, filepath);
}
}
public void Check10DatabaseResetWithIGenericServicesDbContextOk()
{
using (var db = new SampleWebAppDb() as IGenericServicesDbContext)
{
//SETUP
DataLayerInitialise.InitialiseThis();
var filepath = TestFileHelpers.GetTestFileFilePath("DbContentSimple.xml");
//ATTEMPT
DataLayerInitialise.ResetDatabaseToTestData(db as SampleWebAppDb, filepath);
//VERIFY
db.Set <Blog>().Count().ShouldEqual(2);
db.Set <Post>().Count().ShouldEqual(3);
db.Set <Tag>().Count().ShouldEqual(3);
db.Set <PostTagGrade>().Count().ShouldEqual(2);
}
}
public void Check01DatabaseResetOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
DataLayerInitialise.InitialiseThis();
var filepath = TestFileHelpers.GetTestFileFilePath("DbContentSimple.xml");
//ATTEMPT
DataLayerInitialise.ResetDatabaseToTestData(db, filepath);
//VERIFY
db.Blogs.Count().ShouldEqual(2);
db.Posts.Count().ShouldEqual(3);
db.Tags.Count().ShouldEqual(3);
db.Database.SqlQuery <int>("SELECT COUNT(*) FROM dbo.TagPosts").First().ShouldEqual(5);
db.PostTagGrades.Count().ShouldEqual(2);
}
}
