How to fix "Failed to configure C# code file(s)" error while adding SQL server dependency for Azure function in Visual studio 2022

Question

I have created brand new Azure function project in Visual studio 2022 and trying to add SQL server dependency as a Connected service. However I get this error for both Azure and local SQL database. Visual studio is running in Admin mode

Steps -

1. Right click on Connected services and add SQL server
2. Select SQL server database or Azure SQL Database and click new
3. Give connection name and connection string and select option "Local user secret file"
4. Click finish

Answer 1

@Desai, Pradipkumar Thanks for your patience! The code update is currently broken for isolated functions and our product group team is working on it.

Work-around would be to uncheck the code option while setting up the SQL connected service.

do try and let me know incase of further queries, I would be happy to assist you.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.