Guest User

Untitled

a guest
May 20th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. if (!sqlDataReader.IsDBNull(n)) value = r.GetString(n);
  2.  
  3. static class DataReaderExtensions
  4. {
  5. public static string GetStringOrNull(this IDataReader reader, int ordinal)
  6. {
  7. return reader.IsDBNull(ordinal) ? null : reader.GetString(ordinal);
  8. }
  9.  
  10. public static string GetStringOrNull(this IDataReader reader, string columnName)
  11. {
  12. return reader.IsDBNull(columnName) ? null : reader.GetString(columnName);
  13. }
  14. }
  15.  
  16. value = reader.GetStringOrNull(n);
  17.  
  18. value = r[n] as string;
Add Comment
Please, Sign In to add comment