DB or Database First Approach in Entity Framework Core to Call Stored Procedure in Asp.Net Core 5.0

preview_player
Показать описание
Hello guys, in this video I have demonstrated that how we can call a stored procedure in Asp.Net Core 5.0 and 3.1.

If you are watching this video directly then you must need to watch part 1 of this Database first approach. Please find the link below:

Google Drive URL:

Go to this link to take the test to identify yourself.

Laptop Used for Creating the Video:

Mic used for creating the video:

Go to the below link to subscribe to our channel:
Рекомендации по теме
Комментарии
Автор

Hi, I get an invalid object name error for my SP when I see context.classobj(SP). I followed the same steps. Please help.

deepthitummanapally
Автор

The problem with my code is I am using one sp which takes type as input and return master data as Output .On page load 9 master data need to be called so I made a common proc which take type a input and return data.Now issue is it is merging the data wit the previous one.
Eg. 1st master data=>(input :'yesno' output:[yes, no])
2nd master data=>(input: 'hospital', 'output':[yes,no,fortis,hospital1
why its is replacing 1st 2 hospital with yes, no

ashishpant
Автор

Hi, i have a error The entity type 'my_sp' requires a primary key to be defined. If you intended to use a keyless entity type, call 'HasNoKey' in 'OnModelCreating'", and I do what is indicated in the video.

FragoMadara
Автор

Could you please explain how can we do this using scaffolding

inayatnadaf
Автор

Thanks broo for your guidline, but i have a problem here, when I scaffoled dbset<Entity> it's removed

homayunkabir