The type or namespace name 'Relational' does not exist in the namespace 'Microsoft.EntityFrameworkCore'

Question

In an ASP.Net Core 1.1 web application, in VS 2017, I need to reference the package:
Microsoft.EntityFrameworkCore.Relational
(this is in order to call stored procedures with result sets as described here: How to run stored procedures in Entity Framework Core?)

When installing the package from PM console, with:

Install-Package Microsoft.EntityFrameworkCore.Relational

I get "Successfully installed 'Microsoft.EntityFrameworkCore.Relational 1.1.2'"

But when I add the line:

using Microsoft.EntityFrameworkCore.Relational;

at the top of the file, the word "Relational" has a red squiggle under with the error:

The type or namespace name 'Relational' does not exist in the namespace 'Microsoft.EntityFrameworkCore' (are you missing an assembly reference?)

I isolated the problem to creating a new project of type "ASP.Net Core Web Application (.Net Framework)", selecting the template for an empty ASP.Net Core 1.1 project, then installing the above package. I still get the same error.
TIA

Ivan Stoev · Accepted Answer · 2017-06-20 13:43:46Z

4

Microsoft.EntityFrameworkCore.Relational is assembly. There is no such namespace in EF Core.

The FromSql method is defined in the Microsoft.EntityFrameworkCore namespace, RelationalQueryableExtensions class, so all you need to get access to it is the typical

using Microsoft.EntityFrameworkCore;

answered Jun 20, 2017 at 13:43

Ivan Stoev

208k17 gold badges356 silver badges376 bronze badges

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

4 Comments

Dan Z Over a year ago

According to the StackOverflow post I linked to, in order to retrieve a typed result set from a stored procedure, I need to use: dbContext.Set() which is in the Microsoft.EntityFrameworkCore.Relational assembly. I did install that assembly as described in my question

Ivan Stoev Over a year ago

That's correct. You need to install the assembly. By doing that it will bring up some additional methods in the aforementioned namespace. Btw, the answer from the link is not quite correct - there is not Set() method, the method is Set<T>() and FromSql is an extension method of IQueryable<T>.

Ivan Stoev Over a year ago

I would suggest you reading the comments under the accepted answer you are referring to. Accepted and upvoted doesn't always mean working. Especially in EF Core where the things change with almost every build :(

Dan Z Over a year ago

Thanks Ivan, I think I've got it now. At the time of the post I got my info from, the Microsoft.EntityFrameworkCore.Relational assembly contained a namespace of the same name, under which was the method FromSql. In the latest version it only adds new classes to the namespace Microsoft.EntityFrameworkCore, and that's where FromSql is now.

Collectives™ on Stack Overflow

The type or namespace name 'Relational' does not exist in the namespace 'Microsoft.EntityFrameworkCore'

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related