示例#1
0
        public override void ConfigureCommand(NpgsqlCommand command)
        {
            var sql    = Selector.ToSelectClause(_mapping);
            var @where = _schema.BuildWhereFragment(_mapping, _query);



            sql = sql.AppendWhere(@where, command);

            var orderBy = _query.ToOrderClause(_mapping);

            if (orderBy.IsNotEmpty())
            {
                sql += orderBy;
            }

            sql = _query.AppendLimit(sql);
            sql = _query.AppendOffset(sql);

            command.AppendQuery(sql);
        }