The DB Impex application is a tool to import and export database tables into a structured file.
The following modules are needed for this application:
Read database metadata (from SqlServer/Oracle/MySql/SQLite/PostgreSql/DB2 etc) into one simple model https://github.com/martinjw/dbschemareader
Simple csv library https://www.nuget.org/packages/Csv/
A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc.. https://www.nuget.org/packages/Dapper/
We use e.g. MySql.Data package but any other Database SQL package can be used.
In a console add the following dependencies:
# dotnet add package DatabaseSchemaReader --version 2.7.1
# dotnet add package Csv --version 1.0.39
# dotnet add package Dapper --version 1.60.1
# dotnet add package MySql.Data --version 8.0.15