public IEnumerable <CustomerOrder> GetCustomerOrderData()
{
using (CustomerOrderDBContext dBContext = new CustomerOrderDBContext())
{
return((from c in dBContext.Customers
join o in dBContext.Orders on c.CustomerId equals o.OrderCustomerId
select new CustomerOrder()
{
CustomerFirstName = c.CustomerFirstName,
CustomerLastName = c.CustomerLastName,
OrderId = o.OrderId,
OrderCustomerId = o.OrderCustomerId
}).ToList());
}
}
public void CreateEntityMapping(List <object> fileHelperModel)
{
//Initializing Automapper for anonymous type usage as the source is not known during compile time
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMissingTypeMaps = true;
});
var mapper = config.CreateMapper();
//Conversion of object list into DBEntity Model
List <Order> olist = fileHelperModel.Select(mapper.Map <Order>).ToList();
using (CustomerOrderDBContext dBContext = new CustomerOrderDBContext())
{
foreach (Order o in olist)
{
dBContext.Orders.Add(o);
}
dBContext.SaveChanges();
}
}
