Can I use this skill to query Parquet files?

Yes, it includes specific patterns for using the DuckDB ODBC driver to query Parquet files directly using the read_parquet() function with optimized timeout settings.

How does this skill handle different SQL parameter styles?

The skill provides specific guidance for each driver: '?' placeholders for ODBC, '@parameter' for MySQL, and '$1, $2' positional parameters for native PostgreSQL.

Does it support legacy ERP databases?

Yes, it includes proven access patterns for Sage1000, Sage X3, and Exportmaster (DBISAM) via ODBC connections.

Which database drivers does this skill support?

It supports native drivers like Npgsql for PostgreSQL and MySql.Data for MySQL, as well as System.Data.Odbc for DuckDB, SQL Server, and legacy systems like DBISAM.

What is the ExecuteAndMap pattern?

It is a specialized mapping pattern that uses a ServiceLib ODBC wrapper with lambda expressions to provide type-safe mapping of database rows to C# objects while handling null safety.

C# Database Access Patterns

Name: C# Database Access Patterns
Author: lawless-m

bylawless-m

•

Database Management

Streamlines RDBMS integration in C# for PostgreSQL, MySQL, DuckDB, and legacy systems using optimized access patterns and drivers.

About

This skill provides specialized guidance for C# developers working with a diverse range of database systems, from modern PostgreSQL and DuckDB instances to legacy SQL Server and DBISAM environments. It offers standardized patterns for library selection (Npgsql, MySql.Data, ODBC), type-safe mapping via the ExecuteAndMap pattern, and robust connection management. By following these production-proven implementation details, developers can ensure proper parameterization, efficient timeout handling, and optimized performance for complex operations like querying Parquet files or handling PostgreSQL arrays.

Key Features

5 GitHub stars
DuckDB ODBC patterns for direct Parquet file querying
Native driver optimization for PostgreSQL (Npgsql) and MySQL
Type-safe result mapping using the ExecuteAndMap lambda pattern
Standardized parameter handling to prevent SQL injection across different drivers
Legacy system support for Sage1000, X3, and Exportmaster (DBISAM)

Use Cases

Migrating legacy ODBC database connections to high-performance native drivers
Implementing type-safe data access layers in C# ServiceLib projects
Performing ad-hoc PostgreSQL queries using specialized CLI tool configurations

About

Key Features

5 GitHub stars
DuckDB ODBC patterns for direct Parquet file querying
Native driver optimization for PostgreSQL (Npgsql) and MySQL
Type-safe result mapping using the ExecuteAndMap lambda pattern
Standardized parameter handling to prevent SQL injection across different drivers
Legacy system support for Sage1000, X3, and Exportmaster (DBISAM)

Use Cases

Migrating legacy ODBC database connections to high-performance native drivers
Implementing type-safe data access layers in C# ServiceLib projects
Performing ad-hoc PostgreSQL queries using specialized CLI tool configurations