About

Blog

Documentation

• How SQLizer Works

  • CSVs and Text files
  • Spreadsheets
  • JSON and XML
  • Number Handling
  • Date Handling
  • Text Handling

• User Guides

  • Switching Plan
  • Removing a File
  • Managing API Keys
  • Deleting Your Account

• The SQLizer API

  • Getting Started
  • Multipart Upload
  • HTTP Reference
    • POST /api/files
    • GET /api/files/{ID}
    • POST /api/files/{ID}/data
    • PUT /api/files/{ID}
    • DELETE /api/files/{ID}
  • .NET SDK
  • Python SDK

SQLizer's .NET SDK

Our .NET SDK is an open source .NET Standard 2.1 library that provides programatic access to the SQLizer API to .NET clients

Our .NET SDK can be added to your .NET projects via the Nuget command:

dotnet add package sqlizer-client-dotnet

Your .NET application can then initiate a file conversion like this:

SQLizerClient.Settings.ApiKey = "{API-KEY}";

var file = new SQLizerClient.SQLizerFile("source.xlsx");

file.DatabaseType = SQLizerClient.DatabaseType.MySQL;
file.TableName = "my_table";
file.HasHeaders = true;

// Optional
file.SheetName = "Sheet1";
file.CellRange = "A1:C99";
file.CheckTableExists = true;
file.InsertSpacing = 250;

await file.SaveResultAsync("destination.sql");

The properties on the SQLizerFile object match those on the https://sqlizer.io/api/files/ entity on our REST API. See the API Reference for more information.

The code for this SDK can be found on GitHub at: https://github.com/sqlizer-io/sqlizer-client-dotnet