private static QueryTypeBuilder <T> SetTempTableName <T>([NotNull] this QueryTypeBuilder <T> builder)
where T : class
{
var tableName = "#" + typeof(T).DisplayName(false);
return(builder.ToView(tableName));
}
public void Configure(QueryTypeBuilder <InanHistoryDto> builder)
{
builder.ToView("VW_INAN_HISTORY");
builder.Property(p => p.IncidentDate)
.HasColumnName("INCIDENT_DATE");
builder.Property(p => p.IncidentTypeId)
.HasColumnName("INCIDENT_TYPE_ID");
builder.Property(p => p.RegionId)
.HasColumnName("REGION_ID");
builder.Property(p => p.DistrictId)
.HasColumnName("DISTRICT_ID");
builder.Property(p => p.Address)
.HasColumnName("ADDRESS");
builder.Property(p => p.MainReason)
.HasColumnName("MAIN_REASON");
builder.Property(p => p.IncidentAnnouncementId)
.HasColumnName("INAN_ID");
builder.Property(p => p.ChildId)
.HasColumnName("CHILD_ID");
builder.Property(p => p.ChildTypeId)
.HasColumnName("CHILD_TYPE_ID");
}
/// <summary>Defines the mapping information for the typed view 'TblContactType1'</summary>
/// <param name="config">The configuration to modify.</param>
protected virtual void MapTblContactType1(QueryTypeBuilder <TblContactType1TypedViewRow> config)
{
config.ToView("tblContactType");
config.Property(t => t.ContactTypeGuid).HasColumnName("contactType_Guid");
config.Property(t => t.ContactType).HasColumnName("contactType").HasMaxLength(6);
config.Property(t => t.ContactTypeCreateDate).HasColumnName("contactType_CreateDate");
config.Property(t => t.ContactTypeUpdateDate).HasColumnName("contactType_updateDate");
}
/// <summary>Defines the mapping information for the typed view 'TblUser1'</summary>
/// <param name="config">The configuration to modify.</param>
protected virtual void MapTblUser1(QueryTypeBuilder <TblUser1TypedViewRow> config)
{
config.ToView("tblUser");
config.Property(t => t.UserGuid).HasColumnName("user_GUID");
config.Property(t => t.UserName).HasColumnName("userName").HasMaxLength(30).IsRequired();
config.Property(t => t.EmailAddress).HasColumnName("emailAddress").HasMaxLength(40).IsRequired();
config.Property(t => t.Password).HasMaxLength(100);
config.Property(t => t.UserCreateDate).HasColumnName("user_createDate");
config.Property(t => t.UserUpdateDate).HasColumnName("user_updateDate");
}
/// <summary>Defines the mapping information for the typed view 'Tblcontact1'</summary>
/// <param name="config">The configuration to modify.</param>
protected virtual void MapTblcontact1(QueryTypeBuilder <Tblcontact1TypedViewRow> config)
{
config.ToView("tblcontact");
config.Property(t => t.ContactGuid).HasColumnName("contact_Guid");
config.Property(t => t.UserGuid).HasColumnName("user_Guid");
config.Property(t => t.ContactType).HasColumnName("contactType");
config.Property(t => t.ContactValue).HasColumnName("contactValue").HasMaxLength(10).IsRequired();
config.Property(t => t.IsActive).HasColumnName("isActive").HasMaxLength(1).IsRequired();
config.Property(t => t.ContactCreateDate).HasColumnName("contact_createDate");
config.Property(t => t.ContactUpdateDate).HasColumnName("contact_updateDate");
}
/// <summary>Defines the mapping information for the typed view 'TblRideRequest1'</summary>
/// <param name="config">The configuration to modify.</param>
protected virtual void MapTblRideRequest1(QueryTypeBuilder <TblRideRequest1TypedViewRow> config)
{
config.ToView("tblRideRequest");
config.Property(t => t.RideRequestGuid).HasColumnName("rideRequest_GUID");
config.Property(t => t.RequestFromGuid).HasColumnName("requestFrom_GUID");
config.Property(t => t.RequestToGuid).HasColumnName("requestTo_GUID");
config.Property(t => t.RequestStartDateTime).HasColumnName("requestStartDateTime");
config.Property(t => t.RequestEndDateTime).HasColumnName("requestEndDateTime");
config.Property(t => t.RequestStartAddressGuid).HasColumnName("requestStartAddress_Guid");
config.Property(t => t.RequestEndAddressGuid).HasColumnName("requestEndAddress_Guid");
config.Property(t => t.RequestCreateDate).HasColumnName("request_createDate");
config.Property(t => t.RequestUpdateDate).HasColumnName("request_updateDate");
}
/// <summary>Defines the mapping information for the typed view 'TblRide1'</summary>
/// <param name="config">The configuration to modify.</param>
protected virtual void MapTblRide1(QueryTypeBuilder <TblRide1TypedViewRow> config)
{
config.ToView("tblRide");
config.Property(t => t.RideGuid).HasColumnName("ride_GUID");
config.Property(t => t.RideFromGuid).HasColumnName("rideFrom_GUID");
config.Property(t => t.RideToGuid).HasColumnName("rideTo_GUID");
config.Property(t => t.RideStartDateTime).HasColumnName("rideStartDateTime");
config.Property(t => t.RideEndDateTime).HasColumnName("rideEndDateTime");
config.Property(t => t.RideStartAddressGuid).HasColumnName("rideStartAddress_Guid");
config.Property(t => t.RideEndAddressGuid).HasColumnName("rideEndAddress_Guid");
config.Property(t => t.RideCreateDate).HasColumnName("ride_createDate");
config.Property(t => t.RideUpdateDate).HasColumnName("ride_updateDate");
}
/// <summary>Defines the mapping information for the typed view 'Tbladdress1'</summary>
/// <param name="config">The configuration to modify.</param>
protected virtual void MapTbladdress1(QueryTypeBuilder <Tbladdress1TypedViewRow> config)
{
config.ToView("tbladdress");
config.Property(t => t.AddressGuid).HasColumnName("address_Guid");
config.Property(t => t.UserGuid).HasColumnName("user_Guid");
config.Property(t => t.Street1).HasColumnName("street1").HasMaxLength(20).IsRequired();
config.Property(t => t.Street2).HasColumnName("street2").HasMaxLength(20);
config.Property(t => t.City).HasMaxLength(10);
config.Property(t => t.State).HasColumnName("state").HasMaxLength(2).IsRequired();
config.Property(t => t.PostalCode).HasColumnName("postal_code");
config.Property(t => t.AddressCreateDate).HasColumnName("address_createDate");
config.Property(t => t.AddressUpdateDate).HasColumnName("address_updateDate");
}
public void Configure(QueryTypeBuilder <VWAtorFilme> builder)
{
builder
.ToView <VWAtorFilme>("VW_TOP_ATORES_FILMES");
builder
.Property(vw => vw.Id).HasColumnName("actor_id");
builder
.Property(vw => vw.PrimeiroNome).HasColumnName("first_name");
builder
.Property(vw => vw.UltimoNome).HasColumnName("last_name");
builder
.Property(vw => vw.QuantidadeFilmesRealizados).HasColumnName("count_film");
builder
.Property(vw => vw.DataAlteracao).HasColumnName("last_update");
}
public void Configure(QueryTypeBuilder <CustomerCallHistoryDto> builder)
{
builder.ToView("VW_INAN_CUSTOMER_CALL_HISTORY");
builder.Property(p => p.TelephoneNumber).HasColumnName("TELEPHONE_NUMBER");
builder.Property(p => p.CallDate).HasColumnName("CALL_DATE");
builder.Property(p => p.CallerTelephone).HasColumnName("CALLER_TELEPHONE");
builder.Property(p => p.CustomerFirstName).HasColumnName("CUSTOMER_FIRST_NAME");
builder.Property(p => p.CustomerLastName).HasColumnName("CUSTOMER_LAST_NAME");
builder.Property(p => p.CustomerMobileNumber).HasColumnName("CUSTOMER_MOBILE_NUMBER");
builder.Property(p => p.CustomerTelNumber).HasColumnName("CUSTOMER_TELEPHONE");
builder.Property(p => p.CallTypeId).HasColumnName("CALL_TYPE_ID");
builder.Property(p => p.BillId).HasColumnName("BILL_ID");
builder.Property(p => p.IdentityCode).HasColumnName("IDENTITY_CODE");
builder.Property(p => p.SubscribeCode).HasColumnName("SUBSCRIBE_CODE");
builder.Property(p => p.DigitalCode).HasColumnName("DIGITAL_CODE");
builder.Property(p => p.CustomerAddress).HasColumnName("CUSTOMER_ADDRESS");
builder.Property(p => p.CustomerPostalCode).HasColumnName("CUSTOMER_POSTAL_CODE");
builder.Property(p => p.IncidentDate).HasColumnName("INCIDENT_DATE");
builder.Property(p => p.IncidentTypeId).HasColumnName("INCIDENT_TYPE_ID");
builder.Property(p => p.RegionId).HasColumnName("REGION_ID");
builder.Property(p => p.DistrictId).HasColumnName("DISTRICT_ID");
builder.Property(p => p.PoweroffDescription).HasColumnName("POWEROFF_DESCRIPTION");
builder.Property(p => p.PoweroffReasonId).HasColumnName("POWEROFF_REASON_ID");
builder.Property(p => p.NetworkDisadvantageDescription).HasColumnName("NETWORK_DISADVANTAGE_DESCRIPTION");
builder.Property(p => p.NetworkDisadvantageAddress).HasColumnName("NETWORK_DISADVANTAGE_ADDRESS");
builder.Property(p => p.NetworkDisadvantageReasonId).HasColumnName("NETWORK_DISADVANTAGE_REASON_ID");
builder.Property(p => p.OverallPassageLightingDescription).HasColumnName("OVERALL_PASSAGE_DESCRIPTION");
builder.Property(p => p.OverallPassageLightingAddress).HasColumnName("OVERALL_PASSAGE_ADDRESS");
builder.Property(p => p.OverallPassageLightingReasonId).HasColumnName("OVERALL_PASSAGE_REASON_ID");
builder.Property(p => p.PartialPassageLightingDescription).HasColumnName("PARTIAL_PASSAGE_DESCRIPTION");
builder.Property(p => p.PartialPassageLightingAddress).HasColumnName("PARTIAL_PASSAGE_ADDRESS");
builder.Property(p => p.PartialPassageLightingReasonId).HasColumnName("PARTIAL_PASSAGE_REASON_ID");
builder.Property(p => p.IrrelevantCallDescription).HasColumnName("IRRELEVANT_CALL_DESCRIPTION");
builder.Property(p => p.IrrelevantCallReasonId).HasColumnName("IRRELEVANT_CALL_REASON_ID");
}
public override void Configure(QueryTypeBuilder <BlogsView> builder)
{
builder.ToView("BolgViews");
base.Configure(builder);
}
public void Configure(QueryTypeBuilder <WebSpecialView> builder)
{
builder.ToView("WebSpecialView");
}
public void Configure(QueryTypeBuilder <ViewBasedEntity> builder)
{
builder.ToView("ViewBasedEntities");
builder.HasOne(entity => entity.TableEntity).WithMany().HasForeignKey(view => view.Id);
builder.HasOne(entity => entity.Role).WithMany();
}
public void Configure(QueryTypeBuilder <BlogPostsCount> builder)
{
//配置视图查询
builder.ToView("View_BlogPostCounts")
.Property(b => b.BlogName).HasColumnName("Name");
}