Skip to content
This repository has been archived by the owner on Nov 20, 2018. It is now read-only.

Change PK creation in sql cache tool to allow multiple table creations #308

Closed
BrennanConroy opened this issue Jun 16, 2017 · 0 comments
Closed

Comments

@BrennanConroy
Copy link
Member

You can't create 2 tables in the same database with this tool currently because you get

An error occurred while trying to create the table and index. There is already an object named 'pk_Id' in the database.
Could not create constraint or index. See previous errors.

The second time you try to create a new table.

Changing:
https://github.com/aspnet/DotNetTools/blob/dev/src/Microsoft.Extensions.Caching.SqlConfig.Tools/SqlQueries.cs#L19
to
PRIMARY KEY (Id)
should fix the issue

cc @natemcmaster

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants