private void ClearRepository()
{
using (var context = new TestContext())
{
context.Tests.Where(entity => true).ForEach(entity => context.Tests.Remove(entity));
context.SaveChanges();
}
}
public void InitDb()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<TestContext, Configuration>());
using (var context = new TestContext())
{
context.Database.Initialize(force:false);
}
}
public static void InitDb()
{
var path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"..\..\App_Data");
path = Path.GetFullPath(path);
AppDomain.CurrentDomain.SetData("DataDirectory", path);
Database.SetInitializer(new MigrateDatabaseToLatestVersion<TestContext, Configuration>());
using (var context = new TestContext())
{
context.Database.Initialize(force:false);
}
}
public void SqlFilterQueryFixture()
{
ClearRepository();
using (var context = new TestContext())
{
context.Tests.Add(new TestModel() {TestId = 1, TestData = "data1"});
context.Tests.Add(new TestModel() { TestId = 2, TestData = "data2" });
context.SaveChanges();
}
using (var context = new TestContext())
{
var list = context.Tests.SqlFilterQuery(EFExtensions.GetTableName<TestModel, TestContext>(true), "TestId=1").ToList();
list.Should().Count.Exactly(1);
list[0].TestId.Should().Equal(1);
}
ClearRepository();
}
