Skip to content

Instantly share code, notes, and snippets.

@manoj-choudhari-git
Last active June 8, 2021 21:28
Show Gist options
  • Save manoj-choudhari-git/8120c8408456cba3d5338c9f3ab8c583 to your computer and use it in GitHub Desktop.
Save manoj-choudhari-git/8120c8408456cba3d5338c9f3ab8c583 to your computer and use it in GitHub Desktop.
.NET Core Web API - Distributed SQL Server Cache
## Install DOTNET-SQL-CACHE tools globally so that we can run next command
dotnet tool install --global dotnet-sql-cache
## Run DOTNET CLI command
## parameters are - connection string, schema name and table name - in that order
## This command just creates tables and indexes. It does not create database
## Database specified in connection string should already be created.
dotnet sql-cache create
"Data Source=.;Initial Catalog=MyCacheDb;Integrated Security=True;" dbo CacheStore
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment