JsonToSQL 1.0.0
dotnet add package JsonToSQL --version 1.0.0
NuGet\Install-Package JsonToSQL -Version 1.0.0
<PackageReference Include="JsonToSQL" Version="1.0.0" />
paket add JsonToSQL --version 1.0.0
#r "nuget: JsonToSQL, 1.0.0"
// Install JsonToSQL as a Cake Addin
#addin nuget:?package=JsonToSQL&version=1.0.0
// Install JsonToSQL as a Cake Tool
#tool nuget:?package=JsonToSQL&version=1.0.0
This is project to help creating SQL entities (tables) by json formated syntax and insert, update or delete rows in created or updated entities.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net45 is compatible. net451 was computed. net452 was computed. net46 was computed. net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
- Newtonsoft.Json (>= 6.0.8)
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 | 1,738 | 5/13/2015 |
1. In package manager console run command:
Install-Package JsonToSQL
or visit nuget.org
2. Setup your app.config add your connection string
<connectionStrings>
<add name="JsonToSQL.Properties.Settings.JsonToSQLConnectionString"
connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=JsonToSQL;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
3. Download example json and include into your project, set property of file "Copy to Output directory" to true
4. Add to your code:
string json=System.IO.File.ReadAllText("test.json");
JsonToSql.JsonToSqlProvider provider = new JsonToSql.JsonToSqlProvider(json);
string resultJson=provider.Commit();
5. Check your database and result in resultJson