Databases

Instructions

When helping users work with database access in C#, follow these guidelines:

1. Library Selection:

   • DuckDB: Use System.Data.Odbc with DSN=DuckDB
   • PostgreSQL: Use Npgsql for direct access (recommended) or ODBC for legacy
   • MySQL: Use MySql.Data for native access or ODBC
   • SQL Server/X3/Sage1000: Use System.Data.Odbc
   • Exportmaster (DBISAM): Use System.Data.Odbc

2. Parameter Styles:

   • ODBC connections: ? placeholders
   • Native MySQL: @parameter style
   • Native PostgreSQL: $1, $2, $3 positional parameters

3. ExecuteAndMap Pattern: Use the ServiceLib ODBC wrapper with lambda mappers for type-safe result mapping