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
Смотрите видео Using Stored Procedures with Entity Framework 6 CORRECTLY In .Net 6 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Israel Quiroz 01 Январь 1970, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 16,683 раз и оно понравилось 251 людям.