destro
Well-known member
- Joined
- Mar 28, 2020
- Messages
- 46
- Programming Experience
- 1-3
I faced this issue while trying to add-remove migration or updating database and took me almost a week to find a workaround. For some reason, my connection string to local SQL server wasn't being read from the appsettings.json file or appsettings.environment.json file. I looked out for many workarounds but this one solved it in my startup.cs class:
Earlier it was this:
This is the error I was getting when trying to add migration with the above method:
This is my appsettings.json file:
my program.cs
This is startup.cs
ApplicationDBContext that inherits from DesignTimeDbContextFactory.cs
This is DesignTimeDbContextFactory.cs
There is only single HomeController so far and some shared view with index.cshtml.
What could have caused this issue which didn't let my startup.cs class to read from appsettings.json?
I am a beginner to this so if it's not too much can anyone help me figure this out, also how do I get my startup.cs to read connection string from appsettings.json? Can it affect my project somehow in future?
This is my project structure:
Thanks in advance
startup.cs:
services.AddDbContextPool<ApplicationDbContext>(options =>
options.UseSqlServer("Server=(localdb)\\MSSQLLocalDB;Database=AstrologerDb;Trusted_Connection=True;MultipleActiveResultSets=true"));Earlier it was this:
startup.cs:
services.AddDbContextPool<ApplicationDbContext>(options =>
options.UseSqlServer(_config["ConnectionStrings:DefaultConnection"]));This is the error I was getting when trying to add migration with the above method:
This is my appsettings.json file:
appsettings.json:
{
"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\MSSQLLocalDB;Database=AstrologerDb;Trusted_Connection=True;MultipleActiveResultSets=true"
},
"Logging": {
"LogLevel": {
"Default": "Warning"
}
}
}my program.cs
Program.cs:
namespace manglamastro
{
public class Program
{
public static void Main(string[] args)
{
BuildWebHost(args).Run();
}
public static IWebHost BuildWebHost(string[] args)
{
return new WebHostBuilder()
.UseKestrel()
.UseContentRoot(Directory.GetCurrentDirectory())
.UseStartup<Startup>()
.Build();
}
}
}This is startup.cs
Startup.cs:
using manglamastro.Models;
namespace manglamastro
{
public class Startup
{
private IConfiguration _config;
public Startup(IConfiguration config)
{
_config = config;
}
// This method gets called by the runtime. Use this method to add services to the container.
// For more information on how to configure your application, visit https://go.microsoft.com/fwlink/?LinkID=398940
public void ConfigureServices(IServiceCollection services)
{
services.AddScoped<IAstrologerRepository, SQLAstrologerRepository>();
services.AddMvc();
services.AddDbContextPool<ApplicationDbContext>(options =>
options.UseSqlServer("Server=(localdb)\\MSSQLLocalDB;Database=AstrologerDb;Trusted_Connection=True;MultipleActiveResultSets=true"));
}
// 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.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseAuthentication();
app.UseCookiePolicy();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
routes.MapRoute(name: "login",
template: "{controller=Home}/{action=Login}");
});
}
}
}ApplicationDBContext that inherits from DesignTimeDbContextFactory.cs
ApplicationDbContext:
namespace manglamastro.Models
{
public class ApplicationDbContext:DbContext
{
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options):base(options)
{
}
public DbSet<Astrologer> Astrologers { get; set; }
public DbSet<Customers> Customers { get; set; }
public DbSet<Category> Categories { get; set; }
public DbSet<Specialization> Specializations { get; set; }
}
}This is DesignTimeDbContextFactory.cs
DesignTimeDbContextFactory.cs:
namespace manglamastro.Models
{
public class DesignTimeDbContextFactory : IDesignTimeDbContextFactory<ApplicationDbContext>
{
public ApplicationDbContext CreateDbContext(string[] args)
{
IConfigurationRoot configuration = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json")
.Build();
var builder = new DbContextOptionsBuilder<ApplicationDbContext>();
var connectionString = configuration.GetConnectionString("DefaultConnection");
builder.UseSqlServer(connectionString);
return new ApplicationDbContext(builder.Options);
}
}
}There is only single HomeController so far and some shared view with index.cshtml.
What could have caused this issue which didn't let my startup.cs class to read from appsettings.json?
I am a beginner to this so if it's not too much can anyone help me figure this out, also how do I get my startup.cs to read connection string from appsettings.json? Can it affect my project somehow in future?
This is my project structure:
Thanks in advance
