Using Stored Procedures with Entity Framework 6 CORRECTLY In .Net 6
Tired of slow EF Core performance?
Well ZZZ Projects has fixed that, their EF Core Extension supercharges your data operations: Bulk Insert, Update, Delete, and Merge are up to 14x faster, cutting save time by an incredible 94%.
👉 Try Entity Framework Extensions Here: https://entityframework-extensions.net
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: https://learn.microsoft.com/en-us/ef/...
Support Me On Patreon: / israelquiroz
Follow Me On TikTok: https://www.tiktok.com/@israelquiroz9...
All My Links Here: https://linktr.ee/israelquiroz
#StoredProcedureswithEntityFramework6 #storedprocedure #StoredProceduresDotnet6
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