How to get number of rows using SqlDataReader in C#

by

There are only two options:

  • Find out by reading all rows (and then you might as well store them)

  • run a specialized SELECT COUNT(*) query beforehand.

Going twice through the DataReader loop is really expensive, you would have to re-execute the query.

And (thanks to Pete OHanlon) the second option is only concurrency-safe when you use a transaction with a Snapshot isolation level.

Since you want to end up storing all rows in memory anyway the only sensible option is to read all rows in a flexible storage (List<> or DataTable) and then copy the data to any format you want. The in-memory operation will always be much more efficient.

More Related Contents:

  1. SQL Data Reader – handling Null column values
  2. Read data from SqlDataReader
  3. Check for column name in a SqlDataReader object
  4. Invalid attempt to read when no data is present
  5. Can you get the column names from a SqlDataReader?
  6. convert from SqlDataReader to JSON
  7. Multiples Table in DataReader
  8. How to get nullable DateTime out of the database
  9. What ‘length’ parameter should I pass to SqlDataReader.GetBytes()
  10. how to write every element of an array in a line of a textbox C# [closed]
  11. Why .NET String is immutable? [duplicate]
  12. Can attributes be added dynamically in C#?
  13. Array slices in C#
  14. How to ignore JsonProperty(PropertyName = “someName”) when serializing json?
  15. Read SQL Table into C# DataTable
  16. How to get an HtmlElement value inside Frames/IFrames?
  17. How can I protect my .NET assemblies from decompilation?
  18. FileNotFoundException in ApplicationSettingsBase
  19. How do I iterate over the properties of an anonymous object in C#?
  20. Disposing of Microsoft.Office.Interop.Word.Application
  21. Calling ASMX from jQuery
  22. How to write a ViewModelBase in MVVM
  23. How to add the same column to all entities in EF Core?
  24. Using Statement with Generics: using ISet = System.Collections.Generic.ISet
  25. Canadian postal code validation
  26. .NET: Get all Outlook calendar items
  27. Create custom shape for button
  28. Convert Date from Persian to Gregorian
  29. DataGridView bound to BindingList does not refresh when value changed
  30. Xamarin Android Finalizer not getting called when leaving the activity to go to another Activity

Leave a Comment