ServiceStack Blog - ServiceStack

Cover Image for Query JSON like any other property in OrmLite

Query JSON like any other property in OrmLite

October 21, 2026

ServiceStack v10.4 lets typed OrmLite queries read straight into complex type properties with x.Address.City or x.Lines.Any(...), using the native JSON functions of SQLite, PostgreSQL, SQL Server and MySQL, plus a complete tour of everything else OrmLite can do with JSON

Author

More from the blog

Article

Advanced SQL queries in typed OrmLite

ServiceStack v10.4 adds typed recursive queries, named sub queries, window functions with TopPerGroup, Union/Intersect/Except, SeekAfter keyset paging and async streaming, so the queries that used to need hand-written SQL stay typed, parameterized and portable

Advanced SQL queries in typed OrmLite background

October 20, 2026 12 min read

Article

Safe SQL by default in OrmLite

ServiceStack v10.4 adds Sql.Fmt() for interpolated SQL where every value is a db param, OrderBySafe() for user-selected sort orders, and stronger SQL injection protection across fragment validation, identifier quoting and inlined values

Safe SQL by default in OrmLite background

October 15, 2026 10 min read

Article

Keep your database in sync with your C# models

ServiceStack v10.4 adds Schema Diff to OrmLite, which finds every difference between your C# models and their tables, from columns and types to defaults, indexes, foreign keys and constraints, then writes the migration for you to review, on SQLite, PostgreSQL, SQL Server, MySQL and MariaDB

Keep your database in sync with your C# models background

October 13, 2026 10 min read

Article

Prompt it, Publish it - AI-built works from your .NET APIs

AI Chat puts a ChatGPT-like assistant inside your .NET App, where it calls the APIs the signed-in user is allowed to call and turns the results into interactive views and reports your team can explore, review and publish

Prompt it, Publish it - AI-built works from your .NET APIs background

October 8, 2026 7 min read

Article

Multitenancy that can't be forgotten

ServiceStack v10.4 moves tenant isolation from every query to the database connection, with OrmLite connection filters and write rules that confine selects, updates, deletes, inserts and AutoQuery APIs to the request's tenant, fail closed until it's known, and record trusted audit columns on every write

Multitenancy that can't be forgotten background

October 7, 2026 14 min read

Article

Follow every request with OpenTelemetry

ServiceStack v10.3 emits standard OpenTelemetry traces and metrics that follow a request from its API call through outbound HTTP calls, MQ messages and Background Jobs, even across servers, in Jaeger, Grafana Tempo, Honeycomb, Datadog or the .NET Aspire Dashboard

Follow every request with OpenTelemetry background

October 6, 2026 7 min read

API Rate Limiting

ServiceStack v10.3 adds opt-in ASP.NET Core rate limiting for ServiceStack APIs - bind a named policy to a Request DTO or share one budget across every API with the same Tag, enforced across every route an API can be called from

API Rate Limiting background

October 5, 2026 7 min read

Software Licensing Next.js Project Template

Next License is a new .NET 10, ServiceStack and Next.js 16 template for selling perpetual, offline-verified JWT licenses for your .NET and Electron desktop apps, with Stripe Checkout, GitHub-hosted downloads and an Operations Center, and no activation server to run

Software Licensing Next.js Project Template background

October 1, 2026 10 min read

SaaS Next.js Project Template

Next SaaS is a new production-ready .NET 10, ServiceStack and Next.js 16 template for multi-tenant B2C and B2B SaaS products, with organizations, Stripe subscriptions, versioned plans, usage quotas and an Operations Center included from day one

SaaS Next.js Project Template background

September 30, 2026 11 min read

Scalable Background Jobs

ServiceStack v10.3 turns Background Jobs into a durable job platform - scale out across App Servers, queues with runtime controls, exactly-once guarantees, workflows, batches and production-grade schedules, all on the database you already run

Scalable Background Jobs background

September 29, 2026 10 min read

Startup Tasks - Generate code from your running App

StartupTasks run dev-time tasks once your App has fully started, keeping client DTOs and other generated code in sync with your server on every restart, with no extra build step for developers or AI Assistants to remember

Startup Tasks - Generate code from your running App background

September 16, 2026 5 min read

OrmLite gets type-safe JSON access and Upserts

Query JSON columns with typed C# expressions that run unchanged on SQLite, PostgreSQL, SQL Server and MySQL, and insert-or-update rows in a single native statement with the new Upsert APIs

OrmLite gets type-safe JSON access and Upserts background

September 14, 2026 10 min read

Hardened ServiceStack - A Codebase-Wide Security & Reliability Audit

ServiceStack v10.2 ships the results of an AI-assisted security and reliability audit across 36 packages, with every fix published for review - your Apps get safer defaults just by upgrading

Hardened ServiceStack - A Codebase-Wide Security & Reliability Audit background

September 11, 2026 8 min read

Gemini RAG - AI Answers Customers can Verify from your Content

Turn the files, docs and websites you already maintain into managed knowledge bases, then publish a citation-backed AI Assistant and instant, model-free Website Search to any site with one script tag

Gemini RAG - AI Answers Customers can Verify from your Content background

September 10, 2026 14 min read

ServiceStack PDF Studio — From AI Design to Production PDFs

Design Typst PDFs with AI Chat, publish validated templates, generate typed C# models and render production documents from your ServiceStack APIs

ServiceStack PDF Studio — From AI Design to Production PDFs background

September 4, 2026 13 min read

Instant CRUD Apps with AutoQuery Schemas

Give AutoQuerySchema one /auto/{DataModel}.json document and it renders a complete, authorized CRUD application

Instant CRUD Apps with AutoQuery Schemas background

September 1, 2026 13 min read

Richer APIs and Auto UIs with API Schemas

Every ServiceStack API now includes a portable schema that lets generic UIs describe, render and execute it

Richer APIs and Auto UIs with API Schemas background

August 31, 2026 20 min read

Instant AI Integration: Expose ServiceStack APIs to LLMs & MCP

Turn your existing ServiceStack APIs into safe, discoverable AI tools for AI.Chat and every MCP-compatible assistant like Claude Code, Claude Desktop, Codex and OpenCode.

Instant AI Integration: Expose ServiceStack APIs to LLMs & MCP background

August 25, 2026 18 min read

AI Chat v4: A full-featured AI Assistant integrated with your APIs and Auth

Multi-provider chat, RAG, PDF Studio, tools, skills, mcp, projects and agents in one App - unleashing AI intelligence on your existing APIs

AI Chat v4: A full-featured AI Assistant integrated with your APIs and Auth background

August 24, 2026 18 min read

Typed ServiceStack APIs for Go, Rust, Ruby and Zig

Add ServiceStack Reference now brings end-to-end typed APIs to 15 of the world's most popular programming languages-from websites and mobile apps to cloud services and systems software.

Typed ServiceStack APIs for Go, Rust, Ruby and Zig background

August 13, 2026 10 min read

Next.js React Server Components - Secure Design

How the Next.js RSC template architecture protects against React Server Components vulnerabilities through process isolation and defense-in-depth security

Next.js React Server Components - Secure Design background

December 15, 2025 10 min read

view all posts

ServiceStack

ServiceStack started development in 2008 with the mission of creating a best-practices services framework with an emphasis on simplicity and speed

more information