SQL to Lambda Conversion Troubleshooting C#, EFCore

I'm experiencing issues after converting my SQL Server Stored Procedure to a Lambda method. The conversion appears to be producing incorrect data in some instances. I need an experienced SQL Server professional who can: - Debug the converted Lambda method to identify the source of the incorrect data. - Ensure the method is providing the correct data in all cases. - Help me understand what went wrong in the conversion process. Ideal candidates should have: - Extensive experience with SQL Server and Lambda methods. - A strong understanding of debugging and data verification. - Excellent problem-solving skills and attention to detail. C# and EFCORE pro efficiency needed.