Stack Overflow
Stack Overflow

Questions tagged [servicestack-autoquery]

40 questions
1
vote
1 answer

How to call ServiceStack AutoQuery from AspNetCore HostedService

So I understands that ServiceStack is a different framework to AspNetcore, let's say a loyalty system where a user choose some criteria in filtering some customers using ServiceStack Autoquery, system will periodically send some newsletter to them,…
Steven Li
  • 754
  • 1
  • 8
  • 16
1
vote
1 answer

Filtering AutoQuery Results to Only Display Table Rows that Match Data in the Users Session

I'm working on a project that want's to control data access in a multi-tenant system. I've got a table set up which has a row on it that says what tenant the object applies to. Let's call this property ClientObject.ClientOrgId I want to set…
Patrick
  • 13
  • 4
1
vote
1 answer

How can I convert OData to ServiceStack AutoQuery?

I have a Web API project that uses OData to query the database. But now I want to transform this project using ServiceStack AutoQuery. The problem is that I don't have access to the frontend. So the incomming requests are using the OData filter…
Nesse
  • 373
  • 4
  • 14
1
vote
1 answer

ServiceStack AutoQuery - Table not accessibele

When I try to use the IncludeTables property, the table is not generated or is not accessible using the AutoQuery API. When calling /metadata I only see these two endpoints: CancelRequest GetFile Is there a way to debug this or does someone know…
Nesse
  • 373
  • 4
  • 14
1
vote
1 answer

Servicestack AutoQuery -> System.TypeLoadException Error

I'm trying to servicify an existing RDBMS with C# AutoQuery, but getting this error: HResult=0x80131522 Message=Type 'WebApplication1.ServiceModel.CreateCurrency' from assembly 'tmpCrudAssembly, Version=0.0.0.0, Culture=neutral,…
Nesse
  • 373
  • 4
  • 14
1
vote
0 answers

Autoquery servicestack ILeftJoin issue with table.id column

I have definition of autoquery dto defined as below: [Route("/project/{ProjectId}/contracts/{ContractId}/items")] public class QueryContractItem : QueryDb, ILeftJoin
marcinn
  • 1,879
  • 2
  • 22
  • 46
1
vote
1 answer

ServiceStack AutoQuery Is Null for Asp.Net.Core and NullReferenceException thrown at CreateQuery

I've done the Plugins.Add(new AutoQueryFeature { MaxLimit = 100 }); and used it in startup Configure Method. This is dto inherites QueryDb I keep encountering AutoQuery is null and NullReferenceException thrown at AutoQuery.CreateQuery() Method.…
Steven Li
  • 754
  • 1
  • 8
  • 16
1
vote
1 answer

How to manage separation of concerns when using ServiceStack AutoQuery

I am having some issues with how to organise my AutoQuery code. My project structure currently looks like: /Project /Project.ServiceInterface Service.cs /Project.Logic Manager.cs /Types DbModel.cs /Project.ServiceModel Request.cs …
Will
  • 57
  • 4
1
vote
1 answer

Using Servicestack, how do you cache result sets when using AutoQuery with a ServiceSource?

I am trying to use ServiceStack's AutoQuery with a service source, but am either unable to get caching working correctly, or have misunderstood how it is supposed to work. What I am trying to achieve to to add query functionality to an 'edge'…
Jay
  • 9,561
  • 7
  • 51
  • 72
1
vote
1 answer

ServiceStack AutoQuery crash on synthetic field

This is a follow up on: ServiceStack AutoQuery synthetic field .NET Core empty web template on newest 5.x versions of SS and .Net Core. I'm trying to create an AutoQuery service that I can decorate with a few synthetic fields (i.e. fields that…
specimen
  • 1,735
  • 14
  • 23
1
vote
1 answer

How do I get second level public properties in ServiceStack

I have the following POCOs in my service model: public class Personnel { ... [Ignore] [Reference] public List _Postings { get; set; } } public class Posting { ... [Reference] [Ignore] public Personnel…
Olushola Alabi
  • 11
  • 2
1
vote
1 answer

How to get nested element using ServiceStack?

Although I am able to access the SchemaVersion using code below, I cannot access FormatDocID nested element. Any ideas how can I easily get FormatDocID using ServiceStack and AutoQueryFeature (or similar)? I put only relevant parts of code…
essential
  • 648
  • 1
  • 7
  • 19
1
vote
1 answer

xUnit testing Servicestack AutoQuery

first time using AutoQuery and I have this problem with unit testing after implementing AutoQuery. It works fine through Swagger manual testing. So I have a get method like this: public class ItemService : Service { public IAutoQueryDb AutoQuery {…
Mike
  • 151
  • 1
  • 4
  • 14
1
vote
1 answer

AutoQuery can't query nested object

AutoQuery could not find field I have the following clases: [Route("/query/domains")] public class QueryDomains : QueryDb { public int MajesticApiDataTF { get; set; } } public class DomainList { public string DomainName…
Guerrilla
  • 13,375
  • 31
  • 109
  • 210
1
vote
1 answer

AutoQuery / Ormlite-servicestack: Can I filter out soft deletes on a QueryDb class?

We have a few services built up with Ormlite/Servicestack and we are mostly pulling out database objects and POCOs using QueryData with custom logic. However, we have one table that really doesn't need to be logically expanded on and works just fine…
joh04667
  • 7,159
  • 27
  • 34
1
2
3