static void Main(string[] args)
{
var cn = new DapperDemoContext();
Console.WriteLine("Dapper Multi Mapping");
var quotesRepository = new QuoteRequestRepository(cn);
Console.WriteLine("\nGet Quotations By Purchase Order Id - Objects inside QuoteRequest object");
foreach (var item in quotesRepository.GetQuotationsByPurchaseOrderId(1))
{
Console.WriteLine(item.PurchaseOrderId.ToString() + "|" + item.PriceQuoted + "|" + item.QuantityQuoted
+ "|" + item.Product.Name + "|" + item.PurchaseOrderItem.Quantity + "|" + item.Supplier.Name);
}
var orderRepository = new PurchaseOrderRepository(cn);
var itemList = new List <PurchaseOrder>(orderRepository.GetItemsByPurchaseOrderId(1));
Console.WriteLine("\nGet Itens By Purchase Order Id - Collection inside PurchaseOrder object - SQL hard coded");
bool first = true;
foreach (var order in itemList)
{
if (first)
{
Console.WriteLine(order.PurchaseOrderId + "|" + order.CreateDate + "|" + order.Status);
}
first = false;
foreach (var item in order.PurchaseOrderItems)
{
Console.WriteLine("\t" + item.Product.Name + "| Quantity: " + item.Quantity);
}
}
var spItemList = new List <PurchaseOrder>(orderRepository.spGetItemsByPurchaseOrderId(1));
Console.WriteLine("\nGet Itens By Purchase Order Id - Collection inside PurchaseOrder object - Store Procedure");
bool spFirst = true;
foreach (var order in spItemList)
{
if (spFirst)
{
Console.WriteLine(order.PurchaseOrderId + "|" + order.CreateDate + "|" + order.Status);
}
spFirst = false;
foreach (var item in order.PurchaseOrderItems)
{
Console.WriteLine("\t" + item.Product.Name + "| Quantity: " + item.Quantity);
}
}
Console.ReadKey();
}
public ProductRepository(DapperDemoContext context)
{
Db = context;
}
public QuoteRequestRepository(DapperDemoContext context)
{
Db = context;
}
public PurchaseOrderRepository(DapperDemoContext context)
{
Db = context;
}