title: String or binary data would be truncated.\r\nThe statement has been terminated. c#
body: <p>I am trying to add email to table but it is throwing error the value in email is "prashhanth@oberonit.com". I don't see any anything wrong in the email.I added other emails added fine not this one.</p>
  
  <p>Column RemovedEmail is varchar(50), null</p>
  
  <blockquote>
    <p>"String or binary data would be truncated.<br>The statement has been terminated."</p>
  </blockquote>
  
  <pre><code> var constultantUser = intensifyDb.ConsultantUsers.FirstOrDefault(x =&gt; x.Email == email);
  
    // Delete the item 
    if (constultantUser != null)
    {
       intensifyDb.DeleteObject(constultantUser);// Save changes 
       intensifyDb.SaveChanges();
     }
  
     if (!intensifyDb.RemovedEmails.Any(x =&gt; x.RemovedEmails == email))
     {
        RemovedEmail consultant = new RemovedEmail
        {
            RemovedEmails = email
        };
        intensifyDb.AddToRemovedEmails(consultant);
        intensifyDb.SaveChanges(); // Exception throwing here.
     }
  </code></pre>
  
  <h2>update</h2>
  
  <p>As @Bradley request</p>
  
  <p><a href="https://i.stack.imgur.com/Dwagk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dwagk.png" alt="enter image description here"></a></p>
  
  <p>Full Code</p>
  
  <pre><code>protected void btnAdd_Click(object sender, EventArgs e)
   {
      if (!string.IsNullOrEmpty(txtEmails.Text))
      {
         string txt = txtEmails.Text;
         string[] lst = txt.Split(new Char[] { '\n', '\r' },      
  StringSplitOptions.RemoveEmptyEntries);
         string email = string.Empty;
         var removedEmail = string.Empty;
         using (SqlConnection connection = new SqlConnection(connectionString))
         {
             var foundEmail = string.Empty;
             foreach (string emailStr in lst)
             {
              email = LastCharFromEmailAddress(emailStr).Replace("\r\n", string.Empty);
              var intensifyDb = new IntensifyEntities();
  
              var constultantUser = intensifyDb.ConsultantUsers.FirstOrDefault(x =&gt; x.Email == email);
  
              // Delete the item 
              if (constultantUser != null)
              {
                 intensifyDb.DeleteObject(constultantUser);// Save changes 
                 intensifyDb.SaveChanges();
              }
  
              if (!intensifyDb.RemovedEmails.Any(x =&gt; x.RemovedEmails == email))
              {
                 RemovedEmail consultant = new RemovedEmail
                 {
                    RemovedEmails = email
                 };
                 intensifyDb.AddToRemovedEmails(consultant);
                 intensifyDb.SaveChanges();
               }
           }
      connection.Close();
  
      }
  
                  }
              }
  </code></pre>