public ResultSet SelectSql(string[] tables, string[] columns, Filter filter, OrderBy[] orderBys, int skip, int take)
 {
     return new ResultSet();
 }
Example #2
0
        public virtual ResultSet SelectSql(string[] tables, string[] columns, Filter filter, OrderBy[] orderBys, int skip, int take)
        {
            var selectBuilder = new SelectBuilder(Dialect, tables, columns);
            selectBuilder.Filter = filter;
            selectBuilder.OrderBys = orderBys;
            selectBuilder.Skip = skip;
            selectBuilder.Take = take;

            string sql = selectBuilder.Build();
            if (selectBuilder.HasFilter) {
                return Database.Query(sql, selectBuilder.Parameters);
            }
            return Database.Query(sql);
        }