private void ClearRepository()
{
using (var context = new TestContext())
{
context.Tests.Where(entity => true).ForEach(entity => context.Tests.Remove(entity));
context.SaveChanges();
}
}
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();
}
