Asp.Net core dbcontext issue

Question

I am creating Asp.net core application and trying to connect to the database. I am getting an error at the following line of code in ConfigureServices method in the startup.cs file. The error that I am getting is the value cannot be null. It seems like it cant find the CustomerOrderEntities key in the web.config file. Not sure what the problem is

services.AddDbContext<CustomerOrderEntities>(options =>
                  options.UseSqlServer(Configuration.GetConnectionString("CustomerOrderEntities")));

Startup.cs

 public IServiceProvider ConfigureServices(IServiceCollection services)
        {
services.AddDbContext<CustomerOrderEntities>(options =>
              options.UseSqlServer(Configuration.GetConnectionString("CustomerOrderEntities")));

 AutoMapperConfiguration.Configure();

            // Create the container builder.
            var builder = new ContainerBuilder();

            // Register dependencies, populate the services from
            // the collection, and build the container. If you want
            // to dispose of the container at the end of the app,
            // be sure to keep a reference to it as a property or field.


            builder.RegisterType<UnitOfWork>().As<IUnitOfWork>();
            builder.RegisterType<DbFactory>().As<IDbFactory>();
            builder.RegisterType<CustomerRepository>().As<ICustomerRepository>();
            builder.RegisterType<ProductRepository>().As<IProductRepository>();
            builder.RegisterType<OrderRepository>().As<IOrderRepository>();



            builder.Populate(services);
            this.ApplicationContainer = builder.Build();

            // Create the IServiceProvider based on the container.
            return new AutofacServiceProvider(this.ApplicationContainer);
          }

Web.Config

<connectionStrings>

  <add name="CustomerOrderEntities" connectionString="metadata=res://*/EF.CustomerOrderContext.csdl|res://*/EF.CustomerOrderContext.ssdl|res://*/EF.CustomerOrderContext.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=test-PC\MSSQLSERVER2014;initial catalog=CodeFirstTest;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

  </connectionStrings>

Are you sure you are using EntityFramework 6? The reigstraiton looks more like EFCore and EF core doesn't uses web.config, but your appsettings.json (and user secrets for local development) — Tseng
– Tseng, Commented Nov 26, 2016 at 18:10
in asp.net core we don't store that kind of stuff in web.config, web.config is only for IIS configuration, you should be using appsettings.json — Joe Audette
– Joe Audette, Commented Nov 26, 2016 at 18:11
check if you have "CustomerOrderEntities" connectionstring in appsettings.json — Alexan
– Alexan, Commented Nov 26, 2016 at 18:23

Alexan · Accepted Answer · 2016-11-26 18:30:15Z

1

Connection string in ASP.NET Core is defined in appsettings.json, for example:

"ConnectionStrings": {
    "CustomerOrderEntities": "Server=(localdb)\\mssqllocaldb;Database=aspnet-a3e892a5-6a9c-4090-bc79-fe8c79e1eb26;Trusted_Connection=True;MultipleActiveResultSets=true"
  },

In your case name of connecting string is CustomerOrderEntities, you get null, probably it's not there, check you appsettings.json.

answered Nov 26, 2016 at 18:30

Alexan

8,71514 gold badges83 silver badges107 bronze badges

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

Comments

Ibrahim Mohammed · Accepted Answer · 2016-11-26 20:04:45Z

0

Your connectionstring in Appsettings.json is definitely missing. You cannot set connection string in web.config in Asp.net core whether you are targeting full .net framework or .net core. Alternative you type the connection string value in services.AddDbContext(options => options.UseSqlServer("Your Connectionstring")); for more information check here;

https://learn.microsoft.com/en-us/ef/core/

answered Nov 26, 2016 at 20:04

Ibrahim Mohammed

5514 silver badges10 bronze badges

Collectives™ on Stack Overflow

Asp.Net core dbcontext issue

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related