Entity Framework 6 not recognizing AddSqlServer()

Question

I am trying to use EF6 with VS2015 CTP and ASP.NET MVC 6. it is not recognizing the below mentioned code in startup.cs which I added when I was using EF7.

    public void ConfigureServices(IServiceCollection services)
    {
        services.AddEntityFramework(Configuration)
          .AddSqlServer()
          .AddDbContext<VNDBContext>(options => options.UseSqlServer(Configuration.Get("Data:VNDBContext:ConnectionString")));

        services.AddMvc().Configure<MvcOptions>(options =>
        {
            var jsonFormatter = (JsonOutputFormatter)options.OutputFormatters
            .Where(o => o.Instance.GetType() == typeof(JsonOutputFormatter)).First().Instance;
            jsonFormatter.SerializerSettings.ReferenceLoopHandling =
                 ReferenceLoopHandling.Ignore;

        });
        services.AddSingleton<INodeService, NodeService>();
    }

If I use EF7 it has other issues as it is not matured yet.

How can I set above mentioned setting while doing everything in MVC6 but with EF6?

See this question for how to use EF 6. stackoverflow.com/questions/29296073/… — Tom
– Tom, Commented Apr 12, 2015 at 20:36

Hardik Chudasama · Accepted Answer · 2016-06-30 03:57:17Z

3

Actually with the latest update they have changed it a bit! they renamed the package to EntityFramework.MicrosoftSqlServer Try searching with that in the nuGet manager and you will get all the methods you are looking for.

answered Jun 30, 2016 at 3:57

Hardik Chudasama

814 bronze badges

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

Comments

Matt DeKrey · Accepted Answer · 2015-04-18 16:22:03Z

1

As @ErikEJ mentions in his answer, EF6 is very different from EF7 and does not have any utilities for working in the Startup.cs. However, that is not to say it's not possible; I'm doing it with my own project with a line similar to the following:

services.AddTransient<MyEf6DbContext>(sp => new MyEf6DbContext(Configuration.Get("Data:VNDBContext:ConnectionString")));

This allows you to use MyEf6DbContext injected into your controllers and other services just as you'd expect! You'll have to do some more work to get Identity 3 and such to work with EF6, but they're all very pluggable.

answered Apr 18, 2015 at 16:22

Matt DeKrey

12k5 gold badges57 silver badges71 bronze badges

Comments

ErikEJ · Accepted Answer · 2015-04-11 03:38:59Z

1

EF6 is a very different framework from EF7, and does not have a UseSqlServer extension method.

answered Apr 11, 2015 at 3:38

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

2 Comments

Raas Masood Over a year ago

so is it just not possible to use EF6 with mvc 6 in vs2015?

ErikEJ Over a year ago

I imagine it should be, if you target .net 4.5, but of course you cannot use any new apis!

Avi Cherry · Accepted Answer · 2015-04-30 00:26:17Z

1

Actually, you can use EF6 with dnx451 and MVC6, which gives you access to all of the new APIs. EF6 is not designed out of the box, though, to work with the new DependencyInjection system, so you'll need to configure it yourself. Also, migrations won't work at all. I wrote some replacement 'k/dnx' commands that can handle migrations the same way that the EF7 project does.

answered Apr 30, 2015 at 0:26

Avi Cherry

4,1061 gold badge29 silver badges31 bronze badges

Collectives™ on Stack Overflow

Entity Framework 6 not recognizing AddSqlServer()

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related