Database provider error in ASP.NET core

Question

0.00/5 (No votes)

See more:

I have ASP.NET Core MVC project with .NET 7.
I want put my SQL Server connection string in appsetting file. Then use that in my entire project and the layers.
But I get the provider error:

System.InvalidOperationException: 'No database provider has been configured for this DbContext. A provider can be configured by overriding the 'DbContext.OnConfiguring' method or by using 'AddDbContext' on the application service provider. If 'AddDbContext' is used, then also ensure that your DbContext type accepts a DbContextOptions<TContext> object in its constructor and passes it to the base constructor for DbContext.'

How can fix this?

What I have tried:

This is my appsetting:

C#

"ConnectionStrings": {
    "CON1": "data source=DESKTOP-JU6B74d\\SQL2019;initial catalog = Laser; integrated security = true;TrustServerCertificate=True;"
  },

This is the program file setting for dbcontext:

C#

builder.Services.AddControllersWithViews();
builder.Services.AddDbContext<DB>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("Con1")));

And this is part of my dbcontext in data access layer:

C#

  public class DB: IdentityDbContext
    {
        public DB() : base() { }

        public DB(DbContextOptions<DB> options) : base(options)
        {

        }

        protected override void OnConfiguring
                  (DbContextOptionsBuilder OptionsBuilder)
        {
            OptionsBuilder.UseSqlServer(@"data source=DESKTOP-JU6B74d\SQL2019;
            initial catalog = Laser; integrated security = true;
            TrustServerCertificate=True;");
            base.OnConfiguring(OptionsBuilder);
        }
}

When I use this dbcontext, I am not getting the provider error. but in this form, I should repeat my connection string in the db file too.
So when I comment the "protected override void OnConfiguring" I get the provider. so how can fix this and only read the connection string from the appsetting file and why does this problem occur?

Posted 21-Oct-23 21:04pm

Member 11400059

Updated 24-Oct-23 1:31am

Deeksha Shenoy

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2023-10-21T23:22:00

Solution 1

String keys are "case sensitive". Change this:

C#

builder.Services.AddDbContext<DB>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("Con1")));

.. to this:

C#

builder.Services.AddDbContext<DB>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("CON1")));

Posted 21-Oct-23 23:22pm

Graeme_Grant

Comments

Member 11400059 22-Oct-23 8:35am

thanks I do this. But still I get the provider error after remove the OnConfiguring method on dbcontext.

Graeme_Grant 22-Oct-23 8:39am

I fixed your appsettings issue where your connection string was not read. Your connection string not working with your DB is something different. Time for some debugging. The answer is in the error details. Ask a new question and include all of the error details, including stack traces, etc...

Member 11400059 22-Oct-23 11:52am

thanks for your help. just before I write this answer, I find one solution. but I do not now if this is correct or not. correctly I remove the parameter less constructor. also remove the override method too. now all of my method that connect to database need DbContextOptions as parameter. So i inject this too all of my controllers, components, layers and all over my project that show error. the problem fix now and connection string only read from appsetting. if this solution correct or we can use the better way too?
also as you said the sting is case sensitive. but now when I change my connection string name in program file to coN1 (the name in appsetting is CON1). the program still work and not case sensitive anymore. –

Richard Deeming 23-Oct-23 7:51am

Why are you injecting the DbContextOptions<TContext> instance? Just inject the DB instance instead, and let the DI container take care of creating the instance for you.