public IFluentSqlQueryBuilder SelectCustom(string selectCustomColumn, params string[] columns) { _selectType = SqlSelectType.Custom; _selectCustomColumn = selectCustomColumn; _selectedColumns = columns; return(this); }
public string Build(SqlSelectType type) { if (string.IsNullOrWhiteSpace(_tableName)) { throw new ArgumentNullException(nameof(_tableName)); } var alias = _tableName.TableNameAlias(); switch (type) { case SqlSelectType.All: return(BuildSelectAllStatement(alias)); case SqlSelectType.Count: return("SELECT COUNT(*)"); case SqlSelectType.Specific: return(BuildSpecifcSelectStatment(alias)); case SqlSelectType.Custom: return(BuildCustomSelectStatment(alias)); default: return(BuildSelectAllStatement(alias)); } }
public IFluentSqlQueryBuilder SelectSpecific(params string[] columns) { _selectType = SqlSelectType.Specific; _selectedColumns = columns; return(this); }
public IFluentSqlQueryBuilder SelectCount() { _selectType = SqlSelectType.Count; return(this); }
public IFluentSqlQueryBuilder SelectAll() { _selectType = SqlSelectType.All; return(this); }