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

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:
- shawn.wildermuth.com
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:
- • Instructional Videos

[@CarrigansGuitarClub]

As always, great topic and straight to the point Shawn

[@agentsmith2189]

OMG Ty

[@mmd06aaa]

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

[@nickanagnostopoulos1688]

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.

[@swildermuth]

Happy to help!

[@adamoneil7435]

this is really cool, thank you

[@swildermuth]

Glad you like it!

[@muneebrbaig]

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.

[@eusouodouglas5730]

Hey Shawn, thanks for sharing this knowledge!

[@swildermuth]

You bet!

[@Reellron]

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

[@henrik3098]

another great video Shawn =)

[@alirezakarimi8685]

This is great

[@hyd119]

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.

[@swildermuth]

Can you say more about this? I am not sure I understand.

[@davidpccode]

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?

[@swildermuth]

Yup, the subquery is inefficient. Having the OrderBy after the Where prevents the sub-query.

[@davidpccode]

@@swildermuth thanks Shawn

[@zoheirkaram]

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

[@vivekkaushik9508]

Watching it in 1440p. Probably some youtube issue on a newly added video

[@etexas]

please wait a bit, it takes time and processing power for KZbin to process videos. You're supposed to upload videos way ahead of time with a premiere but I guess something went wrong with this upload. Like clearly the title and the description don't match. Title says "Coding Shorts: Bun.js on WSL - It's Pretty Good" and description says "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!" so I think this is user error.

[@etexas]

1080p is available now. Please refresh.

[@swildermuth]

I uploaded it at 4K I belileve. But it takes a bit

[@zoheirkaram]

@@swildermuth Thank you so much

[@italianvalleys]

how about a "short" on ef caching ? thanks

[@swildermuth]

Do you mean caching inside of EF (e.g. accidently getting stale data), or caching EF data?

[@italianvalleys]

First & Second level caching in EF. Thanks.