code_junkie

Is there a bug in SqlDataReader.HasRows when running against SQL Server 2008

Nov 13th, 2011
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. -- #1
  2. SELECT * FROM my_table
  3. WHERE CONTAINS(my_column, 'monkey')
  4.  
  5. -- #2
  6. SELECT * FROM my_table
  7. WHERE CONTAINS(my_column, 'a OR monkey') -- "a" is a noise word
  8.  
  9. using (SqlConnection conn = new SqlConnection(...))
  10. {
  11. SqlCommand cmd = conn.CreateCommand();
  12. // setup the command object...
  13.  
  14. conn.Open();
  15. using (SqlDataReader dr = cmd.ExecuteReader())
  16. {
  17. if (dr.HasRows)
  18. {
  19. // get column ordinals etc...
  20.  
  21. while (dr.Read())
  22. {
  23. // do something useful...
  24. }
  25. }
  26. }
  27. }
  28.  
  29. bool readerHasRows=false;
  30. while(reader.reader())
  31. {
  32. readerHasRows=true;
  33. doStuffOverAndOver();
  34. }
  35. if (!readerHasRows)
  36. {
  37. probablyBetterShowAnErrorMessageThen();
  38. }
  39.  
  40. using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.SingleResult))
Add Comment
Please, Sign In to add comment