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);
}
}
