That's all that's needed! From your contract-first API blueprint ServiceStack implements a fully queryable, type safe API for the Customer table.
Connect your existing database and configure AutoQuery to use AutoGen to generate typed end to end HTTP services for your database tables.
ServiceStack’s AutoGen enables a number of exciting possibilities, predominantly it’s the fastest way to ServiceStack-ify an existing systems RDBMS where it will serve as an invaluable tool for anyone wanting to quickly migrate to ServiceStack and access its functionality ecosystem around ServiceStack Services
AutoGen’s code generation is programmatically customizable where the generated types can be easily augmented with additional declarative attributes to inject your App’s conventions into the auto generated Services & Types to apply custom behavior like Authorization & additional validation rules.
After codifying your system conventions the generated classes can optionally be “ejected” where code-first development can continue as normal.
Seamlessly integrates with ServiceStack's endpoints, features and tools for maximum reuse and simplified integrations.
Manage your AutoQuery services with ServiceStack Studio, a dynamic, capability driven UI that only needs your ServiceStack instance base URL for integration. Metadata from ServiceStack service message contracts are able to drive completely dynamic user interfaces, enabling smart clients to deliver amazing levels of reuse.
ServiceStack/Studio is an Open Source Chromium Windows Desktop App that can be easily customized to support custom App requirements and published via multiple deployment options with a tiny footprint and built-in auto updates.
As all AutoQuery Services are pure HTTP APIs available in multiple data formats they allow for simple, rich integrations like being able to use its CSV Format to create live table data sources in Excel or easily import any query into any data store supporting CSV imports:
AutoQuery's usage of simple, user-defined Clean URLs and intuitive implicit query conventions makes it easy for stakeholders to create custom Queries of their Systems Data that they can link to directly in their Excel worksheets to generate Live Reports:
AutoQuery services are ServiceStack services, so they benefit from the ServiceStack ecosystem of features. This makes responding to changing requirements more straight forward as all these features are designed from the ground up to work together with clean consistent APIs.
ServiceStack Plugins use the same interfaces that your custom plugins can use, giving you the ability to extend and expand your service features consistently across AutoQuery or standard ServiceStack services.
Expose data from various data sources including RDBMS, In memory, DynamoDb or even other services through consistent flexible APIs where clients can control the query details.
AutoQuery RDBMS works with anything OrmLite can connect to, including:
Unlike OData and GraphQL, AutoQuery provides clean REST services making them easy to use from standard browsers, avoiding the requirement for complex clients.
Add ServiceStack Reference provides best in class client generation in a multitude of languages straight from the server you're integrating with.
Instant Client Apps can generate working native client solutions through an easy to use free web tool, only needing a base URL of a ServiceStack service.
appdotnet tool by running install/app.ps1 with Windows Run dialog (
AutoQuerybutton to access Chinook's AutoQuery APIs:
You can also try AutoQuery on your own databases in larger Systems exceeding the Free Quotas with an unrestricted 30 Day Free Trial.