public byte[] Load() { return(_database.Execute(conn => { return conn.QueryFirstOrDefault <byte[]>($"SELECT {Session} FROM {TelegramSessionTable} WHERE {UserId} = @{UserId}", new { UserId = _userId }); })); }
public static void Purge(IDatabaseConnector <HangfireDatabaseCredentials> database) { database.Execute(conn => { conn.Execute(@" IF OBJECT_ID('HangFire.State', 'U') IS NOT NULL BEGIN ALTER TABLE [HangFire].[State] DROP CONSTRAINT [FK_HangFire_State_Job]; ALTER TABLE [HangFire].[JobParameter] DROP CONSTRAINT [FK_HangFire_JobParameter_Job]; DROP TABLE [HangFire].[Schema]; DROP TABLE [HangFire].[Job]; DROP TABLE [HangFire].[State]; DROP TABLE [HangFire].[JobParameter]; DROP TABLE [HangFire].[JobQueue]; DROP TABLE [HangFire].[Server]; DROP TABLE [HangFire].[List]; DROP TABLE [HangFire].[Set]; DROP TABLE [HangFire].[Counter]; DROP TABLE [HangFire].[Hash]; DROP TABLE [HangFire].[AggregatedCounter]; DROP SCHEMA [HangFire]; END"); }); }