public override string GetFullSelectSql(string select = null) { if (select == null) { select = SelectHelper.CreateSelectHeader(_headers, GetTypes()); } if (select.TrimStart().StartsWith("SELECT ", StringComparison.OrdinalIgnoreCase) == false) { select = "SELECT " + select; } StringBuilder sb = new StringBuilder(); sb.Append(select); sb.Append(" "); sb.Append(GetFromAndJoinOn()); //sb.Append(_joinOnString); if (_where.Length > 0) { sb.Append(" WHERE "); sb.Append(_where); } return(sb.ToString()); }
private static string getSelect <T>(WhereHelperBase t, string selectSql) { if (string.IsNullOrEmpty(selectSql) == false) { if (selectSql.StartsWith("Select", StringComparison.CurrentCultureIgnoreCase)) { return(selectSql); } return("SELECT " + selectSql); } return(SelectHelper.CreateSelectHeader(typeof(T), t._headers, t.GetTypes())); }