C# example of reading a (single) result-set of data returned by executing a (T-)SQL command

.NET SQL reader example.cs

public AccessTokenInfo GetWebApiAccessToken(string webApiUserName)
{
    object tokenObject = null;
    object expirationObject = null;

    string tokenString;
    DateTime? expirationDateTime;

    using (SqlConnection dbConnection = new SqlConnection(_connectionString))
    using (SqlCommand dbCommand = new SqlCommand("dynamics.GetWebApiAccessToken"))
    {
        dbCommand.Connection = dbConnection;
        dbCommand.CommandType = CommandType.StoredProcedure;
        dbCommand.Parameters.AddWithValue("@WebApiUserName", webApiUserName);

        dbConnection.Open();

        using (SqlDataReader reader = dbCommand.ExecuteReader())
        {
            // Read only the first row (if it exists)
            if (reader.Read())
            {
                tokenObject = reader["DecryptedToken"];
                expirationObject = reader["ExpiresOnUtc"];
            }
        }

        dbConnection.Close();
    }

    tokenString = (tokenObject == DBNull.Value) ? (string)null : (string)tokenObject;
    expirationDateTime = (expirationObject == DBNull.Value) ? (DateTime?)null : (DateTime?)expirationObject;

    return new AccessTokenInfo(tokenString, expirationDateTime);
}