sql Invalid column in core web api

Question

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<ContactsMaster> 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

Sachin Singh · Answer

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.

Sachin Singh · Answer

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

Sushant Torankar · Answer

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.

Sushant Torankar · Answer

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

sql Invalid column in core web api

Bahar Jalali

Hemant Kumar