public string GetSelect() { var fieldsAtr = new List <string>(); var fields = new List <string>(); foreach (var campo in _campos) { fieldsAtr.Add($"{campo.Atributo} as \"{campo.Atributo}\""); fields.Add($"{campo.Nome} as {campo.Atributo}"); } var sql = $"select {string.Join(", ", fieldsAtr)}" + $" from (select {string.Join(", ", fields)} from {_tabela.Nome})" + (!string.IsNullOrWhiteSpace(_where) ? $" where {_where}" : string.Empty); if (_qtde != -1) { sql = _tipoDatabase.GetSelectLim(sql, _qtde, _pagina); } return(sql); }
//-- limits public static string GetSelectLim <TObject>(this TipoDatabase tipoDatabase, string sql, int qtde, int pagina = 0) { return(tipoDatabase.GetSelectLim(sql, qtde, pagina)); }