sql Invalid column in core web api

Sushant Torankar

hello,

I am using asp.net core web api and entity framework core.

I have two tables LogsMaster with columns Id, title, Description and PermissionMaster with columns Id, LogId and ContactId

When Log details is saved in LogsMaster, along with it I am saving LogId(Primary Id column of LogsMaster) and ContactId in PermissionMaster table. So one LogId can have multiple ContactId in PermissionMaster table.

Using following property in LogsMaster table to save ContactId List
public IEnumerable Contacts { get; set; }

In GET request of Contact api, I am getting 500 error code and error is :

Exception: Invalid column name 'LogsMasterId'

I don't have 'LogsMasterId' column in my project or in database, so I am not sure from where that colmumn is coming from ?

Maybe because of One-to-many table relation, I am not using Primary-foreign key relationship to any table

plz help me with this ?

thank you

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sushant Torankar4y ago
thank you for you reply Sachin
somehow i got to fix it by adding ForeignKey and PrimaryKey to tables accordingly
I'll try to use code first approach.
Sachin Singh4y ago
Ok, then check the generated DbSet.
Open the DbContext class and double click on LogsMasters DbSet and press f12 to navigate to the dbset class.
There check all the properties.
remove any unwanted property.

also,
Note EF Core doesn't support or atleast encourage DB First approach, the thing you are doing is called as reverse engineering.
The scaffold thing generate DbContext and DbSets so that now onwards you can use Code-first approach.

Otherwise you will always have to use force switch to generate entities from DB if you modify anything in DB.
Sushant Torankar4y ago
thank you for you reply Sachin

I am using DataBaseFirst Appproach , with follo command :

Scaffold-DbContext "Data Source=.;Initial Catalog=users;User ID=test;Password=test" Microsoft.EntityFrameworkCore.SqlServer -OutputDir DatabaseEntity -Force
Sachin Singh4y ago
Open the last migration you have inside the migration folder generated by EF Core.
Inside that check the UP() method.
Delete the LogsMasterId property.
and run below command
update-database -migration yourMigrationName