public virtual void UInt16a()
{
Excute(p => SqlFunctions.Between(p.UInt16, 12, 13).Value);
Excute(p => SqlFunctions.Between(p.UInt16, 11, 12).Value);
Excute(p => SqlFunctions.Between(p.UInt16, 11, 13).Value);
ExcuteNull(p => SqlFunctions.Between(p.UInt16, 10, 11).Value);
ExcuteNull(p => SqlFunctions.Between(p.UInt16, 13, 14).Value);
}
public virtual void UInt64a()
{
Excute(p => SqlFunctions.Between(p.UInt64, 22, 132).Value);
Excute(p => SqlFunctions.Between(p.UInt64, 33, 132).Value);
Excute(p => SqlFunctions.Between(p.UInt64, 22, 33).Value);
ExcuteNull(p => SqlFunctions.Between(p.UInt64, 10, 32).Value);
ExcuteNull(p => SqlFunctions.Between(p.UInt64, 34, 143).Value);
}
public virtual void UInt32a()
{
Excute(p => SqlFunctions.Between(p.UInt32, 122, 132).Value);
Excute(p => SqlFunctions.Between(p.UInt32, 123, 132).Value);
Excute(p => SqlFunctions.Between(p.UInt32, 122, 123).Value);
ExcuteNull(p => SqlFunctions.Between(p.UInt32, 10, 11).Value);
ExcuteNull(p => SqlFunctions.Between(p.UInt32, 133, 143).Value);
}
public virtual void DateTimeNow()
{
DateTime dt = new DateTime(1997, 8, 25);
var actual = db.Orders.Where(o => o.OrderDate == dt && SqlFunctions.Between(DateTime.Now, o.OrderDate, new DateTime(2015, 10, 10))).FirstOrDefault();
Assert.IsNotNull(actual);
}
public virtual void DateTimea()
{
Excute(p => SqlFunctions.Between(p.DateTime, new DateTime(2012, 1, 1, 10, 10, 20), new DateTime(2013, 2, 15, 1, 1, 1)).Value);
Excute(p => SqlFunctions.Between(p.DateTime, new DateTime(2013, 1, 15, 10, 26, 40), new DateTime(2013, 2, 15, 1, 1, 1)).Value);
Excute(p => SqlFunctions.Between(p.DateTime, new DateTime(2012, 1, 1, 10, 10, 20), new DateTime(2013, 1, 15, 10, 26, 40)).Value);
Excute(p => SqlFunctions.Between(p.DateTime, new DateTime(2013, 1, 15, 10, 26, 40), new DateTime(2013, 1, 15, 10, 26, 40)).Value);
ExcuteNull(p => SqlFunctions.Between(p.DateTime, new DateTime(2012, 1, 1, 10, 10, 20), new DateTime(2012, 2, 15, 1, 1, 1)).Value);
ExcuteNull(p => SqlFunctions.Between(p.DateTime, new DateTime(2013, 2, 1, 10, 10, 20), new DateTime(2013, 2, 15, 1, 1, 1)).Value);
}
public virtual void Stringa()
{
Excute(p => SqlFunctions.Between(p.String, "abc", "abcde"));
Excute(p => SqlFunctions.Between(p.String, "abcd", "abcde"));
Excute(p => SqlFunctions.Between(p.String, "abc", "abcd"));
Excute(p => SqlFunctions.Between(p.String, "abcd", "abcd"));
ExcuteNull(p => SqlFunctions.Between(p.String, "ab", "abc"));
ExcuteNull(p => SqlFunctions.Between(p.String, "abcde", "abcdf"));
}
public virtual void Decimala()
{
Excute(p => SqlFunctions.Between(p.Decimal, 9, 11).Value);
Excute(p => SqlFunctions.Between(p.Decimal, 10, 11).Value);
Excute(p => SqlFunctions.Between(p.Decimal, 9, 10).Value);
Excute(p => SqlFunctions.Between(p.Decimal, 10, 10).Value);
ExcuteNull(p => SqlFunctions.Between(p.Decimal, 8, 9).Value);
ExcuteNull(p => SqlFunctions.Between(p.Decimal, 11, 12).Value);
}
public virtual void Doublea()
{
Excute(p => SqlFunctions.Between(p.Double, 23.0, 24.0).Value);
Excute(p => SqlFunctions.Between(p.Double, 23.21, 132.0).Value);
Excute(p => SqlFunctions.Between(p.Double, 22.0, 23.21).Value);
Excute(p => SqlFunctions.Between(p.Double, 23.21, 23.21).Value);
ExcuteNull(p => SqlFunctions.Between(p.Double, 10.0, 23.0).Value);
ExcuteNull(p => SqlFunctions.Between(p.Double, 24.0, 143.0).Value);
}
public virtual void UInt64b()
{
Excute(p => SqlFunctions.Between(p.UInt64, 22, 132) == true);
Excute(p => SqlFunctions.Between(p.UInt64, 33, 132) == true);
Excute(p => SqlFunctions.Between(p.UInt64, 22, 33) == true);
Excute(p => SqlFunctions.Between(p.UInt64, 10, 32) == false);
Excute(p => SqlFunctions.Between(p.UInt64, 34, 143) == false);
ExcuteNull(p => SqlFunctions.Between(p.UInt64, 10, 32) == true);
ExcuteNull(p => SqlFunctions.Between(p.UInt64, 34, 143) == true);
}
public virtual void UInt32b()
{
Excute(p => SqlFunctions.Between(p.UInt32, 122, 132) == true);
Excute(p => SqlFunctions.Between(p.UInt32, 123, 132) == true);
Excute(p => SqlFunctions.Between(p.UInt32, 122, 123) == true);
Excute(p => SqlFunctions.Between(p.UInt32, 10, 11) == false);
Excute(p => SqlFunctions.Between(p.UInt32, 133, 143) == false);
ExcuteNull(p => SqlFunctions.Between(p.UInt32, 10, 11) == true);
ExcuteNull(p => SqlFunctions.Between(p.UInt32, 133, 143) == true);
}
public virtual void UInt16b()
{
Excute(p => SqlFunctions.Between(p.UInt16, 12, 13) == true);
Excute(p => SqlFunctions.Between(p.UInt16, 11, 12) == true);
Excute(p => SqlFunctions.Between(p.UInt16, 11, 13) == true);
Excute(p => SqlFunctions.Between(p.UInt16, 10, 11) == false);
Excute(p => SqlFunctions.Between(p.UInt16, 13, 14) == false);
ExcuteNull(p => SqlFunctions.Between(p.UInt16, 10, 11) == true);
ExcuteNull(p => SqlFunctions.Between(p.UInt16, 13, 14) == true);
}
public virtual void Int16c()
{
Excute(p => SqlFunctions.Between(p.Int16, 12, 13).Value == true);
Excute(p => SqlFunctions.Between(p.Int16, 11, 12).Value == true);
Excute(p => SqlFunctions.Between(p.Int16, 11, 13).Value == true);
Excute(p => SqlFunctions.Between(p.Int16, 12, 12).Value == true);
Excute(p => SqlFunctions.Between(p.Int16, 10, 11).Value == false);
Excute(p => SqlFunctions.Between(p.Int16, 13, 14).Value == false);
ExcuteNull(p => SqlFunctions.Between(p.Int16, 10, 11).Value == true);
ExcuteNull(p => SqlFunctions.Between(p.Int16, 13, 14).Value == true);
}
public virtual void Decimalb()
{
Excute(p => SqlFunctions.Between(p.Decimal, 9, 11) == true);
Excute(p => SqlFunctions.Between(p.Decimal, 10, 11) == true);
Excute(p => SqlFunctions.Between(p.Decimal, 9, 10) == true);
Excute(p => SqlFunctions.Between(p.Decimal, 10, 10) == true);
Excute(p => SqlFunctions.Between(p.Decimal, 8, 9) == false);
Excute(p => SqlFunctions.Between(p.Decimal, 11, 12) == false);
ExcuteNull(p => SqlFunctions.Between(p.Decimal, 8, 9) == true);
ExcuteNull(p => SqlFunctions.Between(p.Decimal, 11, 12) == true);
}
public virtual void Doubleb()
{
Excute(p => SqlFunctions.Between(p.Double, 23.0, 24.0) == true);
Excute(p => SqlFunctions.Between(p.Double, 23.21, 132.0) == true);
Excute(p => SqlFunctions.Between(p.Double, 22.0, 23.21) == true);
Excute(p => SqlFunctions.Between(p.Double, 23.21, 23.21) == true);
Excute(p => SqlFunctions.Between(p.Double, 10.0, 23.0) == false);
Excute(p => SqlFunctions.Between(p.Double, 24.0, 143.0) == false);
ExcuteNull(p => SqlFunctions.Between(p.Double, 10.0, 23.0) == true);
ExcuteNull(p => SqlFunctions.Between(p.Double, 24.0, 143.0) == true);
}
public virtual void Int64c()
{
Excute(p => SqlFunctions.Between(p.Int64, 22, 132).Value == true);
Excute(p => SqlFunctions.Between(p.Int64, 33, 132).Value == true);
Excute(p => SqlFunctions.Between(p.Int64, 22, 33).Value == true);
Excute(p => SqlFunctions.Between(p.Int64, 33, 33).Value == true);
Excute(p => SqlFunctions.Between(p.Int64, 10, 32).Value == false);
Excute(p => SqlFunctions.Between(p.Int64, 34, 143).Value == false);
ExcuteNull(p => SqlFunctions.Between(p.Int64, 10, 32).Value == true);
ExcuteNull(p => SqlFunctions.Between(p.Int64, 34, 143).Value == true);
}
public virtual void Int32c()
{
Excute(p => SqlFunctions.Between(p.Int32, 122, 132).Value == true);
Excute(p => SqlFunctions.Between(p.Int32, 123, 132).Value == true);
Excute(p => SqlFunctions.Between(p.Int32, 122, 123).Value == true);
Excute(p => SqlFunctions.Between(p.Int32, 123, 123).Value == true);
Excute(p => SqlFunctions.Between(p.Int32, 10, 11).Value == false);
Excute(p => SqlFunctions.Between(p.Int32, 133, 143).Value == false);
ExcuteNull(p => SqlFunctions.Between(p.Int32, 10, 11).Value == true);
ExcuteNull(p => SqlFunctions.Between(p.Int32, 133, 143).Value == true);
}
