Custom Table Prefix in HangfireDbContext

[hmlu36]

Hello,

I noticed that there is a prefix parameter in the HangfireDbContext, but it seems that it is not being utilized, resulting in the inability to customize the table prefix name. I attempted to set a custom prefix, but it doesn't reflect in the generated table names.

Is there a specific way to use the prefix parameter, or is there any other workaround to achieve custom table prefix functionality in HangfireDbContext?

Thank you for your assistance.

• HangfireDbContext

      /// <summary>
      /// Starts SQLite database using a connection string for file system database
      /// </summary>
      /// <param name="databasePath">the database path</param>
      /// <param name="prefix">Table prefix</param>
      private HangfireDbContext(string databasePath, string prefix = "hangfire")
      {
          //UTC - Internal JSON
          GlobalConfiguration.Configuration
              .UseSerializerSettings(new JsonSerializerSettings()
              {
                  DateTimeZoneHandling = DateTimeZoneHandling.Utc,
                  DateFormatHandling = DateFormatHandling.IsoDateFormat,
                  DateFormatString = "yyyy-MM-dd HH:mm:ss.fff"
              });
  
          Database = new SQLiteConnection(databasePath, SQLiteOpenFlags.ReadWrite |
              SQLiteOpenFlags.Create | SQLiteOpenFlags.FullMutex, storeDateTimeAsTicks: true);
  
          ConnectionId = Guid.NewGuid().ToString();
      }
  
      /// <summary>
      /// Initializes initial tables schema for Hangfire
      /// </summary>
      public void Init(SQLiteStorageOptions storageOptions)
      {
          StorageOptions = storageOptions;
  
          AutoClean(storageOptions);
  
          Database.CreateTable<AggregatedCounter>();
          Database.CreateTable<Counter>();
          Database.CreateTable<HangfireJob>();
          Database.CreateTable<HangfireList>();
          Database.CreateTable<Hash>();
          Database.CreateTable<JobParameter>();
          Database.CreateTable<JobQueue>();
          Database.CreateTable<HangfireServer>();
          Database.CreateTable<Set>();
          Database.CreateTable<State>();
          Database.CreateTable<DistributedLock>();
  
          AggregatedCounterRepository = Database.Table<AggregatedCounter>();
          CounterRepository = Database.Table<Counter>();
          HangfireJobRepository = Database.Table<HangfireJob>();
          HangfireListRepository = Database.Table<HangfireList>();
          HashRepository = Database.Table<Hash>();
          JobParameterRepository = Database.Table<JobParameter>();
          JobQueueRepository = Database.Table<JobQueue>();
          HangfireServerRepository = Database.Table<HangfireServer>();
          SetRepository = Database.Table<Set>();
          StateRepository = Database.Table<State>();
          DistributedLockRepository = Database.Table<DistributedLock>();
      }