Hi Drew.
this is a werid one and I have no idea how to repo it. @Buildstarted did get some code going, but it seemed to work (so no issue) but in my project i got two weird issues.
=> When testing my code while debugging (eg. in an XUnit and stepping through code or just F5 debugging) the Query (from the Dapper-Wrapper) was returning NULL (sometimes).
We all know queries never return null. Empty list - sure, null, nope.
It never seemed to happen when I did a run without debugging. Like .. unit test -> run.
I'm going to have to do more research but this really stumped me for a good few hours today 😢
The wrapper code is very simple - which is why i'm stumped.
It's like .. when i got a result that was going to be an empty result .. I got a NULL.
Swapping my code around so i'm using a normal SqlConnection instead of a Dapper-Wrapper fixed it instantly.
So i don't have my new test(s) working right now.
Anyways - just starting a convo on this. If i get more data, i'll post it in here. Maybe someone else might be getting this issue?