implementing Shopping-Cart with Microservices
run these scripts before compiling
CREATE DATABASE ShoppingCart GO
USE [ShoppingCart] GO
CREATE TABLE [dbo].[ShoppingCart]( [ID] int IDENTITY(1,1) PRIMARY KEY, [UserId] [bigint] NOT NULL, CONSTRAINT ShoppingCartUnique UNIQUE([ID], [UserID]) ) GO
CREATE INDEX ShoppingCart_UserId ON [dbo].[ShoppingCart] (UserId) GO
CREATE TABLE [dbo].[ShoppingCartItem]( [ID] int IDENTITY(1,1) PRIMARY KEY, [ShoppingCartId] [int] NOT NULL, [ProductCatalogId] [bigint] NOT NULL, [ProductName] nvarchar NOT NULL, [ProductDescription] nvarchar NULL, [Amount] [int] NOT NULL, [Currency] nvarchar NOT NULL )
GO
ALTER TABLE [dbo].[ShoppingCartItem] WITH CHECK ADD CONSTRAINT [FK_ShoppingCart] FOREIGN KEY([ShoppingCartId]) REFERENCES [dbo].[ShoppingCart] ([Id]) GO
ALTER TABLE [dbo].[ShoppingCartItem] CHECK CONSTRAINT [FK_ShoppingCart] GO
CREATE INDEX ShoppingCartItem_ShoppingCartId ON [dbo].[ShoppingCartItem] (ShoppingCartId) GO
CREATE TABLE [dbo].[EventStore]( [ID] int IDENTITY(1,1) PRIMARY KEY, [Name] nvarchar NOT NULL, [OccurredAt] [datetimeoffset] NOT NULL, [Content]nvarchar NOT NULL ) GO