public void AddCategory(Category c)
 {
     using (ECommerceDataContext context = new ECommerceDataContext(_connectionString))
     {
         context.Categories.InsertOnSubmit(c);
         context.SubmitChanges();
     }
 }
 partial void UpdateCategory(Category instance);
 partial void DeleteCategory(Category instance);
 partial void InsertCategory(Category instance);