Raw SQL queries and Entity Framework Core

Question

I migrate my application to ASP.NET MVC Core and Entity Framework Core and i found problem. I have raw SQL query to entity like this

var rawSQL = dbContext.Database.SqlQuery<SomeModel>("Raw SQL Query").ToList();

But there is no SqlQuery<T> in context.Database. Do you have solution for this problem?

see my answer below on how to use an extension method to use parameterized (or not) SQL. — diegosasw
– diegosasw, Commented Feb 10, 2016 at 2:39

diegosasw · Accepted Answer · 2016-02-10 02:37:26Z

12

Make sure you add using Microsoft.Data.Entity; because there is an extension method you could use.

var rawSQL = dbContext.SomeModels.FromSql("your SQL");

Even better, instead using raw SQL (at risk of SQL injections attacks) this FromSql method allows you to use parameterized queries like:

dbContext.SomeModels.FromSql("SELECT * FROM dbo.Blogs WHERE Name = @p0", blogName);

answered Feb 10, 2016 at 2:37

diegosasw

16k18 gold badges111 silver badges188 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Obin Over a year ago

Working well but its strange calling SQL queries from specific entity model than generally database. About injections attacks i know and i'm using SQL parameters but i wanted to show simple problem in example. Thanks

nam Over a year ago

@iberodev How would you do it if your sql query contains two tables?

diegosasw Over a year ago

@nam as shown here: docs.efproject.net/en/latest/querying/… by adding an .Include(b => b.Posts) you are joining with another table

Reynier Booysen Over a year ago

Just a note, for Entity Framework Core, I had to include the namespace: using Microsoft.EntityFrameworkCore;

ManirajSS Over a year ago

what about querying against DbContext instead of DeSet? @iberodev

Collectives™ on Stack Overflow

Raw SQL queries and Entity Framework Core

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related