CsvToDbDynamicTableConverter 1.0.0

.NET 8.0

dotnet add package CsvToDbDynamicTableConverter --version 1.0.0

NuGet\Install-Package CsvToDbDynamicTableConverter -Version 1.0.0

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="CsvToDbDynamicTableConverter" Version="1.0.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="CsvToDbDynamicTableConverter" Version="1.0.0" />
                    

                            Directory.Packages.props

<PackageReference Include="CsvToDbDynamicTableConverter" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add CsvToDbDynamicTableConverter --version 1.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: CsvToDbDynamicTableConverter, 1.0.0"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package CsvToDbDynamicTableConverter@1.0.0

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=CsvToDbDynamicTableConverter&version=1.0.0
                    

                            Install as a Cake Addin

#tool nuget:?package=CsvToDbDynamicTableConverter&version=1.0.0
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

📂 CSV to SQL Dynamic Table Importer

This package provides an ASP.NET Core Web API that allows you to upload a CSV file, dynamically create a SQL Server table based on the CSV header, and insert all CSV rows into the newly created table.

✨ Features

✅ Automatically reads CSV headers
✅ Dynamically creates a SQL Server table
✅ Inserts CSV rows into the created table
✅ Supports ASP.NET Core API integration
✅ Powered by CsvHelper, Microsoft.Data.SqlClient

🚀 Installation

Install the NuGet package:

dotnet add package CsvToDbDynamicTableConverter --version 1.0.0

Usage Example

using CsvToSqlDynamicTableConverter;

CsvToSqlDynamicTableHelper.ImportCsvToSqlAndCreateTable(
    @"C:\files\employees.csv",
    "Server=localhost;Database=MyDB;Trusted_Connection=True;TrustServerCertificate=True;",
    "Employees"
);

Sample CSV

Id,FirstName,LastName,Email,Department
1,John,Doe,john.doe@example.com,HR
2,Jane,Smith,jane.smith@example.com,IT
3,Bob,Johnson,bob.johnson@example.com,Finance

Usage Example (ASP.NET Core API)

public IActionResult ImportCsvDynamicTableCreation(IFormFile file, string TableName)
{
    if (file == null || file.Length == 0)
        return BadRequest("Please upload a valid CSV file.");

    string tempPath = Path.GetTempFileName();

    using (var stream = new FileStream(tempPath, FileMode.Create))
    {
        file.CopyTo(stream);
    }

    string connString = _config.GetConnectionString("DefaultConnection");

    // Table will be created dynamically from CSV header
    CsvToSqlDynamicTableHelper.ImportCsvToSqlAndCreateTable(
        tempPath,
        connString,
        TableName
    );

    return Ok("CSV uploaded and table created successfully!");
}

Notes

All columns are created as NVARCHAR(MAX).
Works with SQL Server only.

License

MIT License

Product	Compatible and additional computed target framework versions.
.NET	net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net8.0
- CsvHelper (>= 33.1.0)
- System.Data.SqlClient (>= 4.9.0)

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last Updated
1.0.0	212	8/21/2025