.NET DataTable skips rows on Load(DataReader)
After fiddling around quite a bit I found that the DataTable.Load method expects a primary key column in the underlying data. If you read the documentation carefully, this becomes obvious, although it is not stated very explicitly. If you have a column named “id” it seems to use that (which fixed it for me). Otherwise, … Read more