AutoQuery in the NorthWind example

ServiceStack Auto Query
1

Anyone have tried to test AutoQuery in the NorthWind example?
I have added the ServiceStack.Server dependency to the solution, then:

Plugins.Add(new AutoQueryFeature { MaxLimit = 100 });

container.Register<IDbConnectionFactory>(
                new OrmLiteConnectionFactory("~/Northwind.sqlite".MapHostAbsolutePath(), SqliteDialect.Provider));

and then in the Orders:

[Route("/orders")]
[Route("/orders/page/{Page}")]
[Route("/customers/{CustomerId}/orders")]
public class Orders : QueryBase<Order>
{
        public int? Page { get; set; }

        public string CustomerId { get; set; }
}

but if I try, for example, to query: /orders?OrderByDesc=Id I can’t have the Orders list in descending order…
Where I’m wrong?

2

I’ve gone ahead and enabled AutoQuery support to Northwind example in this commit and everything’s still working as expected, the url to order orders by descending works:

Are you sure you haven’t created conflicts with existing Services? Otherwise I’m not sure what you did wrong, just clone the latest Northwind Repo and start with that.

3

Hi mythz, yes… it was a conflict error.
I registered AutoQuery on the same route of my service… but after I added a new different route:

[Route("/query/orders")]
public class QueryOrders : QueryBase<Order> { }

everything worked as expected.
Thank you!