public static DbContextOptions Setup(DbContextOptions options)
{
var doc = XDocument.Load(Path.Combine(
Path.GetDirectoryName(typeof(CustomerDataTests).GetTypeInfo().Assembly.Location),
"TestData", "TestData.xml"));
var import = new XmlImport(doc, "http://tempuri.org/Database.xsd");
var customer = new List <Customer>();
using (var session = new CoreDbContext(options))
{
import.Parse(new[] { typeof(Customer), typeof(Order), typeof(Product) },
(type, obj) =>
{
switch (type.Name)
{
case nameof(Customer):
session.Customers.Add((Customer)obj);
break;
case nameof(Order):
session.Orders.Add((Order)obj);
break;
case nameof(Product):
session.Products.Add((Product)obj);
break;
default:
break;
}
});
session.SaveChanges();
}
using (var session = new CoreDbContext(options))
{
import.ParseConnections("OrderProduct", "Product", "Order", (productId, orderId) =>
{
var product = session.GetProduct(productId);
var order = session.GetOrder(orderId);
session.ProductOrders.Add(new ProductOrder {
Order = order, Product = product
});
});
import.ParseIntProperty("Order", "Customer", (orderId, customerId) =>
{
var order = session.GetOrder(orderId);
order.Customer = session.GetCustomer(customerId);
});
session.SaveChanges();
}
return(options);
}
public void CanGetCustomerById()
{
var customer = Session.GetCustomer(1);
Assert.NotNull(customer);
}
