public String GetTableAlias() { var sqlFromClause = Clauses.First(o => o.Name == "FROM"); var startIndex = sqlFromClause.InputText.LastIndexOf(" AS "); return(startIndex > 0 ? sqlFromClause.InputText.Substring(startIndex + 4) : ""); }
public void ChangeToDelete() { Validate(); var sqlClause = Clauses.FirstOrDefault(); var sqlFromClause = Clauses.First(o => o.Name == "FROM"); if (sqlClause != null) { sqlClause.Name = "DELETE"; sqlClause.InputText = sqlFromClause.InputText.Substring(sqlFromClause.InputText.LastIndexOf("AS ") + 3); } }