DbContext constructor connection string error keyword name not supported

Question

The entity framework documentation states that I can use a named parameter when supplying my connection string:

public class BloggingContext : DbContext 
{ 
    public BloggingContext() 
        : base("name=BloggingCompactDatabase") 
    { 
    } 
}

I normally don't normally bother with the named parameter:

public TspDbContext()
    : base("ViktorVooey") { }

but I thought I'd give it a go just for confirmation:

   public TspDbContext()
            : base("name=ViktorVooey") { }

and it fails saying

Keyword not supported : name

This is on EF6. So I'm sort of stuck between not really caring but still wanting to know "what's up with that" all the same.

hillstuk · Accepted Answer · 2018-07-09 12:15:56Z

2

I came across your post because I had the same error. The MSDN documentation for EF 6 DbContext explicitly states that the 'name=' part of the constructor string parameter is supported and means:

The name can also be passed in the form 'name=myname', in which case the name must be found in the config file or an exception will be thrown.

In other words the "name=" prefix forces EF to only look for a config file entry for the connection string.

So you should check that the value you pass with "name=" is actually a name key value in your config file.

For example, in the config file:

<add name="MyContextName" connectionString="blah blah"/>

In the constructor:

public MyContext()
            : base("name=MyContextName")

edited Jul 9, 2018 at 12:15

answered Jul 31, 2014 at 11:17

hillstuk

1,65614 silver badges13 bronze badges

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

Comments

Kirsten · Accepted Answer · 2017-03-18 02:13:11Z

0

For me this turned out to be an issue with Resharper. I suspended Resharper, built and the error went away.

After I restarted Resharper the error stayed away.

answered Mar 18, 2017 at 2:13

Kirsten

18.8k52 gold badges213 silver badges368 bronze badges

Collectives™ on Stack Overflow

DbContext constructor connection string error keyword name not supported

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related