Advertisement
otkalce

Entity Framework example - data

Apr 5th, 2023 (edited)
557
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 2.25 KB | Source Code | 0 0
  1. SET IDENTITY_INSERT [dbo].[Tag] ON
  2. GO
  3. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (1, N'listening')
  4. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (2, N'radio')
  5. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (3, N'music')
  6. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (4, N'event')
  7. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (8, N'beat')
  8. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (9, N'producer')
  9. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (10, N'art')
  10. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (11, N'style')
  11. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (12, N'nowplaying')
  12. INSERT [dbo].[Tag] ([Id], [Name]) VALUES (13, N'video')
  13. GO
  14. SET IDENTITY_INSERT [dbo].[Tag] OFF
  15. GO
  16.  
  17. SET IDENTITY_INSERT [dbo].[Genre] ON
  18. GO
  19. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (1, N'Pop')
  20. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (2, N'Hip-hop')
  21. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (3, N'Rock')
  22. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (4, N'Jazz')
  23. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (5, N'Dance')
  24. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (6, N'Dubstep')
  25. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (7, N'Electro')
  26. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (8, N'R&B')
  27. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (9, N'Country')
  28. INSERT [dbo].[Genre] ([Id], [Name]) VALUES (10, N'Indie')
  29. GO
  30. SET IDENTITY_INSERT [dbo].[Genre] OFF
  31. GO
  32.  
  33. SET IDENTITY_INSERT [dbo].[Audio] ON
  34. GO
  35. INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url]) VALUES (2, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'Maroon 5 – Moves Like Jagger (feat. Christina Aguilera)', 1, 278, N'https://www.youtube.com/watch?v=iEPTlhBmwRg')
  36. INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url]) VALUES (3, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'Sia - The Greatest', 7, 351, N'https://www.youtube.com/watch?v=GKSRyLdjsPA')
  37. INSERT [dbo].[Audio] ([Id], [CreatedAt], [Title], [GenreId], [Duration], [Url]) VALUES (4, CAST(N'2023-04-05T00:00:00.0000000' AS DateTime2), N'Editors - All The Kings', 10, 310, N'https://www.youtube.com/watch?v=d2oSgaRb9Bg')
  38. SET IDENTITY_INSERT [dbo].[Audio] OFF
  39. GO
  40.  
  41. SET IDENTITY_INSERT [dbo].[AudioTag] ON
  42. GO
  43. INSERT [dbo].[AudioTag] ([Id], [AudioId], [TagId]) VALUES (1, 3, 12)
  44. GO
  45. SET IDENTITY_INSERT [dbo].[AudioTag] OFF
  46. GO
  47.  
Tags: ef-example
Advertisement
Comments
Add Comment
Please, Sign In to add comment
Advertisement