public void TestNullIn()
{
// arrange
// act
var values = StartTest()
.Where(x => x.Byte_N.In(new byte?[] { null }))
.ToArray(Executor);
// assert
Assert.AreEqual(1, values.Length);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestDivide()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey / 2 == TestDataTables.DataTypeTestNulled.PrimaryKey / 2)
.ToList(Executor);
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestNonEquality()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey != TestDataTables.DataTypeTestNotNulled.PrimaryKey)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestEqualityForNullable()
{
// arrange
// act
var values = StartTest()
.Where(x => x.Float_N == null)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestValues()
{
// arrange
// act
var values = StartTest()
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(2, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0]);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1]);
}
public void TestOrderByDesc()
{
// arrange
// act
var values = StartTest()
.OrderByDesc(x => x.PrimaryKey)
.ToList(Executor);
// assert
Assert.AreEqual(2, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[1]);
}
public void TestAndCondition()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey == TestDataTables.DataTypeTestNotNulled.PrimaryKey && x.DateTime == TestDataTables.DataTypeTestNotNulled.DateTime)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0]);
}
public void TestIn()
{
// arrange
// act
var values = StartTest()
.Where(x => x.PrimaryKey.In(new int[1] {
TestDataTables.DataTypeTestNulled.PrimaryKey
}))
.ToArray(Executor);
// assert
Assert.AreEqual(1, values.Length);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestGreaterThan()
{
// arrange
var pk = TestDataTables.DataTypeTestNulled.PrimaryKey - 1;
// act
var values = StartTest()
.Where(x => x.PrimaryKey > pk)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(1, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]);
}
public void TestJoins()
{
// arrange
// act
var values = Query <One2One>()
.From(x => x.T1)
.InnerJoinOne(x => x.T2).On((q, t2) => q.T1.PrimaryKey == t2.PrimaryKey)
.ToIEnumerable(Executor)
.ToList();
// assert
Assert.AreEqual(2, values.Count);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0].T1);
TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0].T2);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1].T1);
TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1].T2);
}
