What is the fastest code to call multiple stored procedures?

Question

Solution 1:

foreach (var item in itemList)
{
   myContext.ExecuteStoreCommand("EXEC MyProc {0};", item); // Insertion
}

or

Solution 2:

StringBuilder sb = new StringBuilder();
foreach (var item in itemList)
{
   sb.AppendLine(String.Format("EXEC MyProc {0};", item)); // Insertion
}
myContext.ExecuteStoreCommand(sb.ToString());

Answer 1

The second is faster (one database call instead of several), at first it is safer, since it protects against SQL injection.

Answer 2

both are , the second is under sql injection , that's for sure

after reading this and this , I agree with kekekela

Answer 3

2 , myContext.ExecuteStoreCommand, context

Answer 4

2, -. - , , , System.Diagnostics.Stopwatch.

Answer 5

, .

, .

Answer 6

, .

SqlCommand CommandText, CommandType, CommandType.StoredProcedure, .

In addition to increasing the performance of using a special query (which will need to be re-paralleled each time), you will also address most of your current SQL injection problems at the bud.