RepoDb_ExecuteQuery_BulkInsert_Combination

RepoDb_ExecuteQuery_BulkInsert_Combination.cs

// Source from PostgreSQL
using (var sourceConnection = new NpgqlConnection(connectionStringToPostgreSQL))
{
    var sales = sourceConnection.QueryAll<Sale>(e => e.OrderDate >= 'FromDate' && e.OrderDate <= 'ToDate');
    
    // Destination to SQL Server
    using (var destinationConnection = new SqlConnection(connectionStringToSqlServer))
    {
        destinationConnection.BulkInsert<Sale>(sales);
    }   
}