Using Stored Procedures with Entity Framework 6 CORRECTLY In .Net 6
Stored Procedures with Entity Framework 6
Stored Procedures are a powerful way of querying databases in sql. It allows you to offload a lot to be handled by only the database as well as allowing you to have a piece of reusable sql code. So naturally being able to harness Stored procedures in a dotnet application would be nice to have, enter Entity Framework 6. It allows you multiple ways to call a Stored Procedure so I want to go over if Stored Procedures are better than using LINQ queries. Also, what are the limitations of EF6, or what would be easier done with another way of querying or using another library to call the stored procedures.
Microsoft Documentation:
Support Me On Patreon:
Follow Me On TikTok:
All My Links Here:
TimeStamps
----------------------------
00:00 Intro
00:44 What Are Stored Procedures?
01:08 Why Use Stored Procedures Instead Of LINQ?
01:41 Limitations Of Entity Framework 6 When Using SQL Strings
03:50 Introducing The API We Are Using
04:23 Introducing The Database We Will Be Using
04:57 Creating The Repository Pattern For Calling The Stored Procedures
08:21 GetPlayer Stored Procedure Call Using EF6
13:18 GetPlayerList Stored Procedure Call Using EF6
14:37 CreatePlayer Stored Procedure Call Using EF6
17:53 UpdatePlayer Stored Procedure Call Using EF6
20:11 The BIGGEST ISSUE I Have With EF6 Calling Stored Procedures
Watch video Using Stored Procedures with Entity Framework 6 CORRECTLY In .Net 6 online without registration, duration 22 minute 30 second in high hd quality. This video was added by user Israel Quiroz 24 September 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 16 thousand once and liked it 233 people.