public void Add_WhenAddingSubQuery_Adds() { var expected = @"SELECT Id, Name"; var clause = new SelectClause(null); clause.Add("Id"); clause.Add("Name"); clause.GetQueryString().Should(Be.EqualTo(expected)); }
private string GetQueryStringForCurrentQuery() { var buf = new IndentingStringBuilder(); if (selectClause == null) selectClause = new SelectClause(this); if (selectClause != null) buf.AppendLine(selectClause.GetQueryString()); if (fromClause != null) buf.AppendLine(fromClause.GetQueryString()); if (whereClause != null) buf.AppendLine(whereClause.GetQueryString()); if (groupByClause != null) buf.AppendLine(groupByClause.GetQueryString()); if (havingClause != null) buf.AppendLine(havingClause.GetQueryString()); if (orderByClause != null) { if (IsSubQuery == false) buf.AppendLine(orderByClause.GetQueryString()); } return buf.ToString(); }