Skip to content

Instantly share code, notes, and snippets.

@jchannon
Created September 12, 2013 12:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save jchannon/6536653 to your computer and use it in GitHub Desktop.
Save jchannon/6536653 to your computer and use it in GitHub Desktop.
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnString"].ConnectionString))
{
connection.Open();
using (var command = new SqlCommand("SELECT * FROM Table WHERE Id IN ("))
{
int count = 0;
foreach (var keyword in model.Keywords)
{
command.Parameters.Add("@P" + count, SqlDbType.NVarChar).Value = keyword;
command.CommandText += ("@P" + count);
count++;
}
command.CommandText += ")";
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment