Coding Shorts: Entity Framework Core 8: Improve Your Query Performance with SQL

preview_player
Показать описание
You can improve the performance of your Entity Framework Core queries by crafting custom SQL for your queries. This is great when you need to tweak bottlenecks of performance for complex logic. Let's see how it works!

You can hire me too! You can reach me at my new website:

00:00 Introduction
01:26 Querying with EF8
04:37 Creating a Model
05:47 Returning the Model
06:34 Using Custom SQL
07:10 Using Parameters in SQL
08:40 New SqlQuery Method
09:39 Extening SQL with Linq
11:32 Wrapping Up

If you like this video, you might like other videos in my Instructional Videos:
Рекомендации по теме
Комментарии
Автор

Thank you Shawn, I was looking for a way to run raw sql queries within ef for sometime. Your video just cleared it out :)

mmdaaa
Автор

Whenever I am stuck on something and have to look it up, your name pops up more than the rest. Thank you for your videos and code. This video was exactly what I needed.

nickanagnostopoulos
Автор

As always, great topic and straight to the point Shawn

CarrigansGuitarClub
Автор

OMG Ty <3!! Greating from Venezuela

agentsmith
Автор

Thank you very much... a lovely video as always and the way you explained this.
We've been using other implementations of SQL Raw Queries in earlier version and this addition to v8 will definitely be helpful.
Thanks once again.

muneebrbaig
Автор

Hey Shawn, thanks for sharing this knowledge!

eusouodouglas
Автор

Great content Shaw tks. Just a question. The query you got after place thw .Where().OrderBy() looks kind of inneficient due the subquery return all rows (first) then they are filter by the parent select. Is this a good practice?

davidpccode
Автор

Would be a longer video but I'd like to see a comparison of execution plans or so.

Reellron
Автор

Hi Shawn great video. I have a request for a video on the topic of debugging and reverse-engineering relatively simple code bases like for example something using MVC in Visual Studio 2022.

hyd
Автор

Hi, the video is only uploaded with 360p resolution.

zoheirkaram
Автор

how about a "short" on ef caching ? thanks

italianvalleys
join shbcf.ru