示例#1
0
 public DonationBuilder(EntityTypeConfiguration <Donation> entity)
 {
     entity.Property(d => d.Owner).IsRequired().HasMaxLength(200);
     entity.Property(d => d.UpdatedBy).HasMaxLength(4000);
     entity.HasRequired(r => r.Region).WithMany(d => d.Donations).HasForeignKey(r => r.RegionId);
     entity.HasRequired(t => t.TreeType).WithMany(d => d.Donations).HasForeignKey(t => t.TreeTypeId);
 }
示例#2
0
 public DonationBuilder(EntityTypeConfiguration <Donation> entity)
 {
     entity.Property(p => p.Owner).IsRequired().HasMaxLength(200);
     entity.HasRequired(p => p.TreeType).WithMany(m => m.Donations).HasForeignKey(p => p.TreeTypeId);
     entity.HasRequired(p => p.Region).WithMany(m => m.Donations).HasForeignKey(p => p.RegionId);
     entity.Property(p => p.TreeName).IsRequired().HasMaxLength(200);
 }
 public void Configurar(EntityTypeConfiguration <Funcionario> entityConfiguration)
 {
     entityConfiguration
     .ToTable("DadosFuncionario")
     .HasKey(entity => entity.Id);
     entityConfiguration
     .Property(entity => entity.Nome).IsRequired().HasMaxLength(Funcionario.TamanhoMaximoNome);
     entityConfiguration
     .Property(entity => entity.Rg).IsRequired().HasMaxLength(Funcionario.TamanhoMaximoRg);
     entityConfiguration
     .Property(entity => entity.OrgaoEmissor).IsRequired().HasMaxLength(Funcionario.TamanhoMaximoOrgaoEmissor);
     entityConfiguration
     .Property(entity => entity.Sexo).IsRequired().HasMaxLength(Funcionario.TamanhMaximoSexo);
     entityConfiguration
     .Property(entity => entity.Cpf).IsRequired();
     entityConfiguration
     .Property(entity => entity.Telefone).IsRequired();
     entityConfiguration
     .Property(entity => entity.Ctps).IsRequired().HasMaxLength(Funcionario.TamanhoMaximoCtps);
     entityConfiguration
     .Property(entity => entity.Documento).IsRequired().HasMaxLength(Funcionario.TamanhoMaximoDocumento);
     entityConfiguration
     .Property(entity => entity.DataNascimento).IsRequired();
     entityConfiguration
     .HasRequired(entity => entity.Funcao)
     .WithRequiredPrincipal();
     entityConfiguration
     .HasRequired(entity => entity.Endereco)
     .WithRequiredPrincipal();
 }
        public void Configure(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <Projection> projectionModel = modelBuilder.Entity <Projection>();

            projectionModel.HasKey(model => model.Id);
            projectionModel.Property(model => model.MovieId).IsRequired();
            projectionModel.Property(model => model.RoomId).IsRequired();
            projectionModel.Property(model => model.StartDate).IsRequired();

            projectionModel
            .HasMany(r => r.Reservations)
            .WithRequired();
            projectionModel
            .HasMany(t => t.Tickets)
            .WithRequired();

            projectionModel
            .HasRequired(m => m.Movie)
            .WithMany(p => p.Projections)
            .HasForeignKey(x => x.MovieId);
            projectionModel
            .HasRequired(r => r.Room)
            .WithMany(p => p.Projections)
            .HasForeignKey(x => x.RoomId);
        }
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <Trainer> trainerConfig = modelBuilder.Entity <Trainer>();

            trainerConfig.HasKey(x => x.Id);
            trainerConfig.Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);

            trainerConfig.Property(x => x.FirstName).IsRequired().HasMaxLength(50).HasColumnType("varchar");
            trainerConfig.Property(x => x.LastName).IsRequired().HasMaxLength(50).HasColumnType("varchar");

            trainerConfig.Property(x => x.IsOnline).IsRequired().HasColumnType("bit");
            trainerConfig.Property(x => x.Status).IsRequired().HasColumnType("bit");

            trainerConfig.Property(x => x.DateOfBirth).IsOptional().HasColumnType("date");
            trainerConfig.Property(x => x.DateOfRegistration).IsRequired().HasColumnType("date");

            trainerConfig.HasRequired(t => t.Branch).WithMany(t => t.Trainers)
            .HasForeignKey(t => t.BranchID)
            .WillCascadeOnDelete(false);


            trainerConfig.HasRequired(t => t.Gender).WithMany(t => t.Trainers)
            .HasForeignKey(t => t.GenderID)
            .WillCascadeOnDelete(false);

            trainerConfig.HasRequired(t => t.Title).WithMany(t => t.Trainers)
            .HasForeignKey(t => t.TitleID)
            .WillCascadeOnDelete(false);

            //Login deki userId burdaki Id olacak
        }
示例#6
0
 public QualityPlanBuilder(EntityTypeConfiguration <QualityPlan> builder)
 {
     builder.Property(b => b.Description).HasMaxLength(4000);
     builder.HasRequired(a => a.Company).WithMany(b => b.QualityPlans).HasForeignKey(a => a.CompanyId);
     builder.HasOptional(a => a.Facility).WithMany(b => b.QualityPlans).HasForeignKey(a => a.FacilityId);
     builder.HasRequired(a => a.Material).WithMany(b => b.QualityPlans).HasForeignKey(a => a.MaterialId);
 }
示例#7
0
    void ConfigureCatalogItem(EntityTypeConfiguration <CatalogItem> builder)
    {
        builder.ToTable("Catalog");

        builder.HasKey(ci => ci.Id);

        builder.Property(ci => ci.Id)
        .HasDatabaseGeneratedOption(DatabaseGeneratedOption.None)
        .IsRequired();

        builder.Property(ci => ci.Name)
        .IsRequired()
        .HasMaxLength(50);

        builder.Property(ci => ci.Price)
        .IsRequired();

        builder.Property(ci => ci.PictureFileName)
        .IsRequired();

        builder.Ignore(ci => ci.PictureUri);

        builder.HasRequired <CatalogBrand>(ci => ci.CatalogBrand)
        .WithMany()
        .HasForeignKey(ci => ci.CatalogBrandId);

        builder.HasRequired <CatalogType>(ci => ci.CatalogType)
        .WithMany()
        .HasForeignKey(ci => ci.CatalogTypeId);
    }
示例#8
0
 public StockBuilder(EntityTypeConfiguration <Stock> builder)
 {
     builder.HasKey(s => s.Id);
     builder.HasRequired(s => s.Personel).WithMany(a => a.Stocks).HasForeignKey(s => s.PersonelId);
     builder.HasRequired(a => a.Product).WithMany(a => a.Stocks).HasForeignKey(s => s.ProductId);
     builder.Property(a => a.StockEntryDate).IsRequired();
     builder.Property(a => a.Quantity).IsRequired();
 }
示例#9
0
 public MaterialInputBuilder(EntityTypeConfiguration <MaterialInput> builder)
 {
     builder.HasOptional(a => a.Order).WithMany(b => b.MaterialInputs).HasForeignKey(a => a.OrderId);
     builder.HasOptional(a => a.OrderType).WithMany(b => b.MaterialInputs).HasForeignKey(a => a.OrderTypeId);
     builder.HasRequired(a => a.Material).WithMany(b => b.MaterialInputs).HasForeignKey(a => a.MaterialId);
     builder.HasRequired(a => a.Supplier).WithMany(b => b.MaterialInputs).HasForeignKey(a => a.SupplierId);
     builder.HasRequired(a => a.StockLocation).WithMany(b => b.MaterialInputs).HasForeignKey(a => a.StockLocationId);
 }
示例#10
0
 public PlantingBuilder(EntityTypeConfiguration <Planting> entity)
 {
     entity.Property(p => p.Lat).IsRequired().HasMaxLength(200);
     entity.Property(p => p.Long).IsRequired().HasMaxLength(200);
     entity.Property(p => p.PlantingCode).IsRequired().HasMaxLength(200);
     entity.HasRequired(p => p.PlanterUser).WithMany(m => m.Plantings).HasForeignKey(p => p.PlanterUserId);
     entity.HasRequired(p => p.Donation).WithMany(m => m.Plantings).HasForeignKey(p => p.DonationId);
 }
示例#11
0
 public OrderBuilder(EntityTypeConfiguration <Order> builder)
 {
     builder.HasRequired(a => a.Customer).WithMany(b => b.Orders).HasForeignKey(a => a.CustomerId);
     builder.Property(b => b.Created).HasMaxLength(100);
     builder.HasRequired(a => a.Product).WithMany(b => b.Orders).HasForeignKey(a => a.ProductId
                                                                               );
     builder.Property(b => b.Description).HasMaxLength(4000);
     builder.HasOptional(a => a.Tax).WithMany(b => b.Orders).HasForeignKey(a => a.TaxId);
 }
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <MessageGroup_User> messageGroupUserConfig = modelBuilder.Entity <MessageGroup_User>();

            messageGroupUserConfig.HasKey(mgu => mgu.Id);
            messageGroupUserConfig.HasRequired(mgu => mgu.User).WithMany(mgu => mgu.MessageGroupUsers).HasForeignKey(mgu => mgu.UserID).WillCascadeOnDelete(false);

            messageGroupUserConfig.HasRequired(mgu => mgu.MessageGroup).WithMany(mgu => mgu.MessageGroupUsers).HasForeignKey(mgu => mgu.MessageGroupID).WillCascadeOnDelete(false);
        }
示例#13
0
        public static EntityTypeConfiguration <ProductParameterValue> Map()
        {
            var map = new EntityTypeConfiguration <ProductParameterValue>();

            map.HasRequired(P => P.Product).WithMany(p => p.ProductParameterValues).HasForeignKey(p => p.ProductId).WillCascadeOnDelete(false);
            map.HasRequired(P => P.ProductParameter).WithMany(p => p.ProductParameterValues).HasForeignKey(p => p.ProductParameterId).WillCascadeOnDelete(false);
            map.HasKey(P => new { P.ProductId, P.ProductParameterId });
            return(map);
        }
示例#14
0
        public static EntityTypeConfiguration <InventoryOutsDeatil> Map()
        {
            var map = new EntityTypeConfiguration <InventoryOutsDeatil>();

            map.HasKey(P => new { P.ProductId, P.InventoryOutsHeaderId });
            map.HasRequired(I => I.inventoryOutsHeader).WithMany(C => C.InventoryOutsDeatiles).HasForeignKey(p => p.InventoryOutsHeaderId);
            map.HasRequired(I => I.prodocut).WithMany(C => C.InventoryOutsDeatils).HasForeignKey(p => p.ProductId);
            return(map);
        }
示例#15
0
        internal static void OnModelCreating(EntityTypeConfiguration <ModuleFunction> entityTypeConfiguration)
        {
            entityTypeConfiguration.HasRequired(i => i.Module)
            .WithMany(i => i.ModuleFunctions)
            .HasForeignKey(i => i.ModuleID);

            entityTypeConfiguration.HasRequired(i => i.Function)
            .WithMany(i => i.ModuleFunctions)
            .HasForeignKey(i => i.FunctionID);
        }
示例#16
0
 public SaleBuilder(EntityTypeConfiguration <Sale> builder)
 {
     builder.HasKey(s => s.Id);
     builder.HasRequired(s => s.Product).WithMany(a => a.Sales).HasForeignKey(s => s.ProductId);
     builder.HasRequired(s => s.Stock).WithMany(a => a.Sales).HasForeignKey(s => s.StockId);
     builder.HasRequired(s => s.Customer).WithMany(c => c.Purchases).HasForeignKey(s => s.CustomerId);
     builder.Property(s => s.Amount).HasPrecision(18, 2).IsRequired();
     builder.HasRequired(s => s.Shipment).WithMany(a => a.Sales).HasForeignKey(s => s.ShipmentId);
     builder.Property(s => s.SellingDate).IsRequired();
 }
示例#17
0
 public OrderBuilder(EntityTypeConfiguration <Order> builder)
 {
     builder.Property(b => b.Name).HasMaxLength(100).IsRequired();
     builder.HasOptional(a => a.Company).WithMany(b => b.Orders).HasForeignKey(a => a.CompanyId);
     builder.HasOptional(a => a.Facility).WithMany(b => b.Orders).HasForeignKey(a => a.FacilityId);
     builder.HasRequired(a => a.BusinessArea).WithMany(b => b.Orders).HasForeignKey(a => a.BusinessAreaId);
     builder.HasRequired(a => a.PurchasingDepartment).WithMany(b => b.Orders).HasForeignKey(a => a.PurchasingDepartmentId);
     builder.HasRequired(a => a.OrderType).WithMany(b => b.Orders).HasForeignKey(a => a.OrderTypeId);
     builder.HasRequired(a => a.Supplier).WithMany(b => b.Orders).HasForeignKey(a => a.SupplierId);
 }
示例#18
0
        public CompanyBuilder(EntityTypeConfiguration <Company> builder)
        {
            builder.Property(b => b.Name).HasMaxLength(100).IsRequired();
            builder.Property(b => b.Phone).HasMaxLength(20);
            builder.Property(b => b.Address).HasMaxLength(500);

            builder.HasRequired(a => a.Country).WithMany(b => b.Companies).HasForeignKey(a => a.CountryId);
            builder.HasRequired(a => a.City).WithMany(b => b.Companies).HasForeignKey(a => a.CityId);
            builder.HasOptional(a => a.Region).WithMany(b => b.Companies).HasForeignKey(a => a.RegionId);
        }
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <HomeworkDelivery> hWDeliveryConfig = modelBuilder.Entity <HomeworkDelivery>();

            hWDeliveryConfig.HasKey(hwd => hwd.Id);
            hWDeliveryConfig.Property(hwd => hwd.DateOfDelivery).IsRequired().HasColumnType("date");

            hWDeliveryConfig.HasRequired(hwd => hwd.Homework).WithMany(hwd => hwd.HomeworkDeliverys).HasForeignKey(hwd => hwd.HomeworkID).WillCascadeOnDelete(false);

            hWDeliveryConfig.HasRequired(hwd => hwd.Student).WithMany(hwd => hwd.HomeworkDeliverys).HasForeignKey(hwd => hwd.StudentID).WillCascadeOnDelete(false);
        }
示例#20
0
 public InvoiceBuilder(EntityTypeConfiguration <Invoice> builder)
 {
     builder.HasRequired(a => a.Customer).WithMany(b => b.Invoices).HasForeignKey(a => a.CustomerId);
     builder.Property(b => b.Address).HasMaxLength(4000);
     builder.Property(b => b.InvoiceAddress).HasMaxLength(4000);
     builder.Property(b => b.Created).HasMaxLength(100);
     builder.Property(b => b.MobilePhone).HasMaxLength(20).IsRequired();
     builder.HasRequired(a => a.Product).WithMany(b => b.Invoices).HasForeignKey(a => a.ProductId);
     builder.Property(b => b.Description).HasMaxLength(4000);
     builder.HasOptional(a => a.Tax).WithMany(b => b.Invoices).HasForeignKey(a => a.TaxId);
 }
示例#21
0
        private void MapProduct(EntityTypeConfiguration <Product> product)
        {
            product.HasKey(i => i.Id).ToTable("Products");

            product.Property(i => i.Id).HasColumnName("ID").HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

            product.Property(i => i.ProductTypeId).HasColumnName("FKProductTypeID").IsRequired();

            product.HasRequired(i => i.ProductType).WithMany().HasForeignKey(i => i.ProductTypeId);

            product.Property(i => i.SalesResponsibleId).HasColumnName("SalesResponsibleID").IsRequired();

            product.HasRequired(i => i.SalesResponsible).WithMany().HasForeignKey(i => i.SalesResponsibleId);

            product.Property(i => i.PlaceId).HasColumnName("FKPlaceID").IsRequired();

            product.HasRequired(i => i.Place).WithMany().HasForeignKey(i => i.PlaceId);

            product.Property(i => i.Description).IsRequired();

            product.Property(i => i.LivingSpace).IsOptional();

            product.Property(i => i.PlotSize).IsOptional();

            product.Property(i => i.NumberOfRooms).IsOptional();

            product.Property(i => i.Price).IsOptional();

            product.Property(i => i.MonthlyCharge).IsOptional();

            product.Property(i => i.SquareMeterPrice).IsOptional();

            product.Property(i => i.YearBuilt).IsOptional();

            product.Property(i => i.ExternalLink).IsRequired();

            product.Property(i => i.ExternalPicLink).IsOptional();

            product.Property(i => i.InsertDate).IsRequired();

            product.Property(i => i.Address).IsRequired();

            product.Property(i => i.Lat).IsOptional();

            product.Property(i => i.Long).IsOptional();

            product.Property(i => i.IsApproved).IsRequired();

            product.Property(i => i.RefNr).IsOptional();

            product.Property(i => i.ThumbnailUrl).IsOptional();

            product.Property(i => i.PriceFilter).IsOptional();
        }
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <Message> messageConfig = modelBuilder.Entity <Message>();

            messageConfig.HasKey(m => m.Id);
            messageConfig.Property(m => m.Content).IsRequired().HasColumnType("varchar").HasMaxLength(2000);
            messageConfig.Property(m => m.DateOfSend).IsRequired().HasColumnType("date");

            messageConfig.HasRequired(m => m.User).WithMany(m => m.Messages).HasForeignKey(m => m.UserID).WillCascadeOnDelete(false);
            messageConfig.HasRequired(m => m.MessageGroup).WithMany(m => m.Messages).HasForeignKey(m => m.MessageGroupID).WillCascadeOnDelete(false);
        }
示例#23
0
        public static EntityTypeConfiguration <ProductCategory> Map()
        {
            var map = new EntityTypeConfiguration <ProductCategory>();

            map.Property(P => P.Title).HasMaxLength(100).IsRequired();
            map.Property(P => P.Description).HasMaxLength(1000);
            map.HasRequired(P => P.Inventories).WithMany(C => C.ProductCategories).HasForeignKey(p => p.InventoryId).WillCascadeOnDelete(false);
            map.HasOptional(C => C.DeletedUser).WithMany(U => U.DeletedProductCategory).HasForeignKey(I => I.DeletedByUserId);
            map.HasRequired(C => C.CreatedUser).WithMany(U => U.CreatedProductCategory).HasForeignKey(I => I.CreatedByUserId).WillCascadeOnDelete(false);
            map.HasOptional(C => C.ChangedUser).WithMany(U => U.ChangedProductCategory).HasForeignKey(I => I.ChangedByUserId);
            return(map);
        }
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <Comment> commentConfig = modelBuilder.Entity <Comment>();

            commentConfig.HasKey(x => x.Id);

            commentConfig.Property(x => x.DateOfComment).IsRequired().HasColumnType("datetime");
            commentConfig.Property(x => x.Description).IsRequired().HasColumnType("nvarchar").HasMaxLength(200);

            commentConfig.HasRequired(x => x.Topic).WithMany(x => x.Comments).HasForeignKey(x => x.TopicID);
            commentConfig.HasRequired(x => x.Login).WithMany(x => x.Comments).HasForeignKey(x => x.UserID);
        }
示例#25
0
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <Answer> answerConfig = modelBuilder.Entity <Answer>();

            answerConfig.HasKey(x => new { x.QuestionID, x.StudentID });

            answerConfig.HasRequired(x => x.Question).WithMany(x => x.Answers).HasForeignKey(x =>
                                                                                             x.QuestionID)
            .WillCascadeOnDelete(false);
            answerConfig.HasRequired(x => x.Student).WithMany(x => x.Answers).HasForeignKey(x => x.StudentID).WillCascadeOnDelete(false);
            answerConfig.HasRequired(x => x.Option).WithMany(x => x.Answers).HasForeignKey(x => x.OptionID).WillCascadeOnDelete(false);
        }
        internal static void Define(EntityTypeConfiguration<Domain.ItemInstance> config)
        {
            config.HasRequired(r => r.Item)
                .WithMany(r => r.OwnedBy)
                .HasForeignKey(fk => fk.ItemId)
                .WillCascadeOnDelete(false);

            config.HasRequired(r => r.Owner)
                .WithMany(r => r.Items)
                .HasForeignKey(fk => fk.OwnerId)
                .WillCascadeOnDelete(false);
        }
        public static EntityTypeConfiguration <InventoryInsHeader> Map()
        {
            var map = new EntityTypeConfiguration <InventoryInsHeader>();

            map.HasRequired(I => I.Inv).WithMany(C => C.InventoryInsHeaders).HasForeignKey(p => p.InventoryId);
            map.HasRequired(I => I.type).WithMany(C => C.InventoryInsHeaders).HasForeignKey(p => p.TypeId);
            map.HasOptional(C => C.DeletedUser).WithMany(U => U.DeletedInventoryInsHeader).HasForeignKey(I => I.AcceptedByUserId);
            map.HasOptional(C => C.DeletedUser).WithMany(U => U.DeletedInventoryInsHeader).HasForeignKey(I => I.DeletedByUserId);
            map.HasRequired(C => C.CreatedUser).WithMany(U => U.CreatedInventoryInsHeader).HasForeignKey(I => I.CreatedByUserId).WillCascadeOnDelete(false);
            map.HasOptional(C => C.ChangedUser).WithMany(U => U.ChangedInventoryInsHeader).HasForeignKey(I => I.ChangedByUserId);
            return(map);
        }
示例#28
0
        protected void buildProductDocs(EntityTypeConfiguration <ProductDoc> productDocEntity)
        {
            productDocEntity
            .HasKey(x => new { x.blobID, x.productID });

            productDocEntity
            .HasRequired(x => x.product)
            .WithMany(x => x.files)
            .HasForeignKey(x => x.productID);

            productDocEntity
            .HasRequired(x => x.blob);
        }
示例#29
0
        public static EntityTypeConfiguration <Inventory> Map()
        {
            var map = new EntityTypeConfiguration <Inventory>();

            map.Property(I => I.Title).HasMaxLength(100).IsRequired();
            map.Property(I => I.Description).HasMaxLength(1000);
            map.Property(I => I.Address).HasMaxLength(1000);
            map.HasRequired(I => I.corporation).WithMany(C => C.Inventories).HasForeignKey(c => c.CorporationId);
            map.HasOptional(C => C.DeletedUser).WithMany(U => U.DeletedInventory).HasForeignKey(I => I.DeletedByUserId);
            map.HasRequired(C => C.CreatedUser).WithMany(U => U.CreatedInventory).HasForeignKey(I => I.CreatedByUserId).WillCascadeOnDelete(false);
            map.HasOptional(C => C.ChangedUser).WithMany(U => U.ChangedInventory).HasForeignKey(I => I.ChangedByUserId);
            return(map);
        }
示例#30
0
 public SystemUserBuilder(EntityTypeConfiguration <SystemUser> builder)
 {
     builder.Property(b => b.UserName).HasMaxLength(100).IsRequired();
     builder.Property(b => b.ContactNumber).HasMaxLength(15);
     builder.Property(b => b.Name).HasMaxLength(100).IsRequired();
     builder.Property(b => b.Surname).HasMaxLength(100).IsRequired();
     builder.Property(b => b.Email).HasMaxLength(100);
     builder.Property(b => b.Profile).HasMaxLength(500);
     builder.Property(b => b.FilePath).HasMaxLength(500);
     builder.HasRequired(a => a.Company).WithMany(b => b.SystemUsers).HasForeignKey(a => a.CompanyId);
     builder.HasRequired(a => a.Department).WithMany(b => b.SystemUsers).HasForeignKey(a => a.DepartmentId);
     builder.HasOptional(a => a.Position).WithMany(b => b.SystemUsers).HasForeignKey(a => a.PositionId);
 }
        public static void Map(DbModelBuilder modelBuilder)
        {
            EntityTypeConfiguration <Login> loginConfig = modelBuilder.Entity <Login>();

            loginConfig.HasKey(x => x.Id);
            loginConfig.Property(x => x.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.None);

            loginConfig.Property(x => x.UserName).IsRequired().HasColumnType("nvarchar").HasMaxLength(50);
            loginConfig.Property(x => x.Mail).IsRequired().HasColumnType("nvarchar").HasMaxLength(50);
            loginConfig.Property(x => x.Password).IsRequired().HasColumnType("nvarchar").HasMaxLength(36);
            loginConfig.Property(x => x.CitizenNumber).IsRequired().HasColumnType("char").HasMaxLength(11);
            loginConfig.HasRequired(x => x.Student).WithRequiredPrincipal(x => x.Login);
            loginConfig.HasRequired(x => x.Trainer).WithRequiredPrincipal(x => x.Login);
        }
示例#32
0
        protected void buildOrders(EntityTypeConfiguration<Order> orderEntity)
        {
            orderEntity
                .HasKey(x => x.orderID)
                .Property(x => x.orderDate)
                .IsRequired();

            orderEntity
                .Property(x => x.status)
                .IsRequired();

            orderEntity
                .Property(x => x.address)
                .IsRequired()
                .HasMaxLength(400);

            orderEntity
                .Property(x => x.timeStamp)
                .IsRequired();

            orderEntity
                .HasRequired(x => x.customer)
                .WithMany(x => x.orders);
            orderEntity
                .HasMany(x => x.products)
                .WithRequired(x => x.order)
                .WillCascadeOnDelete();
        }
示例#33
0
        protected void buildProductDocs(EntityTypeConfiguration<ProductDoc> productDocEntity)
        {
            productDocEntity
                .HasKey(x => new { x.blobID, x.productID });

            productDocEntity
                .HasRequired(x => x.product)
                .WithMany(x => x.files)
                .HasForeignKey(x => x.productID);

            productDocEntity
                .HasRequired(x => x.blob);
        }
示例#34
0
        protected void buildOrderItems(EntityTypeConfiguration<OrderItem> orderItemEntity)
        {
            orderItemEntity
                .HasKey(x => new { x.productID, x.orderID });

            orderItemEntity
                .HasRequired(x => x.order)
                .WithMany(x => x.products)
                .HasForeignKey(x => x.orderID);

            orderItemEntity
                .Property(x => x.quantity)
                .IsRequired();
        }