public ResultSet SelectSql(string[] tables, string[] columns, Filter filter, OrderBy[] orderBys, int skip, int take)
{
return new ResultSet();
}
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);
}