public FromSourceTableOrView(string name) { var f = FromSourceTableOrView.Parse(name); _schema = f._schema; _name = f._name; _alias = f._alias; }
public static FromSourceTableOrView Parse(string sqlStatement) { var field = new FromSourceTableOrView(); if (sqlStatement == null) { throw new ArgumentNullException(nameof(sqlStatement)); } sqlStatement = sqlStatement.ClearString(); if (sqlStatement.EndsWith(" AS", StringComparison.OrdinalIgnoreCase)) { sqlStatement = sqlStatement.Substring(0, sqlStatement.Length - 3); } var indexOfAs = sqlStatement.ToUpper().IndexOf(" AS ", StringComparison.OrdinalIgnoreCase); if (indexOfAs > 0) { field._alias = sqlStatement.Substring(indexOfAs + 4).ClearString(); sqlStatement = sqlStatement.Substring(0, indexOfAs).ClearString(); } if (sqlStatement.Contains(".")) { var arr = sqlStatement.Split('.'); field._schema = arr[0].ClearString(); sqlStatement = arr[1].ClearString(); } if (sqlStatement == "*") { field._alias = null; } field._name = sqlStatement; return(field); }
public From AddTableOrView(string schema, string name, string alias) { var t = new FromSourceTableOrView(schema, name, alias); return(AddTableOrView(t)); }
public From AddTableOrView(string name) { var t = new FromSourceTableOrView(name); return(AddTableOrView(t)); }
public From AddTableOrView(FromSourceTableOrView sourceTableOrView) { _fromSources.Add(sourceTableOrView); return(this); }