EF 8 Raw SQL Queries Are Coming - Are You Excited? #shorts

Показать описание

Milan Jovanović

Рекомендации по теме

Комментарии

This feature was available back in EF6 (not EFCore). It's surprising it took this long to get it added into EFCore. But, it is nice to finally see it making a return.

relyengaming

Ive read about it but how does it benchmark against Dapper? With the projection, ofcourse.

BabyGhost

Its not a new feature however having the capability to project results into unmapped type is new

masifakbar

Sigh, Alright, I'll subscribe. This one feature has been a long time coming.

kurtnelle

Can you pass stored procedure instead of inline SQL queries?

Bourn

I understand the what and how but I dont get the why I would use this.

bogella

I would hate to work with any of these clueless devs in the comment section. Is this really how the industry is like?

diamondkingdiamond

To be fair, you have been able to execute raw SQL in EF since before it was EF Core. They have changed it over the years and improved it but I think your short is a bit misleading, as if this is a brand-new feature.

JasonHaffey

This is one of the best tutorials in minimal apis. I love tge fact that the trainer looked into common patterns such as automapper, fluent validation and even dtos. Is there a way to define the endpoints in a seperate file and only register the file or class on program.cs?

letlhogonolosetlhodi

Can you map the one to many / one to one result to dto class from this ?

jawadahmed

Does anyone has any idea to pass comma separated strings in the parameter? EF core added extra quote so it takes as a single long string. :D

devilspower

This is not a new feature. Previous versions of EF, you can do the same thing by calling the FromSQL method and passing in the SQL query that you want.

rhtservicestech

Milan, i'm already doing it in my projects since a few years. It is not a new.

mateuszrykowski

EF 8 Raw SQL Queries Are Coming - Are You Excited? #shorts

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

EF 8 new feature: Raw SQL queries for unmapped types

From Novice to Expert: Harnessing the Power of Raw SQL Queries in Entity Framework with C#

EF 8 Raw SQL Queries Are Coming - Are You Excited? #shorts

Raw SQL queries & stored procedures in Entity Framework Core

How to Execute Raw SQL Queries using Entity Framework Core with .NET 8

EF Core Raw SQL Queries Make Dapper Unnecessary #shorts

Composing Raw SQL And LINQ Queries With EF #shorts

How to use Sql Queries in ASP.NET CORE | Executing SQL Queries

Raw SQL Queries with EF Core Every Developer Should Know About | HOW TO - Code Samples

Secret To Optimizing SQL Queries - Understand The SQL Execution Order

Execute Raw SQL Queries in Entity Framework Core with .NET 8 | Asp.Net Core 8 Web API using EF Core

EF8, Raw SQL, but Dapper is FASTER !!!

Entity Framework Core #4 - Raw SQL Queries

Entity Framework Core 8: Improved JSON, queryable collections , and more… | .NET Conf 2023

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

Making Entity Framework Core As Fast As Dapper

Execute store procedure and SQL queries in entity framework core 7.0 | SP handling in EF Core 7.0

How do Entity Framework Core Queries Work?

Unmapped types with raw SQL in Entity Framework Core 8

(6)- Raw SQL with FromSqlRaw for Efficiency

How Entity Framework Tries to Copy Dapper in .NET 8

Executing raw SQL queries in EF Core

C# : Raw SQL Query without DbSet - Entity Framework Core