title: How to create a Dynamic Parameterized SQL Query String in C#
body: <p>I'm ultimately trying to save a number of records I've stored in a concurrent list within my Function App into a SQL Server database with parameterized values, one of which is an encrypted column (not sure if relevant).</p>
  <p>Currently, I'm iterating over each record and extracting the values, parameterizing them, and saving them to the database; doing this for each record. Though, from what I understand this is highly inefficient and I'm told creating a single string with the parameterized values of each record, then running that single string as a SQL Server query would be more efficient.</p>
  <p>Could someone explain to me how I might achieve something like this or if I'm perhaps mistaken?</p>
  <p>Thank you!</p>