I'm testing Hangfire in Asp.net Core 3.1 app. I want to persist data to sqlite database. I added connection string into appsettings.json file
"ConnectionStrings": {
"Default": "Data Source=C:\\database\\hangfireDb.db; Version = 3; New = True; Compress = True;"},
Here is Startup class
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)
{
services.AddControllersWithViews();
services.AddHangfire(configuration => configuration
.UseSimpleAssemblyNameTypeSerializer()
.UseRecommendedSerializerSettings()
.UseSQLiteStorage(Configuration.GetConnectionString("Default")));
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseRouting();
app.UseAuthorization();
app.UseHangfireServer();
app.UseHangfireDashboard();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
}
}
Connection to database cannot be established
SQLite.SQLiteException: 'Could not open database file: Data Source=C:\database\hangfireDb.db; Version = 3; New = True; Compress = True; (CannotOpen)'
I can open database if I use only a path to database
services.AddHangfire(configuration => configuration
.UseSimpleAssemblyNameTypeSerializer()
.UseRecommendedSerializerSettings()
.UseSQLiteStorage("C:\\database\\hangfireDb.db"));
Or
"ConnectionStrings": {
"Default": "C:\\database\\hangfireDb.db"},
This does not look like a proper connection string. I think I'm missing something. Connection string should include "Data Source" and any additional tag, but in this case only path to database works.
Configuration.GetConnectionString("Default")return (debug it and check, don't guess)?