Store and query JSON data with typed C# 🧩 📹 New video: OrmLite maps classes and lists to JSON columns - and lets you query inside them across SQLite, PostgreSQL, SQL Server & MySQL. No extra tables. No raw SQL.

Advanced SQL doesn’t have to mean raw SQL strings 🧵 See how OrmLite brings Recursive CTEs, Window Functions, Top N Per Group & Temporal Tables to typed C#

Your query is fast. What about everything around it? New #OrmLite video: • Batch 1,000 inserts up to 8.5× faster—same code • Compile queries: generate SQL once • SeekAfter: page 1,000 in 0.23 ms vs 33.95 ms Benchmarks, SQL, and trade-offs 👇

💸 Two requests deposit $10. Both succeed. One deposit disappears. Your C# code looks correct. Your database balance isn’t. 😬 🎬 New OrmLite video: prevent lost updates with row locks, plus SKIP LOCKED queues, RETURNING & UPSERTS.

Your C# model changed. Your database table didn’t. ▶️ Our latest OrmLite video covers schema diffs, auto generated migrations, likely rename detection, and startup warnings when models and tables drift apart - with a new browser UI and CLI workflow. #dotnet #csharp

OrmLite gives you a huge surface of typed APIs with LINQ expressions. But when you need custom SQL, you don't have to give up safety. Sql.Fmt lets you write C# interpolated strings, and every {value} is sent as a db param: Sql.Fmt($"Author = {author}") → WHERE Author = @p0

One prompt → an interactive 3D Customer Galaxy 🌌 Another → a 10-slide Monthly Business Review 📊 See how ServiceStack AI Chat turns your .NET APIs into dashboards and reports, right inside your app. ⚡ #dotnet #AI

🎥 New Multitenancy video In a multi-tenant app, one query that forgets `WHERE TenantId` returns all customer's data, without error. OrmLite's connection filters let you declare the tenant rule once, on the connection, and every typed query, update, delete and join follows it