/C#/C# core linq savechanges invalid column name error while adding but not while updating

C# core linq savechanges invalid column name error while adding but not while updating

Just to be clear on this answer, because it was most accurate to my situation 
(but I didnt know it until after I figured my problem out). 
  If you have some error related to OtherTable_ID when you are
  retrieving Table, go to your OtherTable model and make sure 
  you don't have an ICollection<Table> in there. Without a relationship 
  defined, the framework will auto-assume that you must have a
  FK to OtherTable and create these extra properties in the generated SQL.

Source: stackoverflow.com

Similar codes

2 votes138 views3 answers
Asp.net core 3.1 ajax partial view
C#
0 vote125 views2 answers
Get first and last item list c#
C#
0 vote128 views1 answer
How to get properties from json in c#
C#
0 vote118 views1 answer
Cshtml page title
C#
0 vote116 views1 answer
Close an open form when you open it again c#
C#
1 vote125 views1 answer
Gucci gang lyrics
C#
10 votes157 views1 answer
Unity check if key pressed
C#Unity
3 votes131 views1 answer
C# get all class properties
C#
0 vote166 views1 answer
Unity move in x seconds to pos
C#Unity
34 votes131 views2 answers
Instantiate c#
C#