c# - Avoid string concatenation for parameters when they are null

Question

In C# I have query like that:

string query = "SELECT * FROM product WHERE name = @name";
...
da.SelectCommand.Parameters.AddWithValue("@name", name);

if (price.HasValue)
{
    query += " AND price = @price";
    da.SelectCommand.Parameters.AddWithValue("@price", price.Value);
}
..

How to avoid if statements? In above example I have only one parameter but in my code I have several parameters what is mean that I have several if statements

标签： c#sqlparameters

Answer 1

you can do it with SQL query without any IFs , something like :

string query = "SELECT * FROM product WHERE name = @name AND (@price IS NULL OR price = @price)";