title: Get exception when add to database in Linq-to-SQL
body: <p>My database is in SQL Server and I use Linq-to-SQL. I used from SP(Save cards) .
  I put breakpoint in my code, when arrive at <code>rdr = cmm.ExecuteReader();</code> get me exception!!!</p>
  
  <pre><code> private void btnSave_Click(object sender, EventArgs e)
   {
              PersianCalendar jc = new PersianCalendar();
              string SaveDate = jc.GetYear(DateTime.Now).ToString();
              int from=Convert.ToInt32(txt_barcode_f.Text);
              int to=Convert.ToInt32(txt_barcode_t .Text);
              int quantity=Convert.ToInt32(to-from);
              int card_Type_ID=Convert.ToInt32(cmb_BracodeType .SelectedValue);
              int[] arrCardNum = new int[quantity];
  
              arrCardNum[0]=from;
  
               for (int i = from; i &lt; to;i++ )
               {
                   for(int j=0; j&lt;quantity ;j++)
                   {
                   arrCardNum[j]=from+j;
                   int r = arrCardNum[j];
                   sp.SaveCards(r, 2, card_Type_ID, SaveDate, 2);
                   }
               }
          }  
  
  public void SaveCards(int Barcode_Num, int Card_Status_ID, int Card_Type_ID, string Save_Date, int Save_User_ID)
          {
  
                  IDbCommand cmm;
                  cmm = Linq.Connection.CreateCommand();
                  try
                  {           
                      cmm.Parameters.Add(new SqlParameter("@Barcode_Num", Barcode_Num));
                      cmm.Parameters.Add(new SqlParameter("@Card_Status_ID", 2));
                      cmm.Parameters.Add(new SqlParameter("@Card_Type_ID", Card_Type_ID));
                      cmm.Parameters.Add(new SqlParameter("@SaveDate", Save_Date));
                      cmm.Parameters.Add(new SqlParameter("@Save_User_ID", Save_User_ID));
                      cmm.CommandText = "SaveCards";
                      cmm.Connection.Open();
                      cmm.Connection = Linq.Connection;
                      cmm.CommandType = CommandType.StoredProcedure;
                      IDataReader rdr = null;
  
                      **rdr = cmm.ExecuteReader();**
                      while (rdr.Read())
                      {
                          Console.Write(" All Insert ! " + "\n");
                      }
                  }
                  catch (SqlException ex)
                  {
                      SqlExceptionHandler(ex, Save_User_ID);
                  }
                  catch (Exception ex)
                  {
                      PopularEexceptionHandler(ex, Save_User_ID);
                  }
                  finally
                  { cmm.Connection.Close(); }
  
          }
  </code></pre>
  
  <p>when excute sp, show no result and display this:</p>
  
  <pre><code>when execute sp , display this:The INSERT statement conflicted with the CHECK constraint "CK_BarCode_Num". The conflict occurred in database "Parking", table "dbo.TBL_Cards", column 'BarCode_Num'. The statement has been terminated. No rows affected. (0 row(s) returned) @RETURN_VALUE = -6
  </code></pre>