public void WhereTest1()
{
using (var context = new WebApiContext(null, null))
{
var guid = Guid.NewGuid();
var query =
context.CreateQuery <Account>();
var command = context.GetQueryText(query.Expression);
Assert.Equal("accounts", command);
}
}
public void WhereTest3()
{
using (var context = new WebApiContext(null, null))
{
var guid = Guid.NewGuid();
var query =
context.CreateQuery <Account>()
.Where(p => p.StateCode == account_statecode.Active);
var command = context.GetQueryText(query.Expression);
Assert.Equal("accounts?$filter=(statecode eq 0)", command);
}
}
public void WhereTest2()
{
using (var context = new WebApiContext(null, null))
{
var guid = Guid.NewGuid();
var query =
context.CreateQuery <Account>()
.Where(p => p.Name == "Test");
var command = context.GetQueryText(query.Expression);
Assert.Equal("accounts?$filter=(name eq 'Test')", command);
}
}
public void SelectTest1()
{
using (var context = new WebApiContext(null, null))
{
var guid = Guid.NewGuid();
var query =
context
.CreateQuery <CustomerAddress>()
.Where(p => p.ParentId == new Account(guid).ToNavigationProperty())
.Select(p => new { Id = p.Id, OwnerId = p.OwnerId });
var command = context.GetQueryText(query.Expression);
Assert.Equal($"customeraddresses?$select=customeraddressid,_ownerid_value&$filter=(_parentid_value eq '{guid}')", command);
}
}
public void WhereTest6()
{
using (var context = new WebApiContext(null, null))
{
var guid = Guid.NewGuid();
var query =
context.CreateQuery <CustomerAddress>()
.Where(p => p.ParentId == new Account(guid).ToNavigationProperty())
.Where(p => p.ShippingMethodCode == customeraddress_shippingmethodcode.Airborne && p.Country == "Canada");
var command = context.GetQueryText(query.Expression);
Assert.Equal($"customeraddresses?$filter=(_parentid_value eq '{guid}') and (shippingmethodcode eq 1 and country eq 'Canada')", command);
}
}