public CountryMapping() { Table("`country`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.CountryCode, "countryCode"); Map(x => x.CreatedOn, "createdOn"); Map(x => x.LastModified, "lastModified"); Map(x => x.Name, "name"); Map(x => x.Nationality, "nationality"); HasMany(x => x.People) .KeyColumn("countryOfBirthId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.People1) .KeyColumn("countryOfResidenceId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.People2) .KeyColumn("nationalityId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); Cache.ReadOnly(); }
public RouteListMap() { Table("route_lists"); OptimisticLock.Version(); Version(x => x.Version) .Column("version"); Id(x => x.Id).Column("id").GeneratedBy.Native(); Map(x => x.ConfirmedDistance).Column("confirmed_distance"); Map(x => x.Date).Column("date"); Map(x => x.Status).Column("status").CustomType <RouteListStatusStringType> (); Map(x => x.ClosingDate).Column("closing_date"); Map(x => x.ClosingComment).Column("closing_comment"); Map(x => x.LogisticiansComment).Column("logisticians_comment"); Map(x => x.ClosingFilled).Column("closing_filled"); Map(x => x.LastCallTime).Column("last_call_time"); Map(x => x.DifferencesConfirmed).Column("differences_confirmed"); Map(x => x.IsManualAccounting).Column("is_manual_accounting"); Map(x => x.OnLoadTimeStart).Column("on_load_start").CustomType <TimeAsTimeSpanType>(); Map(x => x.OnLoadTimeEnd).Column("on_load_end").CustomType <TimeAsTimeSpanType>(); Map(x => x.OnLoadGate).Column("on_load_gate"); Map(x => x.OnloadTimeFixed).Column("on_load_time_fixed"); Map(x => x.PlanedDistance).Column("plan_distance"); Map(x => x.Printed).Column("printed"); Map(x => x.AddressesOrderWasChangedAfterPrinted).Column("addresses_order_was_changed_after_printed"); Map(x => x.RecalculatedDistance).Column("recalculated_distance"); Map(x => x.MileageComment).Column("mileage_comment"); Map(x => x.MileageCheck).Column("mileage_check"); Map(x => x.NormalWage).Column("normal_wage"); Map(x => x.FixedDriverWage).Column("fixed_driver_wage"); Map(x => x.FixedForwarderWage).Column("fixed_forwarder_wage"); Map(x => x.NotFullyLoaded).Column("not_fully_loaded"); Map(x => x.CashierReviewComment).Column("cashier_review_comment"); Map(x => x.WasAcceptedByCashier).Column("was_accepted_by_cashier"); References(x => x.Car).Column("car_id"); References(x => x.Shift).Column("delivery_shift_id"); References(x => x.Driver).Column("driver_id"); References(x => x.Forwarder).Column("forwarder_id"); References(x => x.Logistician).Column("logistican_id"); References(x => x.BottleFine).Column("bottles_fine_id"); References(x => x.Cashier).Column("cashier_id"); References(x => x.FuelOutlayedOperation).Column("fuel_outlayed_operation_id").Cascade.All(); References(x => x.DriverWageOperation).Column("driver_wages_movement_operations_id"); References(x => x.ForwarderWageOperation).Column("forwarder_wages_movement_operations_id"); References(x => x.ClosedBy).Column("closed_by_employee_id"); References(x => x.ClosingSubdivision).Column("closing_subdivision_id"); References(x => x.LogisticiansCommentAuthor).Column("logisticians_comment_author_id"); HasMany(x => x.Addresses).Cascade.AllDeleteOrphan().Inverse() .KeyColumn("route_list_id") .AsList(x => x.Column("order_in_route")); HasMany(x => x.FuelDocuments).Cascade.AllDeleteOrphan().Inverse().LazyLoad().KeyColumn("route_list_id"); HasManyToMany(x => x.GeographicGroups).Table("geographic_groups_to_entities") .ParentKeyColumn("route_list_id") .ChildKeyColumn("geographic_group_id") .LazyLoad(); }
public MovementDocumentMap() { Table("store_movement_document"); OptimisticLock.Version(); Version(x => x.Version).Column("version"); Id(x => x.Id).Column("id").GeneratedBy.Native(); Map(x => x.TimeStamp).Column("time_stamp"); Map(x => x.Comment).Column("comment"); Map(x => x.DocumentType).Column("category").CustomType <MovementDocumentCategoryStringType> (); Map(x => x.Status).Column("status").CustomType <MovementDocumentStatusStringType>(); Map(x => x.LastEditedTime).Column("last_edit_time"); Map(x => x.SendTime).Column("send_time"); Map(x => x.ReceiveTime).Column("delivered_time"); Map(x => x.DiscrepancyAcceptTime).Column("discrepancy_accept_time"); Map(x => x.HasDiscrepancy).Column("has_discrepancy"); References(x => x.Author).Column("author_id"); References(x => x.LastEditor).Column("last_editor_id"); References(x => x.Receiver).Column("receiver_id"); References(x => x.Sender).Column("sender_id"); References(x => x.DiscrepancyAccepter).Column("discrepancy_accepter_id"); References(x => x.MovementWagon).Column("transportation_wagon_id"); References(x => x.FromWarehouse).Column("warehouse_from_id"); References(x => x.ToWarehouse).Column("warehouse_to_id"); HasMany(x => x.Items).Cascade.AllDeleteOrphan().Inverse().KeyColumn("movement_document_id"); }
public GeneralInformationMapping() { Table("`general_information`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.Content, "content"); Map(x => x.CreatedOn, "createdOn"); Map(x => x.DefaultImageFilelName, "defaultImageFilelName"); Map(x => x.ShortDescription, "shortDescription"); Map(x => x.Title, "title"); References(x => x.User) .Class(typeof(User)) .Column("userId") .Fetch.Select() .Cascade.All(); HasMany(x => x.GeneralInformationAttachments) .KeyColumn("generalInformationId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); Cache.ReadWrite(); }
public BaseMap() { Id(x => x.Id).GeneratedBy.Native(); OptimisticLock.Version(); Version(x => x.Version); }
public InformationDeskMapping() { Table("`information_desk`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.Content, "content"); Map(x => x.CreatedOn, "createdOn"); Map(x => x.DateOfEvent, "dateOfEvent"); Map(x => x.DefaultImageFileName, "defaultImageFileName"); Map(x => x.ShortDescription, "shortDescription"); Map(x => x.ShowEndDate, "showEndDate"); Map(x => x.ShowStartDate, "showStartDate"); Map(x => x.Title, "title"); Map(x => x.Type, "type"); HasMany(x => x.InformationDeskAttachments) .KeyColumn("InformationDeskId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.InformationDeskTargets) .KeyColumn("informationDeskId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); References(x => x.User) .Class(typeof(User)) .Column("userId") .Fetch.Select() .Cascade.All(); Cache.ReadWrite(); }
public RoleMapping() { Table("`role`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.RequiresAccessScope, "requiresAccessScope").CustomType <BoolAsTinyInt>(); Map(x => x.CanCreate, "canCreate").CustomType <BoolAsTinyInt>(); Map(x => x.CanDelete, "canDelete").CustomType <BoolAsTinyInt>(); Map(x => x.CanUpdate, "canUpdate").CustomType <BoolAsTinyInt>(); Map(x => x.CanRead, "canRead").CustomType <BoolAsTinyInt>(); Map(x => x.Type, "type"); References(x => x.Service) .Class(typeof(Service)) .Column("serviceId") .Fetch.Select() .Cascade.All(); HasMany(x => x.UserRoles) .KeyColumn("roleId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); //Cache.ReadWrite(); }
public SubCountyMapping() { Table("`sub_county`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.Code, "code"); Map(x => x.CreatedOn, "createdOn"); Map(x => x.LastModified, "lastModified"); Map(x => x.Name, "name"); References(x => x.County) .Class(typeof(County)) .Not.Nullable() .Column("countyId") .Fetch.Select() .Cascade.All(); HasMany(x => x.People) .KeyColumn("subCountyOfBirthId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.People1) .KeyColumn("subCountyOfResidenceId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); Cache.ReadOnly(); }
public SyllabusMapping() { Table("`syllabus`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.Title, "title"); Map(x => x.Week, "week"); Map(x => x.Overview, "overview"); Map(x => x.Graded, "graded"); References(x => x.Course) .Class(typeof(Course)) .Not.Nullable() .Column("courseId") .Fetch.Select() .Cascade.All(); HasMany(x => x.SyllabusAttachments) .KeyColumn("syllabusId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); Cache.ReadWrite(); }
public UserRoleMap() { Id(x => x.Id); Map(x => x.Name); OptimisticLock.Version(); Version(entity => entity.Version); }
public UserRoleMapping() { Table("`user_role`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); References(x => x.User) .Class(typeof(User)) .Not.Nullable() .Column("userId") .Fetch.Select() .Cascade.All(); References(x => x.Role) .Class(typeof(Role)) .Not.Nullable() .Column("roleId") .Fetch.Select() .Cascade.All(); References(x => x.AccessRole) .Class(typeof(AccessRole)) .Column("accessRoleId") .Fetch.Select() .Cascade.All(); //Cache.ReadWrite(); }
public StaffCourseMapping() { Table("`staff_course`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.AssessmentWindowId, "assessmentWindowId"); Map(x => x.CourseSummary, "courseSummary"); Map(x => x.Grading, "grading"); Map(x => x.IsMainInstructor, "isMainInstructor").CustomType <BoolAsTinyInt>(); Map(x => x.LecturePlan, "lecturePlan"); Map(x => x.Status, "status"); References(x => x.Course) .Class(typeof(Course)) .Not.Nullable() .Column("courseId") .Fetch.Select() .Cascade.All(); //References(x => x.Semester) // .Class(typeof(Semester)) // .Not.Nullable() // .Column("semesterId") // .Fetch.Select() // .Cascade.All(); References(x => x.StaffPosition) .Class(typeof(InstructorPosition)) .Not.Nullable() .Column("staffPositionId") .Fetch.Select() .Cascade.All(); Cache.ReadWrite(); }
public CampusMapping() { Table("`campus`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.Code, "code"); Map(x => x.Description, "description"); Map(x => x.Name, "name"); Map(x => x.ShortName, "shortName"); //HasMany(x => x.Programs) // .KeyColumn("campusId") // .Inverse() // .Cascade.All() // .Fetch.Select() // .AsSet(); References(x => x.Institution) .Class(typeof(Institution)) .Not.Nullable() .Column("instituteId") .Fetch.Select() .Cascade.All(); Cache.ReadWrite(); }
public CategoryMap() { Table("Categories"); Id(x => x.Id).Column("Id").GeneratedBy.Native(); Map(x => x.Name).Column("Name").Length(20).Not.Nullable(); OptimisticLock.Version(); Version(x => x.Version).Column("Version").Not.Nullable(); }
public ItemMap() { Table("Items"); Id(x => x.Id).Column("Id").GeneratedBy.Native(); Map(x => x.Name).Column("Name").Length(20).Not.Nullable(); OptimisticLock.Version(); Version(x => x.Version).Column("Version").Not.Nullable(); References(x => x.Category).Column("CategoryId").Not.Nullable().Cascade.None().ForeignKey(); }
public EntityMap() { Id(x => x.Id); OptimisticLock.Version(); Version(x => x.Version) .CustomType("Timestamp"); Map(x => x.Created).Not.Nullable(); }
public UserMap() { Table("Users"); Id(x => x.Id); Map(x => x.Name); Map(x => x.SurName); Version(X => X.EntityVersion); OptimisticLock.Version(); }
public RatingMap() { Table("Ratings"); Id(x => x.Id).Column("Id").GeneratedBy.Native(); Map(x => x.Score).Column("Score").Length(1).Not.Nullable(); Map(x => x.Comment).Column("Comment").Length(100); OptimisticLock.Version(); Version(x => x.Version).Column("Version").Not.Nullable(); References(x => x.Item).Column("ItemId").Not.Nullable().Cascade.None().ForeignKey(); References(x => x.User).Column("UserId").Not.Nullable().Cascade.None().ForeignKey(); }
public RouteListItemMap() { Table("route_list_addresses"); OptimisticLock.Version(); Version(x => x.Version).Column("version"); Id(x => x.Id).Column("id").GeneratedBy.Native(); Map(x => x.IndexInRoute).Column("order_in_route"); Map(x => x.BottlesReturned).Column("bottles_returned"); Map(x => x.DriverBottlesReturned).Column("driver_bottles_returned"); Map(x => x.OldBottleDepositsCollected).Column("deposits_collected"); Map(x => x.OldEquipmentDepositsCollected).Column("equipment_deposits_collected"); Map(x => x.ExtraCash).Column("extra_cash"); Map(x => x.TotalCash).Column("total_cash"); Map(x => x.DriverWage).Column("driver_wage"); Map(x => x.DriverWageSurcharge).Column("driver_wage_surcharge"); Map(x => x.ForwarderWage).Column("forwarder_wage"); Map(x => x.WithForwarder).Column("with_forwarder"); Map(x => x.StatusLastUpdate).Column("status_last_update"); Map(x => x.Comment).Column("comment").Length(150); Map(x => x.Status).Column("status").CustomType <RouteListItemStatusStringType>(); Map(x => x.NeedToReload).Column("need_to_reload"); Map(x => x.WasTransfered).Column("was_transfered"); Map(x => x.CashierComment).Column("cashier_comment"); Map(x => x.CashierCommentCreateDate).Column("cashier_comment_create_date"); Map(x => x.CashierCommentLastUpdate).Column("cashier_comment_last_update"); Map(x => x.Notified30Minutes).Column("notified_30minutes"); Map(x => x.NotifiedTimeout).Column("notified_timeout"); Map(x => x.PlanTimeStart).Column("plan_time_start").CustomType <TimeAsTimeSpanType>(); Map(x => x.PlanTimeEnd).Column("plan_time_end").CustomType <TimeAsTimeSpanType>(); Map(x => x.CommentForFine).Column("comment_for_fine"); Map(x => x.IsDriverForeignDistrict).Column("is_driver_foreign_district"); Map(x => x.CreationDate).Column("creation_date") .Insert().Not.Update().Access.ReadOnlyPropertyThroughCamelCaseField(Prefix.Underscore); References(x => x.RouteList).Column("route_list_id").Not.Nullable(); References(x => x.Order).Column("order_id").Cascade.SaveUpdate(); References(x => x.TransferedTo).Column("transfered_to_id"); References(x => x.CashierCommentAuthor).Column("cashier_comment_author"); References(x => x.DriverWageCalculationMethodic).Column("driver_wage_calculation_methodic_id"); References(x => x.ForwarderWageCalculationMethodic).Column("forwarder_wage_calculation_methodic_id"); References(x => x.LateArrivalReason).Column("late_arrival_reason_id"); References(x => x.LateArrivalReasonAuthor).Column("late_arrival_reason_author_id"); References(x => x.CommentForFineAuthor).Column("comment_for_fine_author_id"); HasManyToMany(x => x.Fines) .Table("fines_to_route_list_addresses") .ParentKeyColumn("route_list_address_id") .ChildKeyColumn("fine_id") .LazyLoad(); }
public UserMap() { Table("Users"); Id(x => x.Id).Column("Id").GeneratedBy.Native(); Map(x => x.Username).Column("Username").Length(20).Not.Nullable(); Map(x => x.Firstname).Column("Firstname").Length(50); Map(x => x.Lastname).Column("Lastname").Length(50).Not.Nullable(); Map(x => x.Password).Column("Password").Length(60).Not.Nullable(); Map(x => x.IsAdmin).Column("IsAdmin").Not.Nullable(); OptimisticLock.Version(); Version(x => x.Version).Column("Version").Not.Nullable(); }
public CourseSubjectMap() { Id(x => x.Id).GeneratedBy.Identity(); Map(e => e.Name).Not.Nullable().Unique().Length(150); //Map(e => e.EnglishName).Not.Nullable().Unique().Length(150).Column("Name_en"); HasMany(x => x.Translations).Access.CamelCaseField(Prefix.Underscore) .Cascade.AllDeleteOrphan() .KeyColumn("SubjectId").Inverse().AsSet(); DynamicUpdate(); OptimisticLock.Version(); Version(x => x.Version).CustomSqlType("timestamp").Generated.Always(); }
public RefreshTokenMapping() { Table("`refresh_token`"); Schema("witu"); Id(x => x.Id, "id"); OptimisticLock.Version(); Map(x => x.Subject, "subject"); Map(x => x.IssuedUtc, "issuedUtc"); Map(x => x.ExpiresUtc, "expiresUtc"); Map(x => x.ProtectedTicket, "protectedTicket"); Map(x => x.ClientId, "clientId"); }
public BaseUserMap() { Id(x => x.Id).GeneratedBy.HiLo(nameof(HiLoGenerator), nameof(HiLoGenerator.NextHi), "10", $"{nameof(HiLoGenerator.TableName)}='User'"); Map(e => e.Email) /*.Not.Nullable()*/.Unique(); Map(e => e.Name).Not.Nullable(); Map(e => e.EmailConfirmed); //Map(e => e.NormalizedName); //Map(e => e.NormalizedEmail); Map(e => e.SecurityStamp); Map(e => e.Image).Length(5000).Nullable(); Map(e => e.ImageName).Length(5000).Nullable(); Map(e => e.AuthenticatorKey); // Map(e => e.Culture); Map(e => e.Country).Nullable().Length(2); Map(e => e.Created).Insert().Not.Update(); Map(e => e.Fictive).ReadOnly(); Map(e => e.OldUser).Nullable(); References(x => x.University).Column("UniversityId2").ForeignKey("User_University2").Nullable(); Map(x => x.Language).Column("Language").CustomType <CultureInfo>().Nullable(); HasMany(x => x.Questions).Access.CamelCaseField(Prefix.Underscore).KeyColumn("UserId") .Inverse() .Cascade.AllDeleteOrphan(); HasMany(x => x.Followers).Access.CamelCaseField(Prefix.Underscore) .Cascade.AllDeleteOrphan() .KeyColumn("UserId").Inverse().AsSet(); Map(x => x.Score).ReadOnly(); Table("User"); //if not there is sql error DynamicUpdate(); OptimisticLock.Version(); Version(x => x.Version).CustomSqlType("timestamp").Generated.Always(); DiscriminateSubClassesOnColumn("Fictive"); /* * CREATE UNIQUE NONCLUSTERED INDEX idx_phoneNumber_notnull * ON sb.[User](PhoneNumberHash) * WHERE PhoneNumberHash IS NOT NULL; */ SchemaAction.Update(); }
public TemplateDocumentMapping() { Table("`template_document`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.Category, "category"); Map(x => x.Content, "content"); Map(x => x.FileType, "fileType"); Map(x => x.Name, "name"); Map(x => x.Subject, "subject"); }
public UserCourseMap() { CompositeId() .KeyReference(x => x.User, "UserId") .KeyReference(x => x.Course, "CourseId"); Map(e => e.IsTeach).Column("CanTeach").Not.Nullable(); Table("UsersCourses"); DynamicUpdate(); OptimisticLock.Version(); Version(x => x.Version).CustomSqlType("timestamp").Generated.Always(); }
public PetStoreMap() { Id(x => x.PetStoreUUID).GeneratedBy.GuidComb(); OptimisticLock.Version(); Version(x => x.TheVersionProperty) .Column("MyVersionColumn") .Not.Nullable() .CustomSqlType("timestamp") .Generated.Always(); Map(x => x.PetStoreName); Map(x => x.CreateDate); }
public ProductMap() { Id(x => x.Id); Map(x => x.Name); Map(x => x.Price); HasManyToMany(x => x.StoresStockedIn) .Cascade.All() .Inverse() .Table("StoreProduct"); Version(p => p.Version); OptimisticLock.Version(); DynamicUpdate(); }
public ReverseAuctionMap() { Id(x => x.Id); OptimisticLock.Version(); Version(x => x.Version) .Not.Nullable() .UnsavedValue("0"); Component(x => x.BuyerTerms).ColumnPrefix("BuyerTerms_"); Component(x => x.BiddingAllowed).ColumnPrefix("BiddingAllowed_"); //HasMany(x => x.Bids); // Not if Bids belong in a separate aggregate! }
public ChatUserMap() { Id(x => x.Id).GeneratedBy.GuidComb(); Map(x => x.Unread).Not.Nullable(); References(x => x.ChatRoom) .Not.Nullable().Column("ChatRoomId").ForeignKey("fChatUserChatRoom"); References(x => x.User) .Not.Nullable().Column("UserId") .ForeignKey("fChatUserUser"); DynamicUpdate(); OptimisticLock.Version(); Version(x => x.Version).CustomSqlType("timestamp").Generated.Always(); }
public CohortMapping() { Table("`semester`"); Schema("witu"); Id(x => x.Id, "id") .GeneratedBy.Native(); OptimisticLock.Version(); Map(x => x.AssessmentEndDate, "assessmentEndDate"); Map(x => x.AssessmentStartDate, "assessmentStartDate"); Map(x => x.EndDate, "endDate"); Map(x => x.RegistrationDeadline, "registrationDeadline"); Map(x => x.ResultsUploadDeadline, "resultsUploadDeadline"); Map(x => x.SemesterSession, "semesterSession"); Map(x => x.StartDate, "startDate"); Map(x => x.Status, "status"); References(x => x.CohortYear) .Class(typeof(CohortYear)) .Not.Nullable() .Column("academicYearId") .Fetch.Select() .Cascade.All(); HasMany(x => x.SemesterRegistrations) .KeyColumn("semsterId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.StaffCourses) .KeyColumn("semesterId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.Students) .KeyColumn("semesterEntryId") .Inverse() .Cascade.All() .Fetch.Select() .AsSet(); HasMany(x => x.StudentCourses) .KeyColumn("semesterId") .KeyNullable() .Inverse() .Cascade.All() .Fetch.Select() .AsSet() //deleted courses are not to be included... .Where(x => x.ResultStatus != ResultStatus.DeletedApproved) ; Cache.ReadWrite(); }