public void AjouterSelectCount(Requete requete, Type type)
{
var rr = _connectionFactory.ObtenirNomTable(type);
_type = type;
_sb = new StringBuilder();
var(parameters, listParamsWhere) = requete.GetWhere(type);
_paramsSql = listParamsWhere.ToArray();
_sb.AppendLine($"select count(*) from {_connectionFactory.ObtenirNomTable(_type)}");
}
public void AjouterSelectFrom(Requete request, Type type)
{
var tt = _connectionFactory.ObtenirNomTable(type);
var(dynamicParameters, listParams) = request.GetWhere(type);
_type = type;
_sb = new StringBuilder();
_objectParameters = dynamicParameters;
_paramsSql = listParams.ToArray();
_sortDescriptor = request.Ordres?.FirstOrDefault();
_sb.AppendLine($"select {_type.Sql().GetParamsWithCommas()}");
_sb.AppendLine($"from {_connectionFactory.ObtenirNomTable(type)}");
}