// using HomeLibrary.Api.Data; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; #nullable disable namespace HomeLibrary.Api.Migrations { [DbContext(typeof(HomeLibraryDbContext))] [Migration("20220928192937_InitialCreate")] partial class InitialCreate { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("ProductVersion", "6.0.9") .HasAnnotation("Relational:MaxIdentifierLength", 128); SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1); modelBuilder.Entity("HomeLibrary.Api.Entities.Author", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("Name") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Authors"); b.HasData( new { Id = 1, Name = "Glen Cook" }, new { Id = 2, Name = "William Shakespeare" }, new { Id = 3, Name = "John Grisham" }, new { Id = 4, Name = "Douglas Adams" }, new { Id = 5, Name = "Piers Anthony" }, new { Id = 6, Name = "Kevin J. Anderson" }, new { Id = 7, Name = "Geoffrey Chaucer" }, new { Id = 8, Name = "L. M. Montgomery" }, new { Id = 9, Name = "Patricia Miles Martin" }); }); modelBuilder.Entity("HomeLibrary.Api.Entities.Book", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int"); SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property("Id"), 1L, 1); b.Property("AuthorId") .HasColumnType("int"); b.Property("BookNumber") .HasColumnType("int"); b.Property("Series") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("Title") .IsRequired() .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Books"); b.HasData( new { Id = 1, AuthorId = 1, BookNumber = 1, Series = "The Black Company", Title = "Chronicles of The Black Company" }, new { Id = 2, AuthorId = 1, BookNumber = 2, Series = "The Black Company", Title = "Port of Shadows" }, new { Id = 3, AuthorId = 2, BookNumber = 1, Series = "None", Title = "The Complete Works of William Shakespeare" }, new { Id = 4, AuthorId = 3, BookNumber = 1, Series = "None", Title = "The Client" }, new { Id = 5, AuthorId = 3, BookNumber = 1, Series = "None", Title = "Sooley" }, new { Id = 6, AuthorId = 3, BookNumber = 3, Series = "Theodore Boone", Title = "Theodore Boone: The Accused" }, new { Id = 7, AuthorId = 4, BookNumber = 1, Series = "None", Title = "The Hitchhiker's Guide to the Galaxy" }, new { Id = 8, AuthorId = 5, BookNumber = 1, Series = "Xanth", Title = "Golem in the Gears" }, new { Id = 9, AuthorId = 5, BookNumber = 2, Series = "Xanth", Title = "Demons Don't Dream" }, new { Id = 10, AuthorId = 5, BookNumber = 2, Series = "Xanth", Title = "Demons Don't Dream" }, new { Id = 11, AuthorId = 6, BookNumber = 1, Series = "Star Wars", Title = "Tales of the Bounty Hunters" }, new { Id = 12, AuthorId = 7, BookNumber = 1, Series = "None", Title = "Canterbury Tales" }, new { Id = 13, AuthorId = 8, BookNumber = 1, Series = "None", Title = "Anne of Green Gables" }, new { Id = 14, AuthorId = 9, BookNumber = 1, Series = "None", Title = "Trina" }); }); #pragma warning restore 612, 618 } } }