static IEnumerable<string> GetProductsContainingString(string searched, SqlConnection dbConnection)
{
searched = searched.Replace("%", "[%]");
searched = searched.Replace("_", "[_]");
dbConnection.Open();
using (dbConnection)
{
IList<string> productsContainingString = new List<string>();
SqlCommand productsContainingStringCommand = new SqlCommand(
@"SELECT ProductName FROM Products
WHERE ProductName LIKE @searched",
dbConnection);
productsContainingStringCommand.Parameters.AddWithValue("@searched", string.Format("%{0}%", searched));
SqlDataReader productsInfo = productsContainingStringCommand.ExecuteReader();
using (productsInfo)
{
while (productsInfo.Read())
{
productsContainingString.Add((string)productsInfo["ProductName"]);
}
}
return productsContainingString;
}
}
}