/// <summary>
/// Save to DB with code first - this will create a new database the first time
/// Edit the connection string in app.config, by default it looks for a local SQL Server instance
/// </summary>
public static void Run()
{
Debug.WriteLine("******************************");
Debug.WriteLine(MethodBase.GetCurrentMethod().Name);
Debug.WriteLine("******************************");
Stream ediStream = File.OpenRead(Directory.GetCurrentDirectory() + @"\..\..\..\Files\X12\PurchaseOrder.txt");
List <IEdiItem> ediItems;
using (var ediReader = new X12Reader(ediStream, "EdiFabric.Templates.X12"))
ediItems = ediReader.ReadToEnd().ToList();
var purchaseOrders = ediItems.OfType <TS850>();
using (var db = new X12Context())
{
foreach (var purchaseOrder in purchaseOrders)
{
purchaseOrder.ClearCache();
db.TS850.Add(purchaseOrder);
}
db.SaveChanges();
}
}
