Everything You Need To Know About EF Core 8 Raw SQL Queries
️ Master the Modular Monolith Architecture:
Accelerate your Clean Architecture skills:
Support me on Patreon to access the source code:
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:
Read my Blog here:
Subscribe for more:
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
