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