Everything You Need To Know About EF Core 8 Raw SQL Queries

☄️ Master the Modular Monolith Architecture: https://bit.ly/3SXlzSt
📌 Accelerate your Clean Architecture skills: https://bit.ly/3PupkOJ
🚀 Support me on Patreon to access the source code:   / milanjovanovic  

EF Core is one of the best ORMs out there. And it's getting an excellent new feature allowing you to query unmapped types. You can return data with SQL queries, views, functions, and stored procedures. EF Core is coming closer to Dapper with this feature, although the performance isn't there yet.

And I'll talk about SQL injection attacks and if there's a vulnerability.

Join my weekly .NET newsletter:
https://www.milanjovanovic.tech

Read my Blog here:
https://www.milanjovanovic.tech/blog

Subscribe for more:
   / @milanjovanovictech  

Chapters
0:00 What are Raw SQL Queries?
0:47 Introducing SqlQuery
1:46 What about SQL Injection?
3:41 Composing SqlQuery with LINQ
4:37 Introducing SqlQueryRaw
6:08 Creating a database view
6:47 Querying views with EF8 SqlQuery