· 6 years ago · Apr 30, 2019, 10:34 PM
1Each package is licensed to you by its owner. NuGet is not responsible for, nor does it grant any licenses to, third-party packages. Some packages may include dependencies which are governed by additional licenses. Follow the package source (feed) URL to determine any dependencies.
2
3Package Manager Console Host Version 4.9.3.5777
4
5Type 'get-help NuGet' to see all available NuGet commands.
6
7PM> update-database
8Microsoft.EntityFrameworkCore.Infrastructure[10403]
9 Entity Framework Core 2.2.4-servicing-10062 initialized 'MovieManagementContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
10Microsoft.EntityFrameworkCore.Database.Command[20101]
11 Executed DbCommand (50,798ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
12 CREATE DATABASE [MovieManagement20190430052412_db];
13Microsoft.EntityFrameworkCore.Database.Command[20101]
14 Executed DbCommand (36ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
15 IF SERVERPROPERTY('EngineEdition') <> 5
16 BEGIN
17 ALTER DATABASE [MovieManagement20190430052412_db] SET READ_COMMITTED_SNAPSHOT ON;
18 END;
19Microsoft.EntityFrameworkCore.Database.Command[20101]
20 Executed DbCommand (46ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
21 CREATE TABLE [__EFMigrationsHistory] (
22 [MigrationId] nvarchar(150) NOT NULL,
23 [ProductVersion] nvarchar(32) NOT NULL,
24 CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
25 );
26Microsoft.EntityFrameworkCore.Database.Command[20101]
27 Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
28 SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
29Microsoft.EntityFrameworkCore.Database.Command[20101]
30 Executed DbCommand (50ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
31 SELECT [MigrationId], [ProductVersion]
32 FROM [__EFMigrationsHistory]
33 ORDER BY [MigrationId];
34Microsoft.EntityFrameworkCore.Migrations[20402]
35 Applying migration '20190430165038_Initial'.
36Applying migration '20190430165038_Initial'.
37Microsoft.EntityFrameworkCore.Database.Command[20101]
38 Executed DbCommand (50ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
39 CREATE TABLE [Actors] (
40 [ID] int NOT NULL IDENTITY,
41 [Name] nvarchar(50) NOT NULL,
42 CONSTRAINT [PK_Actors] PRIMARY KEY ([ID])
43 );
44Microsoft.EntityFrameworkCore.Database.Command[20101]
45 Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
46 CREATE TABLE [AspNetRoles] (
47 [Id] nvarchar(450) NOT NULL,
48 [Name] nvarchar(256) NULL,
49 [NormalizedName] nvarchar(256) NULL,
50 [ConcurrencyStamp] nvarchar(max) NULL,
51 CONSTRAINT [PK_AspNetRoles] PRIMARY KEY ([Id])
52 );
53Microsoft.EntityFrameworkCore.Database.Command[20101]
54 Executed DbCommand (40ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
55 CREATE TABLE [AspNetUsers] (
56 [Id] nvarchar(450) NOT NULL,
57 [UserName] nvarchar(50) NOT NULL,
58 [NormalizedUserName] nvarchar(256) NULL,
59 [Email] nvarchar(256) NULL,
60 [NormalizedEmail] nvarchar(256) NULL,
61 [EmailConfirmed] bit NOT NULL,
62 [PasswordHash] nvarchar(max) NULL,
63 [SecurityStamp] nvarchar(max) NULL,
64 [ConcurrencyStamp] nvarchar(max) NULL,
65 [PhoneNumber] nvarchar(max) NULL,
66 [PhoneNumberConfirmed] bit NOT NULL,
67 [TwoFactorEnabled] bit NOT NULL,
68 [LockoutEnd] datetimeoffset NULL,
69 [LockoutEnabled] bit NOT NULL,
70 [AccessFailedCount] int NOT NULL,
71 CONSTRAINT [PK_AspNetUsers] PRIMARY KEY ([Id])
72 );
73Microsoft.EntityFrameworkCore.Database.Command[20101]
74 Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
75 CREATE TABLE [Genres] (
76 [ID] int NOT NULL IDENTITY,
77 [Name] nvarchar(50) NOT NULL,
78 CONSTRAINT [PK_Genres] PRIMARY KEY ([ID])
79 );
80Microsoft.EntityFrameworkCore.Database.Command[20101]
81 Executed DbCommand (39ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
82 CREATE TABLE [News] (
83 [Id] int NOT NULL IDENTITY,
84 [DatePosted] datetime2 NOT NULL,
85 [Title] nvarchar(50) NOT NULL,
86 [Text] nvarchar(max) NOT NULL,
87 CONSTRAINT [PK_News] PRIMARY KEY ([Id])
88 );
89Microsoft.EntityFrameworkCore.Database.Command[20101]
90 Executed DbCommand (39ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
91 CREATE TABLE [AspNetRoleClaims] (
92 [Id] int NOT NULL IDENTITY,
93 [RoleId] nvarchar(450) NOT NULL,
94 [ClaimType] nvarchar(max) NULL,
95 [ClaimValue] nvarchar(max) NULL,
96 CONSTRAINT [PK_AspNetRoleClaims] PRIMARY KEY ([Id]),
97 CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [AspNetRoles] ([Id]) ON DELETE CASCADE
98 );
99Microsoft.EntityFrameworkCore.Database.Command[20101]
100 Executed DbCommand (41ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
101 CREATE TABLE [AspNetUserClaims] (
102 [Id] int NOT NULL IDENTITY,
103 [UserId] nvarchar(450) NOT NULL,
104 [ClaimType] nvarchar(max) NULL,
105 [ClaimValue] nvarchar(max) NULL,
106 CONSTRAINT [PK_AspNetUserClaims] PRIMARY KEY ([Id]),
107 CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
108 );
109Microsoft.EntityFrameworkCore.Database.Command[20101]
110 Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
111 CREATE TABLE [AspNetUserLogins] (
112 [LoginProvider] nvarchar(450) NOT NULL,
113 [ProviderKey] nvarchar(450) NOT NULL,
114 [ProviderDisplayName] nvarchar(max) NULL,
115 [UserId] nvarchar(450) NOT NULL,
116 CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY ([LoginProvider], [ProviderKey]),
117 CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
118 );
119Microsoft.EntityFrameworkCore.Database.Command[20101]
120 Executed DbCommand (43ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
121 CREATE TABLE [AspNetUserRoles] (
122 [UserId] nvarchar(450) NOT NULL,
123 [RoleId] nvarchar(450) NOT NULL,
124 CONSTRAINT [PK_AspNetUserRoles] PRIMARY KEY ([UserId], [RoleId]),
125 CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [AspNetRoles] ([Id]) ON DELETE CASCADE,
126 CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
127 );
128Microsoft.EntityFrameworkCore.Database.Command[20101]
129 Executed DbCommand (39ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
130 CREATE TABLE [AspNetUserTokens] (
131 [UserId] nvarchar(450) NOT NULL,
132 [LoginProvider] nvarchar(450) NOT NULL,
133 [Name] nvarchar(450) NOT NULL,
134 [Value] nvarchar(max) NULL,
135 CONSTRAINT [PK_AspNetUserTokens] PRIMARY KEY ([UserId], [LoginProvider], [Name]),
136 CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
137 );
138Microsoft.EntityFrameworkCore.Database.Command[20101]
139 Executed DbCommand (39ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
140 CREATE TABLE [Movies] (
141 [ID] int NOT NULL IDENTITY,
142 [Name] nvarchar(50) NOT NULL,
143 [Duration] int NOT NULL,
144 [Storyline] nvarchar(max) NULL,
145 [Director] nvarchar(50) NOT NULL,
146 [GenreID] int NOT NULL,
147 [Rating] float NOT NULL,
148 [VotesCount] int NOT NULL,
149 [IsDeleted] bit NOT NULL,
150 CONSTRAINT [PK_Movies] PRIMARY KEY ([ID]),
151 CONSTRAINT [FK_Movies_Genres_GenreID] FOREIGN KEY ([GenreID]) REFERENCES [Genres] ([ID]) ON DELETE CASCADE
152 );
153Microsoft.EntityFrameworkCore.Database.Command[20101]
154 Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
155 CREATE TABLE [MovieActor] (
156 [MovieID] int NOT NULL,
157 [ActorID] int NOT NULL,
158 CONSTRAINT [PK_MovieActor] PRIMARY KEY ([MovieID], [ActorID]),
159 CONSTRAINT [FK_MovieActor_Actors_ActorID] FOREIGN KEY ([ActorID]) REFERENCES [Actors] ([ID]) ON DELETE CASCADE,
160 CONSTRAINT [FK_MovieActor_Movies_MovieID] FOREIGN KEY ([MovieID]) REFERENCES [Movies] ([ID]) ON DELETE CASCADE
161 );
162Microsoft.EntityFrameworkCore.Database.Command[20101]
163 Executed DbCommand (40ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
164 CREATE TABLE [UserMovies] (
165 [MovieID] int NOT NULL,
166 [UserID] nvarchar(450) NOT NULL,
167 CONSTRAINT [PK_UserMovies] PRIMARY KEY ([UserID], [MovieID]),
168 CONSTRAINT [FK_UserMovies_Movies_MovieID] FOREIGN KEY ([MovieID]) REFERENCES [Movies] ([ID]) ON DELETE CASCADE,
169 CONSTRAINT [FK_UserMovies_AspNetUsers_UserID] FOREIGN KEY ([UserID]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
170 );
171Microsoft.EntityFrameworkCore.Database.Command[20101]
172 Executed DbCommand (276ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
173 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Actors]'))
174 SET IDENTITY_INSERT [Actors] ON;
175 INSERT INTO [Actors] ([ID], [Name])
176 VALUES (1, N'JeffGoldblum'),
177 (2, N'ChrisEvans'),
178 (3, N'ScarlettJohansson'),
179 (4, N'SandraBullock'),
180 (5, N'JohnnyDepp');
181 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Actors]'))
182 SET IDENTITY_INSERT [Actors] OFF;
183Microsoft.EntityFrameworkCore.Database.Command[20101]
184 Executed DbCommand (204ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
185 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'ConcurrencyStamp', N'Name', N'NormalizedName') AND [object_id] = OBJECT_ID(N'[AspNetRoles]'))
186 SET IDENTITY_INSERT [AspNetRoles] ON;
187 INSERT INTO [AspNetRoles] ([Id], [ConcurrencyStamp], [Name], [NormalizedName])
188 VALUES (N'0e78767e-b4d2-456f-b029-5ad4c454589a', N'6e63ab39-a514-4e99-ba86-296cfe8d15b5', N'Admin', N'ADMIN');
189 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'ConcurrencyStamp', N'Name', N'NormalizedName') AND [object_id] = OBJECT_ID(N'[AspNetRoles]'))
190 SET IDENTITY_INSERT [AspNetRoles] OFF;
191Microsoft.EntityFrameworkCore.Database.Command[20101]
192 Executed DbCommand (252ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
193 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'AccessFailedCount', N'ConcurrencyStamp', N'Email', N'EmailConfirmed', N'LockoutEnabled', N'LockoutEnd', N'NormalizedEmail', N'NormalizedUserName', N'PasswordHash', N'PhoneNumber', N'PhoneNumberConfirmed', N'SecurityStamp', N'TwoFactorEnabled', N'UserName') AND [object_id] = OBJECT_ID(N'[AspNetUsers]'))
194 SET IDENTITY_INSERT [AspNetUsers] ON;
195 INSERT INTO [AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], [Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UserName])
196 VALUES (N'0b8ddcfb-ef03-487b-affb-766611dc9e17', 0, N'b318fa87-5d53-4bc3-8019-23d7aa37da20', N'admin@admin.admin', 0, 0, NULL, N'ADMIN@ADMIN.ADMIN', N'ADMIN', N'AQAAAAEAACcQAAAAEHzP/Ds0oHiv5C7IjlaA+ce9X9hucPveVIL0EgYgT7ScxgYCFnZFsMQQZLRC5BPKLw==', NULL, 0, N'7I2NUNAXILZUAHNGX7TRSNQCNRWCEOSX', 0, N'admin');
197 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'AccessFailedCount', N'ConcurrencyStamp', N'Email', N'EmailConfirmed', N'LockoutEnabled', N'LockoutEnd', N'NormalizedEmail', N'NormalizedUserName', N'PasswordHash', N'PhoneNumber', N'PhoneNumberConfirmed', N'SecurityStamp', N'TwoFactorEnabled', N'UserName') AND [object_id] = OBJECT_ID(N'[AspNetUsers]'))
198 SET IDENTITY_INSERT [AspNetUsers] OFF;
199Microsoft.EntityFrameworkCore.Database.Command[20101]
200 Executed DbCommand (109ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
201 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Genres]'))
202 SET IDENTITY_INSERT [Genres] ON;
203 INSERT INTO [Genres] ([ID], [Name])
204 VALUES (1, N'Horror'),
205 (2, N'Psycho'),
206 (3, N'Fantasy');
207 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Genres]'))
208 SET IDENTITY_INSERT [Genres] OFF;
209Microsoft.EntityFrameworkCore.Database.Command[20101]
210 Executed DbCommand (186ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
211 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'DatePosted', N'Text', N'Title') AND [object_id] = OBJECT_ID(N'[News]'))
212 SET IDENTITY_INSERT [News] ON;
213 INSERT INTO [News] ([Id], [DatePosted], [Text], [Title])
214 VALUES (1, '2019-04-08T05:12:56.5110000Z', N'This year will mark the last Avengers movie', N'Avengers'),
215 (2, '2012-12-21T12:00:56.5110000Z', N'According to Maya''s people today will be the day the world ends. There will be no more movies', N'WorldEnds'),
216 (3, '2018-11-12T04:13:56.5110000Z', N'Manchester lost to Barca on Old Trafford.', N'ManchesterLost'),
217 (4, '2019-04-10T23:52:56.5110000Z', N'Tickets have been soldout for the premirer of Shazam', N'TicketsSoldout');
218 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'DatePosted', N'Text', N'Title') AND [object_id] = OBJECT_ID(N'[News]'))
219 SET IDENTITY_INSERT [News] OFF;
220Microsoft.EntityFrameworkCore.Database.Command[20101]
221 Executed DbCommand (158ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
222 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UserId', N'RoleId') AND [object_id] = OBJECT_ID(N'[AspNetUserRoles]'))
223 SET IDENTITY_INSERT [AspNetUserRoles] ON;
224 INSERT INTO [AspNetUserRoles] ([UserId], [RoleId])
225 VALUES (N'0b8ddcfb-ef03-487b-affb-766611dc9e17', N'0e78767e-b4d2-456f-b029-5ad4c454589a');
226 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UserId', N'RoleId') AND [object_id] = OBJECT_ID(N'[AspNetUserRoles]'))
227 SET IDENTITY_INSERT [AspNetUserRoles] OFF;
228Microsoft.EntityFrameworkCore.Database.Command[20101]
229 Executed DbCommand (309ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
230 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Director', N'Duration', N'GenreID', N'IsDeleted', N'Name', N'Rating', N'Storyline', N'VotesCount') AND [object_id] = OBJECT_ID(N'[Movies]'))
231 SET IDENTITY_INSERT [Movies] ON;
232 INSERT INTO [Movies] ([ID], [Director], [Duration], [GenreID], [IsDeleted], [Name], [Rating], [Storyline], [VotesCount])
233 VALUES (2, N'Guy Ritchie', 120, 1, 0, N'Aladdin', 0.0E0, N'A kindhearted Arabian street urchin and a power-hungry Grand Vizier vie for a magic lamp that has the power to make the deepest wishes come true.', 0),
234 (1, N'Anna Boden', 90, 2, 0, N'Marvel', 0.0E0, N'Carol Danvers becomes one of the universe''s most powerful heroes when Earth is caught in the middle of a galactic war between two alien races.', 0),
235 (3, N'Travis Knight', 90, 2, 0, N'Bumblebee', 0.0E0, N'On the run in the year of 1987, Bumblebee finds refuge in a junkyard in a small Californian beach town. Charlie, on the cusp of turning 18 and trying to find her place in the world, discovers Bumblebee, battle-scarred and broken.', 0);
236 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Director', N'Duration', N'GenreID', N'IsDeleted', N'Name', N'Rating', N'Storyline', N'VotesCount') AND [object_id] = OBJECT_ID(N'[Movies]'))
237 SET IDENTITY_INSERT [Movies] OFF;
238Microsoft.EntityFrameworkCore.Database.Command[20101]
239 Executed DbCommand (36ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
240 CREATE INDEX [IX_AspNetRoleClaims_RoleId] ON [AspNetRoleClaims] ([RoleId]);
241Microsoft.EntityFrameworkCore.Database.Command[20101]
242 Executed DbCommand (54ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
243 CREATE UNIQUE INDEX [RoleNameIndex] ON [AspNetRoles] ([NormalizedName]) WHERE [NormalizedName] IS NOT NULL;
244Microsoft.EntityFrameworkCore.Database.Command[20101]
245 Executed DbCommand (36ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
246 CREATE INDEX [IX_AspNetUserClaims_UserId] ON [AspNetUserClaims] ([UserId]);
247Microsoft.EntityFrameworkCore.Database.Command[20101]
248 Executed DbCommand (36ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
249 CREATE INDEX [IX_AspNetUserLogins_UserId] ON [AspNetUserLogins] ([UserId]);
250Microsoft.EntityFrameworkCore.Database.Command[20101]
251 Executed DbCommand (38ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
252 CREATE INDEX [IX_AspNetUserRoles_RoleId] ON [AspNetUserRoles] ([RoleId]);
253Microsoft.EntityFrameworkCore.Database.Command[20101]
254 Executed DbCommand (58ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
255 CREATE INDEX [EmailIndex] ON [AspNetUsers] ([NormalizedEmail]);
256Microsoft.EntityFrameworkCore.Database.Command[20101]
257 Executed DbCommand (39ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
258 CREATE UNIQUE INDEX [UserNameIndex] ON [AspNetUsers] ([NormalizedUserName]) WHERE [NormalizedUserName] IS NOT NULL;
259Microsoft.EntityFrameworkCore.Database.Command[20101]
260 Executed DbCommand (37ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
261 CREATE INDEX [IX_MovieActor_ActorID] ON [MovieActor] ([ActorID]);
262Microsoft.EntityFrameworkCore.Database.Command[20101]
263 Executed DbCommand (120ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
264 CREATE INDEX [IX_Movies_GenreID] ON [Movies] ([GenreID]);
265Microsoft.EntityFrameworkCore.Database.Command[20101]
266 Executed DbCommand (42ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
267 CREATE INDEX [IX_UserMovies_MovieID] ON [UserMovies] ([MovieID]);
268Microsoft.EntityFrameworkCore.Database.Command[20101]
269 Executed DbCommand (37ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
270 INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
271 VALUES (N'20190430165038_Initial', N'2.2.4-servicing-10062');
272Done.
273PM> add-migration MovieActorJson
274Build failed.
275PM> add-migration MovieActorJson
276Build failed.
277PM> add-migration MovieActorJson
278System.InvalidOperationException: The relationship from 'ApplicationUserMovie.Movie' to 'Movie.ApplicationUserMovie' with foreign key properties {'MovieID' : int} cannot target the primary key {'Id' : string} because it is not compatible. Configure a principal key or a set of compatible foreign key properties for this relationship.
279 at Microsoft.EntityFrameworkCore.Infrastructure.ModelValidator.ValidateNoShadowKeys(IModel model)
280 at Microsoft.EntityFrameworkCore.Infrastructure.ModelValidator.Validate(IModel model)
281 at Microsoft.EntityFrameworkCore.Infrastructure.RelationalModelValidator.Validate(IModel model)
282 at Microsoft.EntityFrameworkCore.Internal.SqlServerModelValidator.Validate(IModel model)
283 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ValidatingConvention.Apply(InternalModelBuilder modelBuilder)
284 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnModelBuilt(InternalModelBuilder modelBuilder)
285 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.OnModelBuilt(InternalModelBuilder modelBuilder)
286 at Microsoft.EntityFrameworkCore.Metadata.Internal.Model.Validate()
287 at Microsoft.EntityFrameworkCore.ModelBuilder.FinalizeModel()
288 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.CreateModel(DbContext context, IConventionSetBuilder conventionSetBuilder, IModelValidator validator)
289 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.<>c__DisplayClass5_0.<GetModel>b__1()
290 at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
291 at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
292 at System.Lazy`1.CreateValue()
293 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.GetModel(DbContext context, IConventionSetBuilder conventionSetBuilder, IModelValidator validator)
294 at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
295 at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
296 at Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkServicesBuilder.<>c.<TryAddCoreServices>b__7_2(IServiceProvider p)
297 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, ServiceProviderEngineScope scope)
298 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
299 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)
300 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
301 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, ServiceProviderEngineScope scope)
302 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
303 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)
304 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
305 at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
306 at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
307 at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
308 at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
309 at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
310 at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
311 at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
312 at Microsoft.EntityFrameworkCore.DbContext.Microsoft.EntityFrameworkCore.Infrastructure.IInfrastructure<System.IServiceProvider>.get_Instance()
313 at Microsoft.EntityFrameworkCore.Internal.InternalAccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
314 at Microsoft.EntityFrameworkCore.Infrastructure.AccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
315 at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(Func`1 factory)
316 at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(String contextType)
317 at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.AddMigration(String name, String outputDir, String contextType)
318 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigrationImpl(String name, String outputDir, String contextType)
319 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigration.<>c__DisplayClass0_1.<.ctor>b__0()
320 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
321 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
322The relationship from 'ApplicationUserMovie.Movie' to 'Movie.ApplicationUserMovie' with foreign key properties {'MovieID' : int} cannot target the primary key {'Id' : string} because it is not compatible. Configure a principal key or a set of compatible foreign key properties for this relationship.
323PM> add-migration MovieActorJson
324System.InvalidOperationException: The seed entity for entity type 'Actor' cannot be added because another seed entity with the same key value for {'Id'} has already been added. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see the conflicting key values.
325 at Microsoft.EntityFrameworkCore.Infrastructure.ModelValidator.ValidateData(IModel model)
326 at Microsoft.EntityFrameworkCore.Infrastructure.ModelValidator.Validate(IModel model)
327 at Microsoft.EntityFrameworkCore.Infrastructure.RelationalModelValidator.Validate(IModel model)
328 at Microsoft.EntityFrameworkCore.Internal.SqlServerModelValidator.Validate(IModel model)
329 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ValidatingConvention.Apply(InternalModelBuilder modelBuilder)
330 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.ImmediateConventionScope.OnModelBuilt(InternalModelBuilder modelBuilder)
331 at Microsoft.EntityFrameworkCore.Metadata.Conventions.Internal.ConventionDispatcher.OnModelBuilt(InternalModelBuilder modelBuilder)
332 at Microsoft.EntityFrameworkCore.Metadata.Internal.Model.Validate()
333 at Microsoft.EntityFrameworkCore.ModelBuilder.FinalizeModel()
334 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.CreateModel(DbContext context, IConventionSetBuilder conventionSetBuilder, IModelValidator validator)
335 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.<>c__DisplayClass5_0.<GetModel>b__1()
336 at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
337 at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
338 at System.Lazy`1.CreateValue()
339 at Microsoft.EntityFrameworkCore.Infrastructure.ModelSource.GetModel(DbContext context, IConventionSetBuilder conventionSetBuilder, IModelValidator validator)
340 at Microsoft.EntityFrameworkCore.Internal.DbContextServices.CreateModel()
341 at Microsoft.EntityFrameworkCore.Internal.DbContextServices.get_Model()
342 at Microsoft.EntityFrameworkCore.Infrastructure.EntityFrameworkServicesBuilder.<>c.<TryAddCoreServices>b__7_2(IServiceProvider p)
343 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitFactory(FactoryCallSite factoryCallSite, ServiceProviderEngineScope scope)
344 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
345 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)
346 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
347 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, ServiceProviderEngineScope scope)
348 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
349 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)
350 at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
351 at Microsoft.Extensions.DependencyInjection.ServiceLookup.DynamicServiceProviderEngine.<>c__DisplayClass1_0.<RealizeService>b__0(ServiceProviderEngineScope scope)
352 at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngine.GetService(Type serviceType, ServiceProviderEngineScope serviceProviderEngineScope)
353 at Microsoft.Extensions.DependencyInjection.ServiceLookup.ServiceProviderEngineScope.GetService(Type serviceType)
354 at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService(IServiceProvider provider, Type serviceType)
355 at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetRequiredService[T](IServiceProvider provider)
356 at Microsoft.EntityFrameworkCore.DbContext.get_DbContextDependencies()
357 at Microsoft.EntityFrameworkCore.DbContext.get_InternalServiceProvider()
358 at Microsoft.EntityFrameworkCore.DbContext.Microsoft.EntityFrameworkCore.Infrastructure.IInfrastructure<System.IServiceProvider>.get_Instance()
359 at Microsoft.EntityFrameworkCore.Internal.InternalAccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
360 at Microsoft.EntityFrameworkCore.Infrastructure.AccessorExtensions.GetService[TService](IInfrastructure`1 accessor)
361 at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(Func`1 factory)
362 at Microsoft.EntityFrameworkCore.Design.Internal.DbContextOperations.CreateContext(String contextType)
363 at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.AddMigration(String name, String outputDir, String contextType)
364 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigrationImpl(String name, String outputDir, String contextType)
365 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.AddMigration.<>c__DisplayClass0_1.<.ctor>b__0()
366 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.<>c__DisplayClass3_0`1.<Execute>b__0()
367 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
368The seed entity for entity type 'Actor' cannot be added because another seed entity with the same key value for {'Id'} has already been added. Consider using 'DbContextOptionsBuilder.EnableSensitiveDataLogging' to see the conflicting key values.
369PM> add-migration MovieActorJson
370Microsoft.EntityFrameworkCore.Infrastructure[10403]
371 Entity Framework Core 2.2.4-servicing-10062 initialized 'MovieManagementContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
372An operation was scaffolded that may result in the loss of data. Please review the migration for accuracy.
373To undo this action, use Remove-Migration.
374PM> update-database
375Microsoft.EntityFrameworkCore.Infrastructure[10403]
376 Entity Framework Core 2.2.4-servicing-10062 initialized 'MovieManagementContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
377Microsoft.EntityFrameworkCore.Database.Command[20101]
378 Executed DbCommand (179ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
379 CREATE DATABASE [WebMovieManagement];
380Microsoft.EntityFrameworkCore.Database.Command[20101]
381 Executed DbCommand (53ms) [Parameters=[], CommandType='Text', CommandTimeout='60']
382 IF SERVERPROPERTY('EngineEdition') <> 5
383 BEGIN
384 ALTER DATABASE [WebMovieManagement] SET READ_COMMITTED_SNAPSHOT ON;
385 END;
386Microsoft.EntityFrameworkCore.Database.Command[20101]
387 Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
388 CREATE TABLE [__EFMigrationsHistory] (
389 [MigrationId] nvarchar(150) NOT NULL,
390 [ProductVersion] nvarchar(32) NOT NULL,
391 CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY ([MigrationId])
392 );
393Microsoft.EntityFrameworkCore.Database.Command[20101]
394 Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
395 SELECT OBJECT_ID(N'[__EFMigrationsHistory]');
396Microsoft.EntityFrameworkCore.Database.Command[20101]
397 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
398 SELECT [MigrationId], [ProductVersion]
399 FROM [__EFMigrationsHistory]
400 ORDER BY [MigrationId];
401Applying migration '20190430165038_Initial'.
402Microsoft.EntityFrameworkCore.Migrations[20402]
403 Applying migration '20190430165038_Initial'.
404Microsoft.EntityFrameworkCore.Database.Command[20101]
405 Executed DbCommand (5ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
406 CREATE TABLE [Actors] (
407 [ID] int NOT NULL IDENTITY,
408 [Name] nvarchar(50) NOT NULL,
409 CONSTRAINT [PK_Actors] PRIMARY KEY ([ID])
410 );
411Microsoft.EntityFrameworkCore.Database.Command[20101]
412 Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
413 CREATE TABLE [AspNetRoles] (
414 [Id] nvarchar(450) NOT NULL,
415 [Name] nvarchar(256) NULL,
416 [NormalizedName] nvarchar(256) NULL,
417 [ConcurrencyStamp] nvarchar(max) NULL,
418 CONSTRAINT [PK_AspNetRoles] PRIMARY KEY ([Id])
419 );
420Microsoft.EntityFrameworkCore.Database.Command[20101]
421 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
422 CREATE TABLE [AspNetUsers] (
423 [Id] nvarchar(450) NOT NULL,
424 [UserName] nvarchar(50) NOT NULL,
425 [NormalizedUserName] nvarchar(256) NULL,
426 [Email] nvarchar(256) NULL,
427 [NormalizedEmail] nvarchar(256) NULL,
428 [EmailConfirmed] bit NOT NULL,
429 [PasswordHash] nvarchar(max) NULL,
430 [SecurityStamp] nvarchar(max) NULL,
431 [ConcurrencyStamp] nvarchar(max) NULL,
432 [PhoneNumber] nvarchar(max) NULL,
433 [PhoneNumberConfirmed] bit NOT NULL,
434 [TwoFactorEnabled] bit NOT NULL,
435 [LockoutEnd] datetimeoffset NULL,
436 [LockoutEnabled] bit NOT NULL,
437 [AccessFailedCount] int NOT NULL,
438 CONSTRAINT [PK_AspNetUsers] PRIMARY KEY ([Id])
439 );
440Microsoft.EntityFrameworkCore.Database.Command[20101]
441 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
442 CREATE TABLE [Genres] (
443 [ID] int NOT NULL IDENTITY,
444 [Name] nvarchar(50) NOT NULL,
445 CONSTRAINT [PK_Genres] PRIMARY KEY ([ID])
446 );
447Microsoft.EntityFrameworkCore.Database.Command[20101]
448 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
449 CREATE TABLE [News] (
450 [Id] int NOT NULL IDENTITY,
451 [DatePosted] datetime2 NOT NULL,
452 [Title] nvarchar(50) NOT NULL,
453 [Text] nvarchar(max) NOT NULL,
454 CONSTRAINT [PK_News] PRIMARY KEY ([Id])
455 );
456Microsoft.EntityFrameworkCore.Database.Command[20101]
457 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
458 CREATE TABLE [AspNetRoleClaims] (
459 [Id] int NOT NULL IDENTITY,
460 [RoleId] nvarchar(450) NOT NULL,
461 [ClaimType] nvarchar(max) NULL,
462 [ClaimValue] nvarchar(max) NULL,
463 CONSTRAINT [PK_AspNetRoleClaims] PRIMARY KEY ([Id]),
464 CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [AspNetRoles] ([Id]) ON DELETE CASCADE
465 );
466Microsoft.EntityFrameworkCore.Database.Command[20101]
467 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
468 CREATE TABLE [AspNetUserClaims] (
469 [Id] int NOT NULL IDENTITY,
470 [UserId] nvarchar(450) NOT NULL,
471 [ClaimType] nvarchar(max) NULL,
472 [ClaimValue] nvarchar(max) NULL,
473 CONSTRAINT [PK_AspNetUserClaims] PRIMARY KEY ([Id]),
474 CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
475 );
476Microsoft.EntityFrameworkCore.Database.Command[20101]
477 Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
478 CREATE TABLE [AspNetUserLogins] (
479 [LoginProvider] nvarchar(450) NOT NULL,
480 [ProviderKey] nvarchar(450) NOT NULL,
481 [ProviderDisplayName] nvarchar(max) NULL,
482 [UserId] nvarchar(450) NOT NULL,
483 CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY ([LoginProvider], [ProviderKey]),
484 CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
485 );
486Microsoft.EntityFrameworkCore.Database.Command[20101]
487 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
488 CREATE TABLE [AspNetUserRoles] (
489 [UserId] nvarchar(450) NOT NULL,
490 [RoleId] nvarchar(450) NOT NULL,
491 CONSTRAINT [PK_AspNetUserRoles] PRIMARY KEY ([UserId], [RoleId]),
492 CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [AspNetRoles] ([Id]) ON DELETE CASCADE,
493 CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
494 );
495Microsoft.EntityFrameworkCore.Database.Command[20101]
496 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
497 CREATE TABLE [AspNetUserTokens] (
498 [UserId] nvarchar(450) NOT NULL,
499 [LoginProvider] nvarchar(450) NOT NULL,
500 [Name] nvarchar(450) NOT NULL,
501 [Value] nvarchar(max) NULL,
502 CONSTRAINT [PK_AspNetUserTokens] PRIMARY KEY ([UserId], [LoginProvider], [Name]),
503 CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId] FOREIGN KEY ([UserId]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
504 );
505Microsoft.EntityFrameworkCore.Database.Command[20101]
506 Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
507 CREATE TABLE [Movies] (
508 [ID] int NOT NULL IDENTITY,
509 [Name] nvarchar(50) NOT NULL,
510 [Duration] int NOT NULL,
511 [Storyline] nvarchar(max) NULL,
512 [Director] nvarchar(50) NOT NULL,
513 [GenreID] int NOT NULL,
514 [Rating] float NOT NULL,
515 [VotesCount] int NOT NULL,
516 [IsDeleted] bit NOT NULL,
517 CONSTRAINT [PK_Movies] PRIMARY KEY ([ID]),
518 CONSTRAINT [FK_Movies_Genres_GenreID] FOREIGN KEY ([GenreID]) REFERENCES [Genres] ([ID]) ON DELETE CASCADE
519 );
520Microsoft.EntityFrameworkCore.Database.Command[20101]
521 Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
522 CREATE TABLE [MovieActor] (
523 [MovieID] int NOT NULL,
524 [ActorID] int NOT NULL,
525 CONSTRAINT [PK_MovieActor] PRIMARY KEY ([MovieID], [ActorID]),
526 CONSTRAINT [FK_MovieActor_Actors_ActorID] FOREIGN KEY ([ActorID]) REFERENCES [Actors] ([ID]) ON DELETE CASCADE,
527 CONSTRAINT [FK_MovieActor_Movies_MovieID] FOREIGN KEY ([MovieID]) REFERENCES [Movies] ([ID]) ON DELETE CASCADE
528 );
529Microsoft.EntityFrameworkCore.Database.Command[20101]
530 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
531 CREATE TABLE [UserMovies] (
532 [MovieID] int NOT NULL,
533 [UserID] nvarchar(450) NOT NULL,
534 CONSTRAINT [PK_UserMovies] PRIMARY KEY ([UserID], [MovieID]),
535 CONSTRAINT [FK_UserMovies_Movies_MovieID] FOREIGN KEY ([MovieID]) REFERENCES [Movies] ([ID]) ON DELETE CASCADE,
536 CONSTRAINT [FK_UserMovies_AspNetUsers_UserID] FOREIGN KEY ([UserID]) REFERENCES [AspNetUsers] ([Id]) ON DELETE CASCADE
537 );
538Microsoft.EntityFrameworkCore.Database.Command[20101]
539 Executed DbCommand (35ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
540 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Actors]'))
541 SET IDENTITY_INSERT [Actors] ON;
542 INSERT INTO [Actors] ([ID], [Name])
543 VALUES (1, N'JeffGoldblum'),
544 (2, N'ChrisEvans'),
545 (3, N'ScarlettJohansson'),
546 (4, N'SandraBullock'),
547 (5, N'JohnnyDepp');
548 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Actors]'))
549 SET IDENTITY_INSERT [Actors] OFF;
550Microsoft.EntityFrameworkCore.Database.Command[20101]
551 Executed DbCommand (8ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
552 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'ConcurrencyStamp', N'Name', N'NormalizedName') AND [object_id] = OBJECT_ID(N'[AspNetRoles]'))
553 SET IDENTITY_INSERT [AspNetRoles] ON;
554 INSERT INTO [AspNetRoles] ([Id], [ConcurrencyStamp], [Name], [NormalizedName])
555 VALUES (N'0e78767e-b4d2-456f-b029-5ad4c454589a', N'6e63ab39-a514-4e99-ba86-296cfe8d15b5', N'Admin', N'ADMIN');
556 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'ConcurrencyStamp', N'Name', N'NormalizedName') AND [object_id] = OBJECT_ID(N'[AspNetRoles]'))
557 SET IDENTITY_INSERT [AspNetRoles] OFF;
558Microsoft.EntityFrameworkCore.Database.Command[20101]
559 Executed DbCommand (10ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
560 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'AccessFailedCount', N'ConcurrencyStamp', N'Email', N'EmailConfirmed', N'LockoutEnabled', N'LockoutEnd', N'NormalizedEmail', N'NormalizedUserName', N'PasswordHash', N'PhoneNumber', N'PhoneNumberConfirmed', N'SecurityStamp', N'TwoFactorEnabled', N'UserName') AND [object_id] = OBJECT_ID(N'[AspNetUsers]'))
561 SET IDENTITY_INSERT [AspNetUsers] ON;
562 INSERT INTO [AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], [Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], [NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], [SecurityStamp], [TwoFactorEnabled], [UserName])
563 VALUES (N'0b8ddcfb-ef03-487b-affb-766611dc9e17', 0, N'b318fa87-5d53-4bc3-8019-23d7aa37da20', N'admin@admin.admin', 0, 0, NULL, N'ADMIN@ADMIN.ADMIN', N'ADMIN', N'AQAAAAEAACcQAAAAEHzP/Ds0oHiv5C7IjlaA+ce9X9hucPveVIL0EgYgT7ScxgYCFnZFsMQQZLRC5BPKLw==', NULL, 0, N'7I2NUNAXILZUAHNGX7TRSNQCNRWCEOSX', 0, N'admin');
564 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'AccessFailedCount', N'ConcurrencyStamp', N'Email', N'EmailConfirmed', N'LockoutEnabled', N'LockoutEnd', N'NormalizedEmail', N'NormalizedUserName', N'PasswordHash', N'PhoneNumber', N'PhoneNumberConfirmed', N'SecurityStamp', N'TwoFactorEnabled', N'UserName') AND [object_id] = OBJECT_ID(N'[AspNetUsers]'))
565 SET IDENTITY_INSERT [AspNetUsers] OFF;
566Microsoft.EntityFrameworkCore.Database.Command[20101]
567 Executed DbCommand (9ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
568 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Genres]'))
569 SET IDENTITY_INSERT [Genres] ON;
570 INSERT INTO [Genres] ([ID], [Name])
571 VALUES (1, N'Horror'),
572 (2, N'Psycho'),
573 (3, N'Fantasy');
574 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Name') AND [object_id] = OBJECT_ID(N'[Genres]'))
575 SET IDENTITY_INSERT [Genres] OFF;
576Microsoft.EntityFrameworkCore.Database.Command[20101]
577 Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
578 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'DatePosted', N'Text', N'Title') AND [object_id] = OBJECT_ID(N'[News]'))
579 SET IDENTITY_INSERT [News] ON;
580 INSERT INTO [News] ([Id], [DatePosted], [Text], [Title])
581 VALUES (1, '2019-04-08T05:12:56.5110000Z', N'This year will mark the last Avengers movie', N'Avengers'),
582 (2, '2012-12-21T12:00:56.5110000Z', N'According to Maya''s people today will be the day the world ends. There will be no more movies', N'WorldEnds'),
583 (3, '2018-11-12T04:13:56.5110000Z', N'Manchester lost to Barca on Old Trafford.', N'ManchesterLost'),
584 (4, '2019-04-10T23:52:56.5110000Z', N'Tickets have been soldout for the premirer of Shazam', N'TicketsSoldout');
585 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'Id', N'DatePosted', N'Text', N'Title') AND [object_id] = OBJECT_ID(N'[News]'))
586 SET IDENTITY_INSERT [News] OFF;
587Microsoft.EntityFrameworkCore.Database.Command[20101]
588 Executed DbCommand (15ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
589 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UserId', N'RoleId') AND [object_id] = OBJECT_ID(N'[AspNetUserRoles]'))
590 SET IDENTITY_INSERT [AspNetUserRoles] ON;
591 INSERT INTO [AspNetUserRoles] ([UserId], [RoleId])
592 VALUES (N'0b8ddcfb-ef03-487b-affb-766611dc9e17', N'0e78767e-b4d2-456f-b029-5ad4c454589a');
593 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'UserId', N'RoleId') AND [object_id] = OBJECT_ID(N'[AspNetUserRoles]'))
594 SET IDENTITY_INSERT [AspNetUserRoles] OFF;
595Microsoft.EntityFrameworkCore.Database.Command[20101]
596 Executed DbCommand (14ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
597 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Director', N'Duration', N'GenreID', N'IsDeleted', N'Name', N'Rating', N'Storyline', N'VotesCount') AND [object_id] = OBJECT_ID(N'[Movies]'))
598 SET IDENTITY_INSERT [Movies] ON;
599 INSERT INTO [Movies] ([ID], [Director], [Duration], [GenreID], [IsDeleted], [Name], [Rating], [Storyline], [VotesCount])
600 VALUES (2, N'Guy Ritchie', 120, 1, 0, N'Aladdin', 0.0E0, N'A kindhearted Arabian street urchin and a power-hungry Grand Vizier vie for a magic lamp that has the power to make the deepest wishes come true.', 0),
601 (1, N'Anna Boden', 90, 2, 0, N'Marvel', 0.0E0, N'Carol Danvers becomes one of the universe''s most powerful heroes when Earth is caught in the middle of a galactic war between two alien races.', 0),
602 (3, N'Travis Knight', 90, 2, 0, N'Bumblebee', 0.0E0, N'On the run in the year of 1987, Bumblebee finds refuge in a junkyard in a small Californian beach town. Charlie, on the cusp of turning 18 and trying to find her place in the world, discovers Bumblebee, battle-scarred and broken.', 0);
603 IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ID', N'Director', N'Duration', N'GenreID', N'IsDeleted', N'Name', N'Rating', N'Storyline', N'VotesCount') AND [object_id] = OBJECT_ID(N'[Movies]'))
604 SET IDENTITY_INSERT [Movies] OFF;
605Microsoft.EntityFrameworkCore.Database.Command[20101]
606 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
607 CREATE INDEX [IX_AspNetRoleClaims_RoleId] ON [AspNetRoleClaims] ([RoleId]);
608Microsoft.EntityFrameworkCore.Database.Command[20101]
609 Executed DbCommand (22ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
610 CREATE UNIQUE INDEX [RoleNameIndex] ON [AspNetRoles] ([NormalizedName]) WHERE [NormalizedName] IS NOT NULL;
611Microsoft.EntityFrameworkCore.Database.Command[20101]
612 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
613 CREATE INDEX [IX_AspNetUserClaims_UserId] ON [AspNetUserClaims] ([UserId]);
614Microsoft.EntityFrameworkCore.Database.Command[20101]
615 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
616 CREATE INDEX [IX_AspNetUserLogins_UserId] ON [AspNetUserLogins] ([UserId]);
617Microsoft.EntityFrameworkCore.Database.Command[20101]
618 Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
619 CREATE INDEX [IX_AspNetUserRoles_RoleId] ON [AspNetUserRoles] ([RoleId]);
620Microsoft.EntityFrameworkCore.Database.Command[20101]
621 Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
622 CREATE INDEX [EmailIndex] ON [AspNetUsers] ([NormalizedEmail]);
623Microsoft.EntityFrameworkCore.Database.Command[20101]
624 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
625 CREATE UNIQUE INDEX [UserNameIndex] ON [AspNetUsers] ([NormalizedUserName]) WHERE [NormalizedUserName] IS NOT NULL;
626Microsoft.EntityFrameworkCore.Database.Command[20101]
627 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
628 CREATE INDEX [IX_MovieActor_ActorID] ON [MovieActor] ([ActorID]);
629Microsoft.EntityFrameworkCore.Database.Command[20101]
630 Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
631 CREATE INDEX [IX_Movies_GenreID] ON [Movies] ([GenreID]);
632Microsoft.EntityFrameworkCore.Database.Command[20101]
633 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
634 CREATE INDEX [IX_UserMovies_MovieID] ON [UserMovies] ([MovieID]);
635Microsoft.EntityFrameworkCore.Database.Command[20101]
636 Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
637 INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
638 VALUES (N'20190430165038_Initial', N'2.2.4-servicing-10062');
639Applying migration '20190430223030_MovieActorJson'.
640Microsoft.EntityFrameworkCore.Migrations[20402]
641 Applying migration '20190430223030_MovieActorJson'.
642System.InvalidOperationException: To change the IDENTITY property of a column, the column needs to be dropped and recreated.
643 at Microsoft.EntityFrameworkCore.Migrations.SqlServerMigrationsSqlGenerator.Generate(AlterColumnOperation operation, IModel model, MigrationCommandListBuilder builder)
644 at Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.<>c.<.cctor>b__73_4(MigrationsSqlGenerator g, MigrationOperation o, IModel m, MigrationCommandListBuilder b)
645 at Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.Generate(MigrationOperation operation, IModel model, MigrationCommandListBuilder builder)
646 at Microsoft.EntityFrameworkCore.Migrations.SqlServerMigrationsSqlGenerator.Generate(MigrationOperation operation, IModel model, MigrationCommandListBuilder builder)
647 at Microsoft.EntityFrameworkCore.Migrations.MigrationsSqlGenerator.Generate(IReadOnlyList`1 operations, IModel model)
648 at Microsoft.EntityFrameworkCore.Migrations.SqlServerMigrationsSqlGenerator.Generate(IReadOnlyList`1 operations, IModel model)
649 at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.GenerateUpSql(Migration migration)
650 at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.<>c__DisplayClass13_2.<GetMigrationCommandLists>b__2()
651 at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
652 at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType)
653 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_1.<.ctor>b__0()
654 at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
655To change the IDENTITY property of a column, the column needs to be dropped and recreated.
656PM>