/// <summary> /// Inserts an expense row. /// </summary> /// <param name="expense">An Expense object.</param> public void Create(ExpenseReview review) { using (ExpenseDataContext ctx = new ExpenseDataContext()) { ctx.AddObject(ENTITY_SET_NAME, review); ctx.SaveChanges(); } }
/// <summary> /// Inserts an expense row. /// </summary> /// <param name="expense">An Expense object.</param> public Expense Create(Expense expense) { using (ExpenseDataContext ctx = new ExpenseDataContext()) { ctx.Expenses.AddObject(expense); ctx.SaveChanges(); } return expense; }
public void Purge() { using (ExpenseDataContext ctx = new ExpenseDataContext()) { List<Expense> resultList = (from expense in ctx.Expenses select expense).ToList(); foreach (Expense expense in resultList) { ctx.DeleteObject(expense); } ctx.SaveChanges(); } }
/// <summary> /// Updates an Expense row. /// </summary> /// <param name="expense">A Expense object.</param> public void Update(Expense expense) { EntityKey key = null; object original = null; using (ExpenseDataContext ctx = new ExpenseDataContext()) { key = ctx.CreateEntityKey(ENTITY_SET_NAME, expense); if (ctx.TryGetObjectByKey(key, out original)) { ctx.ApplyCurrentValues(key.EntitySetName, expense); } ctx.SaveChanges(); } }