Sample Class:
public class DocumentMap : EntityTypeConfiguration<DocumentEntity>
{
public DocumentMap()
{
// Primary Key
this.HasKey(t => t.ID);
// Properties
this.Property(t => t.ID)
.HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);
this.Property(t => t.Name)
.IsRequired();
this.Property(t => t.DocumentLocationID)
.IsRequired();
this.Property(t => t.DocumentUrl)
.IsRequired();
this.Property(t => t.DocumentTypeID)
.IsRequired();
this.Ignore(t => t.DocumentType);
this.Ignore(t => t.DocumentLocation);
this.Ignore(t => t.Document);
this.Ignore(t => t.FilePath);
this.Ignore(t => t.FileType);
this.Ignore(t => t.TemporaryURL);
this.Ignore(t => t.DestinationPath);
//this.Ignore(t => t.DestinationURL);
// Table & Column Mappings
this.ToTable("DOCUMENT");
this.Property(t => t.ID).HasColumnName("DOC_ID");
this.Property(t => t.Name).HasColumnName("DOC_NM");
this.Property(t => t.DocumentLocationID).HasColumnName("DOC_REF_LOC_TP_RD_ID");
this.Property(t => t.DocumentUrl).HasColumnName("DOC_REF_URL");
this.Property(t => t.DocumentTypeID).HasColumnName("DOC_TYPE_RD_ID");
this.Property(t => t.DocumentVersion).HasColumnName("DOC_VERSION");
this.Property(t => t.DocumentReceivedBy).HasColumnName("DOC_RECEIVED_BY");
this.Property(t => t.DocumentReceivedDt).HasColumnName("DOC_RECEIVED_DT");
this.Property(t => t.IsDocumentDelivered).HasColumnName("DOC_DELIVERED_FLG");
}
}
The output should be like: Class name, Property name, Table name, Colmun name. Eg:
ModelClass PropertyName TableName TableColumn
DocumentEntity ID DOCUMENT DOC_ID
DocumentEntity Name DOCUMENT DOC_NM
This should be exported to a CSV file using c# so that the CSV file contains ModelClass, PropertyName, TableName and TableColumn
Aucun commentaire:
Enregistrer un commentaire