How do I check to see if a column exists in a SqlDataReader object? In my data access layer, I have create a method that builds the same object for multiple stored procedures calls. One of the stored procedures has an additional column that is not used by the other stored procedures. I want to … Read more
After connecting to the database, can I get the name of all the columns that were returned in my SqlDataReader? 10 Answers 10
I’m using a SQLdatareader to build POCOs from a database. The code works except when it encounters a null value in the database. For example, if the FirstName column in the database contains a null value, an exception is thrown. employee.FirstName = sqlreader.GetString(indexFirstName); What is the best way to handle null values in this situation? … Read more
