private void UpdateSQL() { queryBuilder = new CreateTriggerQueryBuilder(TriggerName) .IfNotExists(IsIfNotExists) .On(selectedTarget) .ForEachRow(IsForEachRow) .When(whenExpression) .Do(triggerActions); SetEntryPoint(); SetEvent(); Sql = queryBuilder.Build(); }
private void SetEntryPoint() { if (string.IsNullOrEmpty(selectedTriggerEntryPoint)) { return; } if (SelectedTriggerEntryPoint.Equals("BEFORE")) { queryBuilder = queryBuilder.Before(); } else if (SelectedTriggerEntryPoint.Equals("INSTEAD OF")) { queryBuilder = queryBuilder.InsteadOf(); } else { queryBuilder = queryBuilder.After(); } }
private void SetEvent() { if (string.IsNullOrEmpty(selectedTriggerEvent)) { return; } if (selectedTriggerEvent.Equals("INSERT")) { queryBuilder = queryBuilder.Insert(); } else if (selectedTriggerEvent.Equals("UPDATE")) { queryBuilder = queryBuilder.Update(); } else if (selectedTriggerEvent.Equals("UPDATE OF")) { queryBuilder = queryBuilder.Update(Columns.Where(x => x.IsSelected).Select(x => x.ColumnName).ToList()); } else { queryBuilder = queryBuilder.Delete(); } }