CODEWITHSUNDEEP
stringjoinc#-4.0dynamic-arrays
Haim Evgi
Haim Evgi

Reputation: 125496

c# help with building where clause to query

i am newbie in c#,

i want to build query string , i do some conditions , every condition add another condition to where clause

i want something like that :

    // BUILD SELECT QUERY
     string where = "";
     string[] where_arr = new string[];
     if (condition1)
     {
           where_arr[index++] = " field = 5 ";
     }
      if (condition2)
     {
           where_arr[index++] = " field2 = 7 ";
     }

     if (where_arr.Count>0)
        where = " where" +  String.Join(" and ", where_arr);
     string sql = "select count(*) as count from mytable " + where;

but i do not know exactly how to declare all the variables like where_arr

Upvotes: 0

Views: 434

Answers (1)

cdhowie
cdhowie

Reputation: 169018

// BUILD SELECT QUERY
string where = "";
List<string> where_arr = new List<string>();

if (condition1)
{
    where_arr.Add(" field = 5 ");
}

if (condition2)
{
    where_arr.Add(" field2 = 7 ");
}

if (where_arr.Count > 0)
    where = " where" + String.Join(" and ", where_arr.ToArray());
string sql = "select count(*) as count from mytable " + where;

Upvotes: 1

Related Questions