EF Core execute sql

Question

Am testing out Entity Framework Core, it's been well so far until i hit an error. I am not able to execute sql from a DbSet with FromSql. Error is dbset does not contain a definition for 'FromSql' The code is

_context.Account.FromSql("Select * from dbo.Account");

What am i doing wrong?

Answer 1

It happened that I needed one more nuget package to get FromSql as well as Include to work. I added this to my dependencies in the project.json file and after the restore, Voila.

"Microsoft.EntityFrameworkCore.Relational": "1.0.0"

Works now

Answer 2

Please add namespace

using Microsoft.EntityFrameworkCore;