public void UpdateUser(User pUser)
 {
     using (TransactionScope lScope = new TransactionScope())
         using (VideoStoreEntityModelContainer lContainer = new VideoStoreEntityModelContainer())
         {
             lContainer.Entry(pUser).State = EntityState.Modified;
             lContainer.SaveChanges();
             lScope.Complete();
         }
 }