Standardizes C# database integration across DuckDB, PostgreSQL, MySQL, and legacy ODBC systems using optimized implementation patterns.
This skill provides Claude with specialized knowledge for implementing robust RDBMS access in C# environments. It covers a wide range of systems from modern PostgreSQL (Npgsql) and MySQL to specialized engines like DuckDB for Parquet files and legacy DBISAM (Exportmaster) systems. By utilizing the ExecuteAndMap pattern and enforcing strict connection management, it ensures type-safe data retrieval, proper parameter handling across different SQL dialects, and reliable performance in enterprise environments involving Sage1000, X3, and RocsMiddleware systems.
主な機能
01Native PostgreSQL array handling and explicit type casting for function calls.
02Implementation of the ExecuteAndMap pattern for type-safe result mapping.
030 GitHub stars
04Comprehensive support for DuckDB, PostgreSQL, MySQL, SQL Server, and DBISAM.
05Standardized parameter styling for ODBC (?), MySQL (@), and PostgreSQL ($1) syntax.
06Optimized configurations for high-performance DuckDB Parquet file querying.
ユースケース
01Developing high-performance data pipelines that query Parquet files directly using DuckDB.
02Implementing reliable data access layers for enterprise ERP systems like Sage1000 and X3.
03Standardizing database connection and mapping logic across multi-engine C# applications.
