Error when get connection string: ArgumentNullException: Value cannot be null. Parameter name: connectionString

Do Nhu Vy

I am using ASP.NET Core 2.0. Below is my code.

Startup:

namespace foo
{
    public class Startup
    {
        public Startup(IConfiguration configuration)
        {
            Configuration = configuration;
        }

        public IConfiguration Configuration { get; }

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            // Add framework services.
            services
                .AddMvc()
                .AddJsonOptions(options => options.SerializerSettings.ContractResolver = new DefaultContractResolver());
            services.AddDbContext<fooContext>(options => options.UseSqlServer(Configuration.GetConnectionString("UserDatabase")));
        }

        // This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
        public void Configure(IApplicationBuilder app, IHostingEnvironment env)
        {
            if (env.IsDevelopment())
            {
                app.UseBrowserLink();
                app.UseDeveloperExceptionPage();
            }
            else
            {
                app.UseExceptionHandler("/Home/Error");
            }

            app.UseStaticFiles();

            app.UseMvc(routes =>
            {
                routes.MapRoute(
                    name: "default",
                    template: "{controller=Home}/{action=Index}/{id?}");
            });
        }
    }
}

appsettings.json:

{
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Microsoft": "Information"
    },
    "ConnectionStrings": {
      "UserDatabase": "Server=DESKTOP-FSES7UK;Database=xxx;User Id=sa; Password=xxxxxxx;Trusted_Connection=True;"
    }
  }
}

How to fix it?

Sajeetharan

As mentioned in the comment, try to move your connection string to the top (suggestion) fix is to take the key *"ConnectionStrings" *outside of logging key

appsettings.json

{
  "ConnectionStrings": {
      "UserDatabase": "Server=DESKTOP-FSES7UK;Database=xxx;User Id=sa; Password=xxxxxxx;Trusted_Connection=True;"
  },
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Debug",
      "System": "Information",
      "Microsoft": "Information"
  }
}

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

Getting an error in xamarin forms while inserting data: System.ArgumentNullException: 'Value cannot be null. Parameter name: cancel'

System.ArgumentNullException: Value cannot be null. (Parameter 'connectionString') asp.net Core Docker-compose

asp.net core 2.0 - Value cannot be null. Parameter name: connectionString

Value cannot be null. Parameter name: connectionString appsettings.json in starter

ArgumentNullException: Value cannot be null. Parameter name: constructor

Ninject StandardKernel System.ArgumentNullException: value cannot be null. Parameter name: path1

Azure App Service custom authentication getting System.ArgumentNullException: "Value cannot be null" "Parameter name: provider"

Autofac System.ArgumentNullException : Value cannot be null. Parameter name: context

ReportViewer 15.0.0 Renerding: Sys.ArgumentNullException: Value cannot be null. Parameter name: element

ArgumentNullException: Value cannot be null. Parameter name: entity

Winform: System.ArgumentNullException: 'Value cannot be null. (Parameter 'stream')'

Value cannot be null. Parameter name: source when trying to get data with web api

Xamarin Forms OnConfigurationChanged - System.ArgumentNullException: Value cannot be null Parameter name: enumerable

System.ArgumentNullException: 'Value cannot be null. (Parameter 'connectionString')'

.NET Core worker exception: Value cannot be null. Parameter name connectionString

ArgumentNullException: Value cannot be null. (Parameter 'items')

Bot Framework error when doing context.Wait(): Value cannot be null. Parameter name: wait

ArgumentNullException : Value cannot be null. Parameter name : viewData

IdentityServer4 System.ArgumentNullException: Value cannot be null. Parameter name: type when trying to refresh token

ContentDispositionHeaderValueIdentityExtensions.IsFileDisposition thows ArgumentNullException: Value cannot be null Parameter name: header

System.ArgumentNullException: 'Value cannot be null error

Error :- Value Cannot be null Parameter Name:ConnectionString in .Net Core for two database connections

EFCore "Value cannot be null. (Parameter 'connectionString')" if value is in environment variables

Value cannot be null (Parameter 'connectionString') .NET 6

Why I get Value cannot be null. (Parameter 'connectionString') error message after Adding Migrations

Unity throw ArgumentNullException: Value cannot be null. Parameter name: collider

System.ArgumentNullException: 'Value cannot be null. Parameter name: provider'

Get exception: ArgumentNullException: Value cannot be null. (Parameter 'source') for CRUD operation

Error: Value cannot be null. (Parameter 'connectionString') + Migrations + secrets.json

TOP Ranking

  1. 1

    Failed to listen on localhost:8000 (reason: Cannot assign requested address)

  2. 2

    How to import an asset in swift using Bundle.main.path() in a react-native native module

  3. 3

    Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

  4. 4

    pump.io port in URL

  5. 5

    Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

  6. 6

    BigQuery - concatenate ignoring NULL

  7. 7

    ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

  8. 8

    Do Idle Snowflake Connections Use Cloud Services Credits?

  9. 9

    maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

  10. 10

    Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

  11. 11

    Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

  12. 12

    Generate random UUIDv4 with Elm

  13. 13

    Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

  14. 14

    Is it possible to Redo commits removed by GitHub Desktop's Undo on a Mac?

  15. 15

    flutter: dropdown item programmatically unselect problem

  16. 16

    Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

  17. 17

    EXCEL: Find sum of values in one column with criteria from other column

  18. 18

    Pandas - check if dataframe has negative value in any column

  19. 19

    How to use merge windows unallocated space into Ubuntu using GParted?

  20. 20

    Make a B+ Tree concurrent thread safe

  21. 21

    ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

HotTag

Archive