CSV_To_Table

Create Function dbo.fn_ConvertCSVtoTable ( @input nvarchar(max), @token nchar(1))

Returns  @Result Table
(ColumnValue nvarchar(max))
As
Begin
 
      Declare @x XML

      Select @x = CAST('<CSV>'+ REPLACE(@input, @token,'</CSV><CSV>')+ '</CSV>' AS XML)
     
      Insert Into @Result            
      Select t.value('.', 'nvarchar(max)') AS ColumnValue
      From @x.nodes('/CSV') AS x(t)
 

    Return
End
Go

Create Table #Numbers
(
Numbers nvarchar(max)
)

Insert Into #Numbers
Values ('one'),('two'),('three'),('four'),('five'),('six'),('seven'),('eight'),('nine'),('ten')

Declare @FindMe nvarchar(max)

Set @FindMe = 'one,five,seven,nine'


Select  n.*
From	#Numbers n
Join dbo.fn_ConvertCSVtoTable(@FindMe, ',') csv on n.Numbers = csv.ColumnValue

Drop Table #Numbers
Drop Function dbo.fn_ConvertCSVtoTable

gistfile1.txt

http://www.codeproject.com/Articles/39161/C-and-Table-Value-Parameters

gistfile2.txt

using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnString"].ConnectionString))
{
    var parameters = model.Keywords.Select((keyword, index) => new { Name = "@P" + index, Value = keyword });
    var sql = String.Format("SELECT * FROM Table WHERE Id IN ({0})", String.Join(",", parameters.Select(x => x.Name)));
    connection.Open();
 
    using (var command = new SqlCommand(sql))
    {
        foreach (var p in parameters)
        {
            command.Parameters.Add(p.Name, SqlDbType.NVarChar).Value = p.Value;
        }
 
        using (var reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
 
            }
        }
    }
}