17,740
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[OperationLog](
[OptID] [int] IDENTITY(1,1) Primary Key NOT NULL,
[LogSource] [varchar](5) NOT NULL,
[OperaterID] [int] NOT NULL,
[Module] [varchar](10) NOT NULL,
[Operation] [varchar](50) NULL,
[AtDateTime] [datetime] NULL,
[OptKeyValue] [varchar](50) NULL
)
OperationLog log = new OperationLog();
EntityQuery<OperationLog> logQuery = new EntityQuery<OperationLog>(log, true);
log.OperaterID = 999;
log.Module = "Test";
log.Operation = "Test Opt";
log.LogSource = "Test";
int affectCount = logQuery.Save();
Console.WriteLine("自动保存成功(insert),id={0}",log.OptID);
log.Operation = "Test Opt No.2";
affectCount = logQuery.Save();
Console.WriteLine("自动保存成功(update)");