DataJuggler.Net5 3.0.6

Install-Package DataJuggler.Net5 -Version 3.0.6
dotnet add package DataJuggler.Net5 --version 3.0.6
<PackageReference Include="DataJuggler.Net5" Version="3.0.6" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DataJuggler.Net5 --version 3.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: DataJuggler.Net5, 3.0.6"
#r directive can be used in F# Interactive, C# scripting and .NET Interactive. Copy this into the interactive tool or source code of the script to reference the package.
// Install DataJuggler.Net5 as a Cake Addin
#addin nuget:?package=DataJuggler.Net5&version=3.0.6

// Install DataJuggler.Net5 as a Cake Tool
#tool nuget:?package=DataJuggler.Net5&version=3.0.6
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

This class is a port of DataJuggler.Net for the .Net Framework, which is used by
DataTier.Net and DB Compare to read SQL Server database schema and code generate stored procedure
driven data tiers.

The two main classes are:
SQLDatabaseConnector - A wrapper for SqlDatabaseConnection that reads database schema.

CSharpClassWriter - A class that is useful in code generating C# classes.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on DataJuggler.Net5:

Package Downloads

Excelerate uses EPPPlus version (last free version), and it makes it easy to load Workbooks or Worksheets. Excelerate now has a code generation feature, you can create a C# class from a header row. I have a couple of clients that I build programs that automate combining columns from multiple Worksheets to form reports. Rather than continue to write custom loaders, I really only need custom Exporters in most cases, so I created this project.


DB Compare compares two instances of a SQL Server database. This project has been on .Net Framework for about 10 or 12 years or more. Today I got motivated and converted it to .Net 5, and a bunch of other Nuget packages. I converted this project to a Nuget package, because I know expecting developers to go all the way to and then further wanting them to Clone or Download a file is too much to ask. Now you can create a project in a manner of minutes and this way you can stay updated with the latest version. This product is also a standalone application. Using it as a Nuget package is just a nice way to always have the latest version.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.0.6 1,382 9/17/2021
3.0.5 89 9/16/2021
3.0.4 66 9/16/2021
3.0.3 93 9/16/2021
3.0.2 90 9/15/2021
3.0.1 88 9/15/2021
3.0.0 105 8/11/2021
2.5.1 131 2/7/2021
2.5.0 157 12/4/2020

3.0.6: I added a new property called CreatedFilePaths. This list of strings will contain the full path of all
files created during WriteClasses method.

Also, I found out why I had problems with Nuget version 3.0.2 - 3.0.5. I had a project reference and a Nuget reference, and Nuget and / or Visual Studio didn't like it.

Version 3.0.5: I updated the Read Me about a new project that uses CSharpClassWriter.

Version 3.0.4: Not sure why, but Nuget was giving me warning on 3.0.3 version. Trying again.

Version 3.0.3: I made a few changes to CSharpClassWriter to make it easier to code generate from outside DataTier.Net. My project DataJuggler.Excelerate now has a code generator, so the header row in an Excel sheet
can be used to create a class.

Version 3.0.1: I created a default constructor for CSharpClassWriter, so it is not only for DataTier.Net

Update 9.15.2021
Version 3.0.2: I added DataType object for code generation outside of DataTier.Net.

Version 3.0.0: I changed out System.Data.SqlClient to Microsoft.Data.SqlClient, so I updated this package to
version 3.0.0 to be the same version as Microsoft.Data.SqlClient.

Version 2.5.1: I added 2 new methods to SQLDatabaseConnector for FindTable and FindTableIndex. It surprises me this doesn't exist somewhere in the app.

Version 2.5.0: This version converted the .Net Core version to .Net 5. All the different names confuse even me, so I am trying to get down to everything I keep working on is .Net 5.

     I added new properties named Tag to DataField, DataRow and DataTable classes. I use these fields in a new
     project I am working on called DataDiff, which will be used to find changes before and after something happens.

     I updated the reference to System.Data.SqlClient to 4.8.0
     I updated the reference to DataJuggler.UltimateHelper.Core to version 1.1.4