MSSQL Crud tables duplicates data

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 ?

Hi @cmhdev,

Does this happen with SQL views only? If yes - it is a known problem. We are currently looking for a way to address that entity framework limitation within Radzen.

Hi @cmhdev,

We’ve just released Radzen 2.6.8 with included fix for duplicate records from SQL view or table without primary key. The new version will be downloaded on next Radzen start.

Best Regards,
Vladimir

1 Like

Great! Thank you very much.