I have some entities to implement the business function. and in addition I have log entity to log the modifies on all entites.
for example:
I have a UI to allow users to Add/Modify/Delete an Entity named "EmployeeEntity" and and Entity to log operations on "EmployeeEntity" which named "LogEntity",their schemes as bellow:
EmployeeEntity--->EmployeeName
--->BirthDay
LogEntity--->OperatorName
--->OperateType
--->OperateDate
--->OperateSQL
when users add an new EmployeeEntity to database,the code should be like that:
EmployeeEntity newEmployee=new EmployeeEntity();
newEmployee.EmployeeName="Jhon";
newEmployee.BirthDay=new DateTime("1982-01-01");
newEmployee.Save();
//Log user's operation(s)
LogEntity log=new LogEntity();
log.OperatorName="Tom";
log.OperateType="Insert";
log.OperateDate=DateTime.Now;
log.OperateSQL="insert into Employee(EmployeeName,BirthDay) values('Jhon','1982-01-01')";
log.Save();
Notice the red code:
log.OperateSQL="insert into Employee(EmployeeName,BirthDay) values('Jhon','1982-01-01')";
how can I get the sql statement automaticly or by some methods provider by LLBLGen other than write this manually myself?
So does Modify and Delete operations