Common.Library.Cloud.DataSeed
2.12.0
dotnet add package Common.Library.Cloud.DataSeed --version 2.12.0
NuGet\Install-Package Common.Library.Cloud.DataSeed -Version 2.12.0
<PackageReference Include="Common.Library.Cloud.DataSeed" Version="2.12.0" />
<PackageVersion Include="Common.Library.Cloud.DataSeed" Version="2.12.0" />
<PackageReference Include="Common.Library.Cloud.DataSeed" />
paket add Common.Library.Cloud.DataSeed --version 2.12.0
#r "nuget: Common.Library.Cloud.DataSeed, 2.12.0"
#:package Common.Library.Cloud.DataSeed@2.12.0
#addin nuget:?package=Common.Library.Cloud.DataSeed&version=2.12.0
#tool nuget:?package=Common.Library.Cloud.DataSeed&version=2.12.0
To insert and update bulk CSV data into Postgre SQL database tables.
string currentDirectory = Directory.GetCurrentDirectory(); string csvFolderPath = Path.Combine(currentDirectory, "DataSeed"); string metaDataFilePath = Path.Combine(csvFolderPath, "CsvOrderExe.json");
Call this Class and this method and Pass sql ConnectionString , csvFolderPath and json file Path for the metaDataFilePath CsvToSqlSeeder.CsvPublisher(connectionString, csvFolderPath, metaDataFilePath);
{ "csvFiles": [ { "fileName": "dbo.FileName.csv", //schemaName.TableName.csv "order": 1 //executing Order } ] }
Note:
If you need to use number as a string seed like this '33', '-43' → result 33 , -43
If you need to json as string seed like this "[{zoneName:'Asia/Kabul',gmtOffset:16200,gmtOffsetName:'UTC+04:30',abbreviation:'AFT',tzName:'Afghanistan Time'}]" → result [{zoneName:'Asia/Kabul',gmtOffset:16200,gmtOffsetName:'UTC+04:30',abbreviation:'AFT',tzName:'Afghanistan Time'}]
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. 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. |
-
net6.0
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 6.0.22)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.