foreach (var item in BranchContactList)
{
var varInsertBranchContactResult = db.Database.ExecuteSqlCommand("TempspInsertBranchContact @BranchID,@FirstName,@LastName,@Designation,@Department,@PhoneNo1,@PhoneNo2,@MobileNo1,@MobileNo1,@EmailAddress1,@EmailAddress2,@CreatedBy,@CreatedUser,@BranchContactIDOut OUT",
new SqlParameter("BranchID", BranchID),
new SqlParameter("FirstName", item.FirstName.ToString()),
new SqlParameter("LastName", item.LastName.ToString()),
new SqlParameter("Designation", item.Designation.ToString()),
new SqlParameter("Department", item.Department.ToString()),
new SqlParameter("PhoneNo1", item.PhoneNo1.ToString()),
new SqlParameter("PhoneNo2", item.PhoneNo2.ToString()),
new SqlParameter("MobileNo1", item.MobileNo1.ToString()),
new SqlParameter("MobileNo2", item.MobileNo2.ToString()),
new SqlParameter("EmailAddress1", item.EmailAddress1.ToString()),
new SqlParameter("EmailAddress2", item.EmailAddress2.ToString()),
new SqlParameter("CreatedBy", UserID),
new SqlParameter("CreatedUser", User), outParamBranchContactID).ToString().ToList();
var BranchContactID = (int)outParamBranchContactID.Value;
}
How to solve this problem in this particular scenario.
I know cmd.Parameters.Clear() is an option but i cant use it in this scenario.
Note : foreach runs for 3 times. Once successfully. For 2nd time it throws an error :
Error: The SqlParameter is already contained by another SqlParameterCollection
.
.