Sql Server Error, Entity Framework Core Error: An unhandled exception occurred while processing the request. SqlException: Invalid column name 'ColumnName'. Invalid column name 'AnotherColumnName'.

Q: Sql Server Error, Entity Framework Core Error: An unhandled exception occurred while processing the request. SqlException: Invalid column name 'ColumnName'. Invalid column name 'AnotherColumnName'.

<div>Question: How do you resolve, An unhandled exception occurred while processing the request.</div> <div>SqlException: Invalid column name 'ColumnName'. Invalid column name 'AnotherColumnName'.</div> Microsoft.Data.SqlClient.SqlCommand+&lt;&gt;c.&lt;ExecuteDbDataReaderAsync&gt;b__164_0(Task&lt;SqlDataReader&gt; result) Answer: 1. The answer could be pretty simple, there is a big chance that you "my friend" has misspelled the name of the Column somewhere in your code. This is when the Developer Instinct has to kick in. Slow down, and double-check the very column name with an error on. That same column name might very much be misspelled. 2. Go to your SQL Server Table where the column with an error is located, in the "Object Explorer" expand the dbo.TableName, then expand the "Column" folder. Again, Double-check if the column was created in the first place (in the table), if indeed the column was created, then check if it is the same as defined in your code.

Question

Sql Server Error, Entity Framework Core Error: An unhandled exception occurred while processing the request. SqlException: Invalid column name &#x27;ColumnName&#x27;. Invalid column name &#x27;AnotherColumnName&#x27;.

Accepted Answer

Question: How do you resolve, An unhandled exception occurred while processing the request.

SqlException: Invalid column name 'ColumnName'.
Invalid column name 'AnotherColumnName'.

Microsoft.Data.SqlClient.SqlCommand+<>c.<ExecuteDbDataReaderAsync>b__164_0(Task<SqlDataReader> result)

Answer:

1. The answer could be pretty simple, there is a big chance that you "my friend" has misspelled the name of the Column somewhere in your code. This is when the Developer Instinct has to kick in. Slow down, and double-check the very column name with an error on. That same column name might very much be misspelled.

2. Go to your SQL Server Table where the column with an error is located, in the "Object Explorer" expand the dbo.TableName, then expand the "Column" folder. Again, Double-check if the column was created in the first place (in the table), if indeed the column was created, then check if it is the same as defined in your code.

Sql Server Error, Entity Framework Core Error: An unhandled exception occurred while processing the request. SqlException: Invalid column name 'ColumnName'. Invalid column name 'AnotherColumnName'.

Invalid column name '*_ID'

Invalid column name '*_ID'

ExecuteDataReader Error: An error occured while at

ExecuteDataReader Error: An error occured while attempting to process your query Incorrect syntax near 'SomeValue'

The INSERT statement conflicted with the FOREIGN K

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tableName_key". The conflict occurred in database "Database Name", table "dbo.tableName", column 'id'

InvalidOperationException: The required column 'Ca

InvalidOperationException: The required column 'Categoryid' was not present in the results of a 'FromSql' operation

SqlException: Cannot insert the value NULL into co

SqlException: Cannot insert the value NULL into column 'Id', table 'dbo.TableName'; column does not allow nulls. INSERT fails. The statement has been terminated

InvalidOperationException: Incorrect Content-Type

InvalidOperationException: Incorrect Content-Type

An unhandled exception has occurred while executin

An unhandled exception has occurred while executing the request. System.ArgumentNullException: Value cannot be null. (Parameter 'buffer')

An unhandled exception occurred while processing t

An unhandled exception occurred while processing the request: FormatException: The header contains invalid values at index 0

An unhandled exception occurred while processing t

An unhandled exception occurred while processing the request "The view 'ViewName' was not found. The following locations were searched"

What is New in Entity Framework 5 Shipped in Asp.N

What is New in Entity Framework 5 Shipped in Asp.Net 5

[Entity Framework Core 5] An Unhandled Exception O

[Entity Framework Core 5] An Unhandled Exception Occurred While Processing the Request

Solved!! Column 'Employee.ID' is invalid in the se

Solved!! Column 'Employee.ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause

Can not connect to SQL server in docker container

Can not connect to SQL server in docker container from another docker container hosting asp.net core 3.0 application

Entity Framework Core Error: To change the IDENTIT

Entity Framework Core Error: To change the IDENTITY property of a column, the column needs to be dropped and recreated