public void AddCategory(Category category)
 {
     using(var context = new ECommerceDbDataContext(_conStr))
     {
         context.Categories.InsertOnSubmit(category);
         context.SubmitChanges();
     }
 }
 partial void DeleteCategory(Category instance);
 partial void UpdateCategory(Category instance);
 partial void InsertCategory(Category instance);