Invalid column name in Visual Studio 2023 .cshtml file

Daniel 20 Reputation points
2023-10-30T22:35:42.2866667+00:00

been working on a file to help my sister and I have been stumped by this error which is stopping my code from running, all code is correct to my knowledge. The top image is the Razer code (SQL), and the bottom image is the table where i am trying to display the error

User's image

User's image

Azure SQL Database
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,821 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions
0 comments No comments
{count} votes

Accepted answer
  1. Bruce (SqlWork.com) 60,361 Reputation points
    2023-10-30T22:46:10.8633333+00:00

    the select sql statement does not include the column regionName, only systemId and systemName


0 additional answers

Sort by: Most helpful