Skip to content

Instantly share code, notes, and snippets.

@manoj-choudhari-git
Last active June 8, 2021 20:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save manoj-choudhari-git/0790754cca94dc6cf69a2bb4663a8e95 to your computer and use it in GitHub Desktop.
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
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