Check how to add columns to Select programmatically.

[hmobius]

From Select page.
Select is not cumulative. Calling it a second time in the same command chain with additional columns to include will throw an InvalidOperationException.

Check if columns can be added to Select clause cumulatively across statements. For example

if (this) select (col1);
if (that) select (col2);
etc