Exemplos de Criterion.FromSql em C# (CSharp)

Exemplo n.º 1

            IDatabaseQuery WhereSubquery(string myField, IDatabaseQuery subquery, string targetField, string @operator)
            {
                subquery.AliasPrefix = "Subq" + Guid.NewGuid().ToString().Remove("-").Substring(0, 6);

                var sql = subquery.Provider
                          .GenerateSelectCommand(subquery, subquery.MapColumn(targetField));

                sql = $"{MapColumn(myField)} {@operator} ({sql})";
                Criteria.Add(Criterion.FromSql(sql));

                foreach (var subQueryParam in subquery.Parameters)
                {
                    Parameters.Add(subQueryParam.Key, subQueryParam.Value);
                }

                return(this);
            }