public override string ToString()
{
if (_Where == null)
{
return(String.Format("{0} {1} {2}", _FieldLeft, ConvertSQLComparator(_Comparator), _FieldRigth));
}
return(String.Format("({0})", _Where.ToString()));
}
public override string ToString()
{
var fields = String.Join("\r\n,", _Fields.Select(field => CreateFieldSQL(field.Value)).ToArray());
var from = CreateFromSQL();
var top = string.Empty;
if (_TopValue != null)
{
top = String.Format("\nTOP({0})\r\n", _TopValue);
}
var joins = String.Empty;
if (_Joins.Count > 0)
{
joins = String.Join("\r\n", _Joins.Select(join => join.ToString()).ToArray());
}
var where = String.Empty;
if (_Where != null && _Where.Count > 0)
{
where = String.Format("WHERE \r\n{0}", _Where.ToString());
}
var groupBy = String.Empty;
if (_GroupBy.Count > 0)
{
groupBy = String.Format("GROUP BY \r\n{0}", String.Join("\r\n,", _GroupBy.Select(field => field).ToArray()));
}
var orderBy = String.Empty;
var offSet = String.Empty;
if (_OrderBy.Count > 0)
{
orderBy = String.Format("ORDER BY \r\n{0}", String.Join("\r\n,", _OrderBy.Select(field => field.ToString()).ToArray()));
if (_OffSet != null)
{
offSet = _OffSet;
}
}
var having = String.Empty;
if (_Havind != null)
{
having = String.Format("HAVING \r\n{0}", _Havind.ToString());
}
var union = String.Empty;
if (_Union.Count > 0)
{
foreach (var u in _Union)
{
union += u.Key + "\r\n";
union += u.Value.ToString() + "\r\n";
}
}
return(String.Format("SELECT{8}{9}\r\n{0}\r\n{1}\r\n{2} \r\n{3} \r\n{4} \r\n{5} \r\n{6} \r\n{7} \r\n{10}", fields, from, joins, where, groupBy, having, orderBy, offSet, _Distinct, top, union).Trim());
}
