public virtual void TestInitialize()
{
string connectionString = @"Provider=VFPOLEDB.1;Data Source=" + Path.GetFullPath("Northwind.dbc") + ";Exclusive=false";
this.northwind = new LinqToVfp.Northwind.Tests.NorthwindEntityProvider.NorthwindDataContext(connectionString);
//this.northwind.Provider.Log = new TestContextWriter(this.TestContext);
this.northwind.Provider.AutoRightTrimStrings = true;
}
public void TestCustomersIncludeOrdersAndDetails()
{
NorthwindDataContext nw = new NorthwindDataContext(this.Northwind.Provider.New(new TestPolicy("Orders", "Details")));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
Assert.AreEqual(1, custs.Count);
Assert.AreNotEqual(null, custs[0].Orders);
Assert.AreEqual(6, custs[0].Orders.Count);
Assert.IsTrue(custs[0].Orders.Any(o => o.OrderID == 10643));
Assert.AreNotEqual(null, custs[0].Orders.Single(o => o.OrderID == 10643).Details);
Assert.AreEqual(3, custs[0].Orders.Single(o => o.OrderID == 10643).Details.Count);
}
public void TestCustomersIncludeOrders()
{
NorthwindDataContext nw = new NorthwindDataContext(this.Northwind.Provider.New(new TestPolicy("Orders")));
var custs = nw.Customers.Where(c => c.CustomerID == "ALFKI").ToList();
Assert.AreEqual(1, custs.Count);
Assert.AreNotEqual(null, custs[0].Orders);
Assert.AreEqual(6, custs[0].Orders.Count);
}
public void TestCustomersWhereIncludeOrdersAndDetails()
{
NorthwindDataContext nw = new NorthwindDataContext(this.Northwind.Provider.New(new TestPolicy("Orders", "Details")));
TestQuery(
from c in nw.Customers
where c.City == "London"
select c
);
}
public void TestCustomersIncludeOrdersAndDetails()
{
NorthwindDataContext nw = new NorthwindDataContext(this.Northwind.Provider.New(new TestPolicy("Orders", "Details")));
TestQuery(
nw.Customers
);
}
public void TestXmlMappingSelectCustomers()
{
var nw = new NorthwindDataContext(this.Northwind.Provider.New(VfpXmlMapping.FromXml(Properties.Resources.NorthwindXml)));
TestQuery(
from c in this.Northwind.Customers
where c.City == "London"
select c.ContactName
);
}