public void Add(Order order) { var orderState = new Order.ToState().Build(order); using (var connection = new SqlConnection(SqlConnectionLocator.LocalhostSqlExpress())) { connection.Execute(SqlQueries.InsertOrderQuery, orderState); connection.Execute(SqlQueries.InsertOrderLineQuery, orderState.Lines); } }
public void Add(Order order) { var orderState = new Order.ToState().Build(order); using (var dataContext = new DataContext()) { dataContext.Set<OrderState>().Add(orderState); dataContext.SaveChanges(); } }
public void Update(Order order) { var orderState = new Order.ToState().Build(order); using (var dataContext = new DataContext()) { dataContext.Entry(orderState).State = EntityState.Modified; orderState.Lines.ForEach(x => dataContext.Entry(x).State = EntityState.Added); dataContext.SaveChanges(); } }