Hi. We found a very strange performance issue with Int nullable foreign key. We use Azure SQL database.
The main problem: when we try to assign any value to the nullable foreign key - Telerik DataAccess executes strange SQL queries. In full solution it takes 10-50 seconds, in test console app without any load - it takes ~7 seconds.
1. Why does Telerik execute SQL queries on set operation?
2. Why is it so slow? We tried to assign data using loaded object instead of id - same issue.
I am attaching the DotTrace stacktrace.