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");
});
}
