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);
        }