I have this array:
And I need to make from array above string,one string like this:
(export_sdf_id=3746) OR (export_sdf_id=3806) OR (export_sdf_id=23) OR (export_sdf_id=6458) OR (export_sdf_id=3740) OR (export_sdf_id=3739) OR (export_sdf_id=3742)
Any idea what is the elegant way to implement it?
There is the String.Join-method designed for this.
var mystring = String.Join(" OR ", idsArr);
This will result in the following string:
export_sdf_id=3746 OR export_sdf_id=3806 OR export_sdf_id=23 OR export_sdf_id=6458 OR export_sdf_id=3740 OR export_sdf_id=3739 OR export_sdf_id=3742
Note that the brackets are omited as they are not needed for your query.
You can use String.Join(String, String[]), where first parameter is separator between array elements.
string result = String.Join(" OR ", sArr);
string result = String.Join(" OR ", idsArr.Select(x => '(' + x + ')'));