Below is the start of the error that I got in the console.
Build started...
Build succeeded.
System.ArgumentNullException: Value cannot be null. (Parameter 'connectionString')
at Microsoft.EntityFrameworkCore.Utilities.Check.NotEmpty(String value, String parameterName)
at Microsoft.EntityFrameworkCore.SqlServerDbContextOptionsExtensions.UseSqlServer(DbContextOptionsBuilder optionsBuilder, String connectionString, Action`1 sqlServerOptionsAction)
at Bumples.Startup.<ConfigureServices>b__4_0(DbContextOptionsBuilder options) in C:\Users\Jennifer E Sheehan\source\repos\Bumples\Startup.cs:line 33
at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass1_0`2.<AddDbContext>b__0(IServiceProvider p, DbContextOptionsBuilder b)
at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.CreateDbContextOptions[TContext](IServiceProvider applicationServiceProvider, Action`2 optionsAction)
at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass10_0`1.<AddCoreServices>b__0(IServiceProvider p)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
I took out default connection and put in what was recommended by one tutorial that I am taking. Should I put DefaultConnection instead of BumplesConnection.
Member
9 Points
214 Posts
Value cannot be null. (Parameter 'connectionString')
Mar 25, 2020 09:44 PM|bumples18|LINK
Hi,
I am trying to link to my database. I am using aspnet.core 3.0 mvc. I am using nu-get console and getting the above error.
Below is the appsettings.json:
"ConnectionStrings": {
"BumplesDBConnection": "Server=(localdb)\\mssqllocaldb;Database=aspnet-Bumples;Trusted_Connection=True;MultipleActiveResultSets=true"
},
Below is the startup:
public void ConfigureServices(IServiceCollection services)
{
services.AddControllersWithViews();
services.AddDbContext<ApplicationDbContext>(options =>
options.UseSqlServer(
Configuration.GetConnectionString("DefaultConnection")));
services.AddScoped<IMembersRepository, SQLMembersRepository>();
}
Below is the start of the error that I got in the console.
Build started...
Build succeeded.
System.ArgumentNullException: Value cannot be null. (Parameter 'connectionString')
at Microsoft.EntityFrameworkCore.Utilities.Check.NotEmpty(String value, String parameterName)
at Microsoft.EntityFrameworkCore.SqlServerDbContextOptionsExtensions.UseSqlServer(DbContextOptionsBuilder optionsBuilder, String connectionString, Action`1 sqlServerOptionsAction)
at Bumples.Startup.<ConfigureServices>b__4_0(DbContextOptionsBuilder options) in C:\Users\Jennifer E Sheehan\source\repos\Bumples\Startup.cs:line 33
at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass1_0`2.<AddDbContext>b__0(IServiceProvider p, DbContextOptionsBuilder b)
at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.CreateDbContextOptions[TContext](IServiceProvider applicationServiceProvider, Action`2 optionsAction)
at Microsoft.Extensions.DependencyInjection.EntityFrameworkServiceCollectionExtensions.<>c__DisplayClass10_0`1.<AddCoreServices>b__0(IServiceProvider p)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, RuntimeResolverContext context)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSiteMain(ServiceCallSite callSite, TArgument argument)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitCache(ServiceCallSite callSite, RuntimeResolverContext context, ServiceProviderEngineScope serviceProviderEngine, RuntimeResolverLock lockType)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScopeCache(ServiceCallSite singletonCallSite, RuntimeResolverContext context)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(ServiceCallSite callSite, TArgument argument)
Hope someone can help me, Thanks,
Jen
All-Star
58234 Points
15673 Posts
Re: Value cannot be null. (Parameter 'connectionString')
Mar 25, 2020 10:03 PM|bruce (sqlwork.com)|LINK
where is DefaultConnection defined in app.settings
Member
9 Points
214 Posts
Re: Value cannot be null. (Parameter 'connectionString')
Mar 26, 2020 12:03 AM|bumples18|LINK
I took out default connection and put in what was recommended by one tutorial that I am taking. Should I put DefaultConnection instead of BumplesConnection.
Jen
Member
9 Points
214 Posts
Re: Value cannot be null. (Parameter 'connectionString')
Mar 26, 2020 12:27 AM|bumples18|LINK
I put back default connection and know I am getting errors that I think I can fix. Thank you for getting back to me so fast.
Jen