asp.net Mvc API

Question

I have two tables ,  1. News 2. Shop   And I have creating three API's 1. GetNews 2. PostNews 3. DeleteNews   Now, I want to insert the data by using PostNews API. But there is a problem in News Table that Shop Table contain PK(id) which is FK in News Table, so how can i insert the data in News Table, require code snippet for API....

Bhuvanesh Mohankumar · Accepted Answer

Hope you are using the Entity Framework,

you have to have valid row of data in [Shop] before inserting any data reference to [News] table.

1) Update both the table context and save the dbcontext changes.

or

2) Make an hard code of (FK) value in [News] table as the available ID of [Shop] table.

Dr.Ajay Kashyap · Answer

thanks Bhuvanesh Mohankumar  and Vincent Maverick Durano

Vincent Maverick Durano · Answer

The logic is pretty much simple. Since your news table requires an ID from your shop table then you need to get the ID from your shop table first and then use that ID to pass in your PostNews method. You can then insert that ID along with the news info.