skills.rest
erikshafer
erikshaferCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

polecat-document-store

Manage SQL Server document stores with LINQ queries and soft deletes.

Updated Apr 21, 2026
Search Tags:#SQL Server#document database#LINQ#Polecat#soft deletes#patch operations
One-click install
npx skills add https://github.com/erikshafer/CritterCab --skill polecat-document-store
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: polecat-document-store
Source: https://github.com/erikshafer/CritterCab/tree/main/docs/skills/polecat-document-store
Command: npx skills add https://github.com/erikshafer/CritterCab --skill polecat-document-store

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Polecat, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies managing and querying document databases within the CritterCab architecture using the Polecat library.

Core Features & Use Cases

  • Document Management: Store, update, and delete documents within a SQL Server-backed document store.
  • LINQ Queries: Execute LINQ queries against documents for data retrieval.
  • Soft Deletes: Implement soft deletes for document records with various options.
  • Patch Operations: Perform partial updates on documents using the patching API.
  • Concurrency Control: Handle document-level concurrency using IVersioned and IRevisioned interfaces.
  • Use Case: For the Payments BC in CritterCab, this Skill is used to manage MerchantConfig documents, PaymentSummary projections, and other non-event-sourced state.

Quick Start

Use the polecat-document-store skill to retrieve a document with the ID '12345'.

Frequently Asked Questions about polecat-document-store

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage document databases in SQL Server using LINQ queries?▼

You can manage document databases in SQL Server by using the Polecat library to store, update, and query JSON documents. It supports executing LINQ queries for efficient data retrieval directly against the stored documents.

Can I perform partial updates on JSON documents instead of replacing the entire record?▼

Yes, you can perform partial updates on JSON documents using the patching API. This allows you to modify specific fields within a document without needing to overwrite the entire document record in the SQL Server database.

How does soft delete work for document records in a SQL Server-backed document store?▼

Soft deletes allow you to mark document records as deleted without actually removing them from the SQL Server database. The Polecat library provides various options to configure and manage soft deletes for your JSON documents.

Do I need SQL Server and Polecat to handle document-level concurrency control?▼

Yes, SQL Server and Polecat are required to handle document-level concurrency control. The system uses `IVersioned` and `IRevisioned` interfaces to manage concurrency and ensure data integrity when updating documents.

What is the best way to store non-event-sourced state for a bounded context like Payments?▼

Using a document database managed by Polecat is an effective way to store non-event-sourced state. It handles JSON documents for configurations and projections, executing T-SQL queries for data manipulation within the architecture.

Related Skills

Explore More Software Engineering Skills→
PracticalSwanPracticalSwan
7

sql-development

Write T-SQL queries, stored procedures, and SQL Server schemas.

Community
Advanced
erikshafererikshafer

marten-querying

Query Marten event store documents and projections using LINQ, compiled, batched, and raw SQL.

Community
Advanced
doanchienthangdevdoanchienthangdev
4

Event Sourcing

Implement event sourcing patterns with immutable event streams and projections.

Community
Advanced
erikshafererikshafer

polecat-event-sourcing

Implement event sourcing and document database management with Polecat in CritterCab.

Community
Advanced