private void TestConnection() { using (var ctx = new Audit.SqlServer.Entities(_connectionString)) { ctx.Database.Connection.Open(); ctx.Database.Connection.Close(); } }
public override object InsertEvent(AuditEvent auditEvent) { var json = auditEvent.ToJson(); using (var ctx = new Audit.SqlServer.Entities(_connectionString)) { var cmdText = string.Format("INSERT INTO [{0}] ([{1}]) OUTPUT INSERTED.[{2}] VALUES (@json)", _tableName, _jsonColumnName, _idColumnName); var eventId = ctx.Database.SqlQuery <long>(cmdText, new SqlParameter("@json", json)).FirstOrDefault(); return(eventId); } }
public override void ReplaceEvent(object eventId, AuditEvent auditEvent) { var json = auditEvent.ToJson(); using (var ctx = new Audit.SqlServer.Entities(_connectionString)) { var ludScript = _lastUpdatedDateColumnName != null?string.Format(", [{0}] = GETUTCDATE()", _lastUpdatedDateColumnName) : string.Empty; var cmdText = string.Format( "UPDATE [{0}] SET [{1}] = @json{2} WHERE [{3}] = @eventId", _tableName, _jsonColumnName, ludScript, _idColumnName); ctx.Database.ExecuteSqlCommand(cmdText, new SqlParameter("@json", json), new SqlParameter("@eventId", eventId)); } }