Generic Insert and Update for LINQ To SQL

   1: /// <summary>

   2: /// Updates the database with item.

   3: /// </summary>

   4: /// <typeparam name="T">Type of the item</typeparam>

   5: /// <param name="item">The item.</param>

   6: public static void UpdateDatabaseWithItem<T>(T item) where T : class

   7: {

   8:     var store = GetNewDataContext();

   9:     var table = store.GetTable<T>();

  10:     table.Attach(item);

  11:     store.Refresh(RefreshMode.KeepCurrentValues, item);

  12:     store.SubmitChanges();

  13: }

  14:  

  15:  

  16: /// <summary>

  17: /// Inserts the item into database.

  18: /// </summary>

  19: /// <typeparam name="T">Type of the item</typeparam>

  20: /// <param name="item">The item.</param>

  21: public static void InsertItemIntoDatabase<T>(T item) where T : class

  22: {

  23:     var store = GetNewDataContext();

  24:     var table = store.GetTable<T>();

  25:     table.InsertOnSubmit(item);

  26:     store.SubmitChanges();

  27: }