Amazing video, I am kinda scared of using EF core , i hear its a noob trap even though its an amazing tool. Its easy to use when it works but when it breaks or slows down hard to fix. I hope you continue to make in-depth EF core vids so that the people have more control over what EF core dose and doesn't auto generate someone straight to debug hell. Thx again @ kudvenkat i am gonna go and make some stored procedures now :D
what if my store procedure contains joins? In this video, we are executing stores procedure inside Employees Table. How we will execute a store procedure which is fetching data from two joined tables?
Very nice. Did something rather similar. When you have a sp for a join query then I make another model class that represents this join. So, I actually end up with a lot of model classes just to match the results of the stored procedure. So far didn't know a better way. Any suggestions?
Worth noting, that it's better to select P type object from sysobjects with the procedure name to avoid conflicts if for some reason you create procedure with database-first approach and forgot to drop it to make the migration actually drop it when already exists. IF (OBJECT_ID('spGetEmployeeById', 'P') IS NOT NULL) DROP PROCEDURE spGetEmployeeById GO
your tutorials are amazing always. but in ur video..i dint found what i want... i thought i would get a good explanation about CRUD Operations using Stored Procedure in Sql Server. ASP.Net Core Web Api Without Entity Framework but Using 3 layered Architecture .(without Presentation Layer) Applies Dependency Injection. Thank You!
Why did you create a procedure while you can access the same result easily with the help of EF core Can you show the same thing with multiple table columns selection???
Thank You sir. Would you please give me an example dbfirst approach and is there any code in how we can make only a method for calling all the store procedure with various types of parameters.
Why does EF core require you to use context.Employees? If you had 2nd table, say Customers, could you use context.Customers.FromSqlRaw("spGetEmployeeById {}", id) instead of context.Employees.FromSqlRaw("spGetEmployeeById {}", id)? It seems to me that the stored procedure is independent of the table name. In this case, I see it's related but how would EF core know this ?
My tutors told two things which are not matching with this video:- First : Stored Procs can't do SELECT operations Second: In EF Core,we use ExecuteSqlRaw to implement stored proc
That's insane how SPs are called in code first, we have to hard code its name and remember parameter positions which is error prone. I am big fan of how sps are called as methods with intellisence support in database approaches. Hate few things of Microsoft the way they do those.
Amazing video, I am kinda scared of using EF core , i hear its a noob trap even though its an amazing tool. Its easy to use when it works but when it breaks or slows down hard to fix. I hope you continue to make in-depth EF core vids so that the people have more control over what EF core dose and doesn't auto generate someone straight to debug hell. Thx again @
kudvenkat i am gonna go and make some stored procedures now :D
I'm so happy. In my work we only use stored procedures. Thank you very much Venkat . 👍👍👍👍👍
You make everything simple and to the point.Thank you.
what if my store procedure contains joins? In this video, we are executing stores procedure inside Employees Table. How we will execute a store procedure which is fetching data from two joined tables?
Recently i had a issue of multiple result set i found simple ado.net with some extension method solves the problem.
Very nice. Did something rather similar. When you have a sp for a join query then I make another model class that represents this join. So, I actually end up with a lot of model classes just to match the results of the stored procedure. So far didn't know a better way. Any suggestions?
what if I have a pretty much expensive sp query? I should set it to a string variable as well?
Just Perect ! 👍👍
Helpful, thanks..
Worth noting, that it's better to select P type object from sysobjects with the procedure name to avoid conflicts if for some reason you create procedure with database-first approach and forgot to drop it to make the migration actually drop it when already exists.
IF (OBJECT_ID('spGetEmployeeById', 'P') IS NOT NULL)
DROP PROCEDURE spGetEmployeeById
GO
your tutorials are amazing always.
but in ur video..i dint found what i want... i thought i would get a good explanation about CRUD Operations using Stored Procedure in Sql Server. ASP.Net Core Web Api Without Entity Framework but Using 3 layered Architecture .(without Presentation Layer) Applies Dependency Injection.
Thank You!
What if you already have an existing stored procedure in the database. Do you still need to migrate it and go through the whole thing?
Thank youu so much for this video!!
Thanks Venkat!!
Why did you create a procedure while you can access the same result easily with the help of EF core
Can you show the same thing with multiple table columns selection???
Thanks Venkat. 👍👍👍👍👍
Thank You sir. Would you please give me an example dbfirst approach and is there any code in how we can make only a method for calling all the store procedure with various types of parameters.
Why does EF core require you to use context.Employees? If you had 2nd table, say Customers, could you use context.Customers.FromSqlRaw("spGetEmployeeById {}", id) instead of context.Employees.FromSqlRaw("spGetEmployeeById {}", id)?
It seems to me that the stored procedure is independent of the table name. In this case, I see it's related but how would EF core know this ?
Hello sir, I am struggling a bit about how to use crud stored procedure in entity framework core for legacy applications (database first approch).
My tutors told two things which are not matching with this video:-
First : Stored Procs can't do SELECT operations
Second: In EF Core,we use ExecuteSqlRaw to implement stored proc
HI, how to return multiple result set from stored procedures with entity framework core
Thank you Sir.I am having error while executing stored procedure with output parameters in oracle database. please give me some solution sir.
Is it possible to makevideo on postgres server and make calls to stored procedures with code first approach
Thanks Sir....
Great tutorial as always!
That's insane how SPs are called in code first, we have to hard code its name and remember parameter positions which is error prone. I am big fan of how sps are called as methods with intellisence support in database approaches. Hate few things of Microsoft the way they do those.
Thumbs down for forced ad watching.