Hi everyone,
I ran into the following error while attempting to use a custom query with EntityFramework:
DbSet does not contain a definition for ‘FromSQL’ and no extension method ‘FromSql’ accepting an argument of type ‘DbSet’ could be found.
This one’s pretty straight forward:
// Install the following package via nuget
Install-package Microsoft.EntityFrameworkCore.Relational
Install-package Microsoft.EntityFrameworkCore.Relational
//Add the following namespace to your file
using Microsoft.EntityFrameworkCore;
Hopefully that’ll solve it for you, but if not there’s a lot a more information in these posts:
https://stackoverflow.com/a/38919326/522859
https://github.com/npgsql/Npgsql.EntityFrameworkCore.PostgreSQL/issues/146