Delegation warning when retrieving information from SQL Server
I am looking to retrieve a value from SQL Server dynamically. The user selects a customer and I retrieve the information from a field in the customer table. When the user changes the customer, I retrieve the information again. My current approach is like this
We are talking about a 1:1 relationship, so for each customer number there is only going to be one row. At the same time I am getting a delegation warning, as well as that the First() function is not supported by this connector. This leads me to believe that the approach for retrieving information from a SQL Server table might not be the best one. What would be best practice in this scenario?