Can Entity Framework Core run SqlQuery? [duplicate]

Question

I have this code in .Net Framework. There is nothing wrong with it.

    // no problem in .net core
    public bool ExecuteQuery(string query, params object[] parameters)
    {
        return _context.Database.ExecuteSqlCommand(query, parameters) > 0;
    }

not found (SqlQuery) in Entity Framework Core

    public List<T> SqlQuery(string query, params object[] parameters)
    {
        var result = _context.Database.SqlQuery<T>(query, parameters).ToList();
        return result;
    }

    public object ExecuteNonQuery(string query, params object[] parameters)
    {
        var result = _context.Database.SqlQuery<string>(query, parameters);
        return result;
    }

How can I write the same code in .net core 2.1 ?

learn.microsoft.com/en-us/ef/core/modeling/query-types

Gert Arnold
– Gert Arnold

2018-08-03 20:04:32 +00:00
Commented Aug 3, 2018 at 20:04 — Gert Arnold
– Gert Arnold, Commented Aug 3, 2018 at 20:04

Alex Riabov · Accepted Answer · 2018-08-03 20:06:06Z

-1

You can't execute SqlQuery in EF Core, it requires to define a POCO class and a DbSet for that class. Then you can use it like:

using (var context = new SampleContext())
{
    var books = context.Books.FromSql("SELECT * FROM Books").ToList();
}

answered Aug 3, 2018 at 20:06

Alex Riabov

9,2865 gold badges50 silver badges48 bronze badges

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

3 Comments

Gert Arnold Over a year ago

This isn't the whole story any more.

Trevortni Over a year ago

@GertArnold: Care to elaborate?

Gert Arnold Over a year ago

There's Database.ExecuteSqlRaw now.

Collectives™ on Stack Overflow

Can Entity Framework Core run SqlQuery? [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related