Why are audit columns excluded from class definition?

In your Spark documentation on Page 42 you mention thefollowing: “If you have an Order table to represent orders, don’t rely on theCreatedOn column to determine the date of the order; instead include a separateOrderDate”

What was the reason for not including audit columns in theclass definition itself and use them straight away? For instance in the case ofArtist class in Domain.CS you have defined this class without four audit columnsbut the database definition itself has these four columns. Why did you excludethe following columns

        public System.DateTime CreatedOn { get; set; }

        public int? CreatedBy { get; set; }

        public System.DateTime ChangedOn { get; set; }

        publicint? ChangedBy { get; set; }

in class definition itself.How would you make use of audit columns in your program? The only possible way which comes to my mind is querying the database straight away like the following (In the case of CreatedOn column for instance):

Define a new property on Artist class called [CreatorName :Please note I didn't even call it CreatedOn to avoid possible future conflict with audit columns] as follows :

        public string CreatorName {get{ return ArtContext.Scalar("select a.FirstName+ ' ' + a.LastName from [user] ainner join artist b on a.Id = b.CreatedBy where a.Id = @0",parms:1).ToString();}}  

If above is the intended solution, wouldn't it be easier tohave all those four fields included in the class definition (just like other columns) and populate them along with other class members rather than relyingon extra fields which should be populated at run time?

Update 1:
King Wilder: I created a class called AuditData as follows:

    public sealed class AuditData

    {

        public string CreatedBy { get; set; }

 

        public DateTime CreatedDate { get; set; }

 

        public string UpdatedBy { get; set; }

 

        public DateTime UpdatedDate { get; set; }

    }

And now inside the Artist I have added a property as follows:

        public AuditData AudiData

        {

            get

            {

                const string sql = @"SELECT (SELECTFirstName+ ' ' + LastName FROM [User] WHERE Id = b.CreatedBy) AS CreatedBy,b.CreatedOn AS CreatedDate,

                                               (SELECTFirstName+ ' ' + LastName FROM [User] WHERE Id = b.ChangedBy) ASUpdatedBy,b.ChangedOn AS UpdatedDate FROM [Artist] b WHERE b.Id = @0";

               

                var temp = ArtContext.GetDataRow(sql, parms:Id);

 

                var data = new AuditData

                                 {

                                     CreatedBy = temp.Field<string>("CreatedBy"),

                                    CreatedDate = temp.Field<DateTime>("CreatedDate"),

                                     UpdatedBy = temp.Field<string>("UpdatedBy"),

                                    UpdatedDate = temp.Field<DateTime>("UpdatedDate")

                                 };

 

                return data;

            }

        }

You suggest moving this property to the base class in which this entity is derived from to avoid SRP violation? Irrespective of where this property is located something like above is required, right? I don’t understand why above violates SRP? How do you populate AuditData? I need to be able to display audit data to the user and auditing facility is quite important for me.

 

Kind regards,