public void Where_WildcardContains()
{
var q = new ODataTest().CreateQuery <Person>(ODataArgs.Create()).WhereWildcard(x => x.Name, "*b*");
Assert.AreEqual("?$select=Id,Name,Dob,Salary,IsAwesome,RecCode&$filter=((Name ne null) and contains(toupper(Name),'B'))&$top=100", GetODataQuery(q));
}
public void Where_StringNotEqual()
{
var q = new ODataTest().CreateQuery <Person>(ODataArgs.Create()).Where(x => x.Name != "abc");
Assert.AreEqual("?$select=Id,Name,Dob,Salary,IsAwesome,RecCode&$filter=(Name ne 'abc')&$top=100", GetODataQuery(q));
}
public void Where_GuidEqual()
{
var q = new ODataTest().CreateQuery <Person>(ODataArgs.Create()).Where(x => x.RecCode == new Guid("D2798DAB-B288-489E-B2BB-04E594F79088"));
Assert.AreEqual("?$select=Id,Name,Dob,Salary,IsAwesome,RecCode&$filter=(RecCode eq guid'd2798dab-b288-489e-b2bb-04e594f79088')&$top=100", GetODataQuery(q));
}
public void Where_DecimalLessThanEqual()
{
var q = new ODataTest().CreateQuery <Person>(ODataArgs.Create()).Where(x => x.Salary <= 99999.99m);
Assert.AreEqual("?$select=Id,Name,Dob,Salary,IsAwesome,RecCode&$filter=(Salary le 99999.99)&$top=100", GetODataQuery(q));
}
public void Where_DateTimeGreaterThanEqual()
{
var q = new ODataTest().CreateQuery <Person>(ODataArgs.Create()).Where(x => x.Dob >= new DateTime(2000, 01, 01));
Assert.AreEqual("?$select=Id,Name,Dob,Salary,IsAwesome,RecCode&$filter=(Dob ge 2000-01-01T00:00:00.0000000)&$top=100", GetODataQuery(q));
}
public void Where_IntGreaterThan()
{
var q = new ODataTest().CreateQuery <Person>(ODataArgs.Create()).Where(x => x.Id > 20);
Assert.AreEqual("?$select=Id,Name,Dob,Salary,IsAwesome,RecCode&$filter=(Id gt 20)&$top=100", GetODataQuery(q));
}
