public bool IllustrationDelete(Illustration illustration)
        {
            return Execute<bool>(dal =>
            {
                Illustration illustrationDelete = dal.Illustration.Where(x => x.IllustrationID == illustration.IllustrationID).FirstOrDefault();
                if (illustrationDelete != null)
                {
                    dal.Illustration.DeleteOnSubmit(illustrationDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool IllustrationUpdate(Illustration illustration)
        {
            return Execute<bool>(dal =>
               {
               Illustration illustrationUpdate = dal.Illustration.Where(x => x.IllustrationID == illustration.IllustrationID).FirstOrDefault();
               if (illustrationUpdate != null)
               {
                   illustrationUpdate.IllustrationID = illustration.IllustrationID;
                   illustrationUpdate.Diagram = illustration.Diagram;
                   illustrationUpdate.ModifiedDate = illustration.ModifiedDate;
                   dal.SubmitChanges();
                   return true;
               }
               return false;

               });
        }
 partial void DeleteIllustration(Illustration instance);
 partial void UpdateIllustration(Illustration instance);
 partial void InsertIllustration(Illustration instance);
 public void IllustrationUpdate(Illustration illustration)
 {
     adventureWorks_BC.IllustrationUpdate(illustration);
 }
 public void IllustrationAdd(Illustration illustration)
 {
     adventureWorks_BC.IllustrationAdd(illustration);
 }