Performance Tips [5 of 5] | Entity Framework Core for Beginners

Need a little performance boost in your EF Core app? Let us show you several ways you can optimize your EF Core code.

Learn more about Entity Framework Core:

Follow us:

Useful Links:

#DotNet #efcore #entityframework #beginner

[jbob]

Clear and set at a good pace, great series. Thanks.

[naabun]

The whole series was excellent! Thank you so much

[webgooniedotcom]

The Raw SQL at the end may have saved my life including the find async. Thank you for that and also highlighight the the snapshot memeory that's always' in effect.

[muratcanoguzhan]

If AddDbContextPool is more efficient why everybody uses AddDbContext. Is there some tradeoffs or other things to be careful? Also why ef don't use splitquery as default because default one makes carteastan and you said no difference there.

[youngliu]

I have been using ef/efcore for a long time and still learn something from this video

[markussjoholm]

🎯 Key Takeaways for quick navigation:

00:35 📝 Disable change tracking with AsNoTracking for read-only scenarios to conserve system resources.
01:30 🏁 Choose between eager loading (Include method) and lazy loading (UseLazyLoadingProxies) for related entities based on performance needs.
03:18 🧩 Use split queries with AsSplitQuery to mitigate Cartesian explosions when dealing with one-to-many data sets.
04:19 💼 Employ from SQL interpolated methods to execute custom SQL queries while protecting against SQL injection.
05:15 🕵️ Optimize performance by using Find or FindAsync methods to access entity snapshots and by utilizing database context pooling to reduce object creation overhead.

Made with HARPA AI

[koori]

This is pure gold! Thank you very much ☺️

[AnNguyen-soqo]

The code for part 5 is not enough, where is the layout at 4:51? I saw your code on github but its not enough

[matt]

Excellent - this filled some knowledge gaps.

[wizyconduccion]

Beginners and not so much beginners : D

[rahulhadgal]

How to get custom query output bound to a dynamic object which can be serialized into json?

[ghevisartor]

1:00 Should you use if you use Include() of a property that could be shared by multiple Customers?
Otherwise it will create a new instance for every Customer right?
In this case with Orders it's not an issue but still.

[anandsutrave]

This is very informative, but it seems like the presenter is reading a script. It would have been great if they would explain more naturally.