public async Task FetchWhereInEmptyEnumerableAsync()
{
var request = new DataQuery <Order>();
request.Add(x => x.ID, new int[] { }, ComparisonOperator.In);
var orders = await ConnectorOrders.FetchAllAsync(request);
foreach (var order in orders)
{
Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}");
}
Assert.AreEqual(0, orders.Count);
}
public async Task FetchWhereInIntAsync()
{
var request = new DataQuery <Order>();
//request.WhereClause.Add(new DatabaseDataValueColumn("Order_Key", System.Data.SqlDbType.Int, new int[] { 1, 2,3 }, ComparisonOperator.In));
request.Add(x => x.ID, new int[] { 1, 2, 3 }, ComparisonOperator.In);
var orders = await ConnectorOrders.FetchAllAsync(request);
foreach (var order in orders)
{
Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}");
}
Assert.IsTrue(orders.Count == 3);
}
public void FetchWhereInEmptyEnumerable()
{
var ConnectorOrders = new Connector <Order>();
var request = new DataQuery <Order>();
//request.WhereClause.Add(new DatabaseDataValueColumn("Order_Key", System.Data.SqlDbType.Int, new int[] { 1, 2,3 }, ComparisonOperator.In));
request.Add(x => x.ID, new int[] { }, ComparisonOperator.In);
var orders = ConnectorOrders.FetchAll(request);
foreach (var order in orders)
{
Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}");
}
Assert.AreEqual(0, orders.Count);
}
public async Task FetchWhereInStringAsync()
{
var request = new DataQuery <Product>();
var names = new string[]
{
"TV",
"Laser Mouse",
"E-reader"
};
request.Add(x => x.MetaData.Name, names, ComparisonOperator.In);
var products = await ConnectorProducts.FetchAllAsync(request);
foreach (var product in products)
{
Console.WriteLine($"{product.ID} - {product.MetaData.Name}");
}
Assert.IsTrue(products.Count == 3);
}
