Mithrandyr

@kwein123 -- hrm this suggest that there might be something going on with your environment. a couple of suggestions. Trying running the code from a different computer using PS 7.4.2...

@kwein123 - you can install multiple versions side by side -- the `Install-Module` does this out of the box. however when you use `Import-Module` it will always load the latest...

@kwein123 -- In case, you are interested -- here is how to walk through the code to see what is happening (and why I'm completely baffled by your experience). 1....

@kwein123 - good news, i've been able to reproduce your experience using your sql . however my original attempt to reproduce still isn't giving an issue.. going to keep digging.

OK -- if you create your table without the primary key, you will get back the proper count. ```sql -- Table with Primary Key CREATE TABLE test1 ( SERVER VARCHAR(25),...

I was hoping there was a solution that didn't involve removing the primary key.. no luck -- [I've posted to the github for MySqlConnector](https://github.com/mysql-net/MySqlConnector/discussions/1484) hoping someone has a suggestion. Basically,...

@kwein123 - So I was incorrect, MySqlConnector is not 'optimizing' @bgrainger However, there is something weird with `DataTable.Load(dr)` when the DataReader is referencing a table with a primary key... that...

@kwein123 -- published, closing this issue.

@gitfvb - consider it added to my To-Do list.

@asmith3006 -- If you could post the affected code, then I could offer some insights. You shouldn't open/close every time you want to make a call. (open the connection, do...