ASP.NET Core 3.0 缓存（Cache）之 SQL Server 、Redis、MySQL、MemoryCache缓存

ASP.NET Core 3.0 缓存（Cache）之 SQL Server 缓存

ASP.NET Core 3.0 缓存（Cache）之 Redis 缓存

ASP.NET Core 3.0 缓存（Cache）之 MySQL 缓存

ASP.NET Core 3.0 缓存（Cache）之内存缓存（Memory Cache）

 

 

--sql server
dotnet tool install --global dotnet-sql-cache
dotnet sql-cache create "Server=192.168.0.44;User Id=sa;Password=1234;Database=Program_Test;" dbo AspNetCoreCache

--mysql
dotnet tool install --global Pomelo.Extensions.Caching.MySqlConfig.Tools --version 2.0.2
dotnet mysql-cache create "Server=192.168.0.82;User Id=sa;Password=1234;Database=program_test;Port=13306;default command timeout=100;Connection Timeout=30;Charset=utf8;" dbo AspNetCoreCache

 

sqlserver:

 

-- ----------------------------
            -- Table structure for AspNetCoreCache
            -- ----------------------------
            DROP TABLE [dbo].[AspNetCoreCache]
            GO
            CREATE TABLE [dbo].[AspNetCoreCache] (
                [Id] nvarchar(449) NOT NULL ,
                [Value] varbinary(MAX) NOT NULL ,
                [ExpiresAtTime] datetimeoffset(7) NOT NULL ,
                [SlidingExpirationInSeconds] bigint NULL ,
                [AbsoluteExpiration] datetimeoffset(7) NULL 
            )

            GO

            -- ----------------------------
            -- Indexes structure for table AspNetCoreCache
            -- ----------------------------
            CREATE INDEX [Index_ExpiresAtTime] ON [dbo].[AspNetCoreCache]
            ([ExpiresAtTime] ASC) 
            GO

            -- ----------------------------
            -- Primary Key structure for table AspNetCoreCache
            -- ----------------------------
            ALTER TABLE [dbo].[AspNetCoreCache] ADD PRIMARY KEY ([Id])
            GO 

 

mysql:

SET FOREIGN_KEY_CHECKS=0;

            -- ----------------------------
            -- Table structure for aspnetcorecache
            -- ----------------------------
            DROP TABLE IF EXISTS `aspnetcorecache`;
            CREATE TABLE `aspnetcorecache` (
                `Id` varchar(449) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
                `AbsoluteExpiration` datetime(6) DEFAULT NULL,
                `ExpiresAtTime` datetime(6) NOT NULL,
                `SlidingExpirationInSeconds` bigint(20) DEFAULT NULL,
                `Value` longblob NOT NULL,
                PRIMARY KEY (`Id`),
                KEY `Index_ExpiresAtTime` (`ExpiresAtTime`)
            ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;