Comments by Belial09 (Top 2 by date)

Yes I know the names of the custom columns.
We build add-ons to an existing software which has a function to add userdefined columns to the default SQL tables.

For Example:
The user has products in the programm with 4 columns, the ones without „USER_“ are default columns of the table (known columns):

- Price (default)
- Productnumber (default)
- USER_EAN (userdefined)
- USER_Pictureurl (userdefined)

At the moment we give them properties where they can add the custom field names, so we can query them in an SQLDataReaderusing an SQL-Query string.

Summary:
- The tablename is known at design time
- The default table columns are known at design time
- The userdefined columns are only known at runtime