Using the MSSQL inferr Option for the datasource with .net core 2 and c# I am getting odd
results. specifically duplicating data for each page. I used postman to connect to the
service and it does return duplicates, if I change the $top from to 100 it will return 100
copies of the first row. if I click on the paging to go to page 2 I will get 10 copies of the next record.
I tried creating a blank page and created a service inferred from the MSSQl and it will just
hang.
Could I be missing something in my MSSQL setup ?