Last active
June 8, 2021 20:33
-
-
Save manoj-choudhari-git/0790754cca94dc6cf69a2bb4663a8e95 to your computer and use it in GitHub Desktop.
.NET Core Web API - SQL Script to create the cache store for Distributed SQL Server cache
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE [MyCacheDb] | |
GO | |
/****** Object: Table [dbo].[CacheStore] Script Date: 08/06/2021 10:29:38 pm ******/ | |
SET ANSI_NULLS ON | |
GO | |
SET QUOTED_IDENTIFIER ON | |
GO | |
CREATE TABLE [dbo].[CacheStore]( | |
[Id] [nvarchar](449) NOT NULL, | |
[Value] [varbinary](max) NOT NULL, | |
[ExpiresAtTime] [datetimeoffset](7) NOT NULL, | |
[SlidingExpirationInSeconds] [bigint] NULL, | |
[AbsoluteExpiration] [datetimeoffset](7) NULL, | |
PRIMARY KEY CLUSTERED | |
( | |
[Id] ASC | |
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, | |
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] | |
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] | |
GO | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment