public void TestXmlToCursorNotIn()
{
var northwind = GetContext();
var ids = OrderIds.Take(160).ToArray();
var list = northwind.Orders.Where(order => !ids.Contains(order.OrderID)).ToList();
Assert.AreEqual(670, list.Count);
}
public void TestXmlToCursorOrIn()
{
var northwind = GetContext();
var ids1 = OrderIds.Take(50).ToArray();
var ids2 = CustomerIds.Take(50).ToArray();
var list = northwind.Orders
.Where(order => ids1.Contains(order.OrderID) || ids2.Contains(order.Customer.CustomerID))
.ToList();
Assert.AreEqual(483, list.Count);
}
public void TestXmlToCursorMultiple()
{
var northwind = GetContext();
var orderIds = OrderIds.Take(160).ToArray();
var customerIds = CustomerIds.ToArray();
var list = northwind.Orders
.Where(order => orderIds.Contains(order.OrderID) && customerIds.Contains(order.Customer.CustomerID))
.ToList();
Assert.AreEqual(160, list.Count);
}