DataJuggler.Net6 6.2.0

.NET 6.0 
dotnet add package DataJuggler.Net6 --version 6.2.0
NuGet\Install-Package DataJuggler.Net6 -Version 6.2.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="DataJuggler.Net6" Version="6.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DataJuggler.Net6 --version 6.2.0
#r "nuget: DataJuggler.Net6, 6.2.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. 
// Install DataJuggler.Net6 as a Cake Addin
#addin nuget:?package=DataJuggler.Net6&version=6.2.0

// Install DataJuggler.Net6 as a Cake Tool
#tool nuget:?package=DataJuggler.Net6&version=6.2.0

This class is for .NET6 and 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.

Product 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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

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
6.2.0 441 8/5/2022
6.1.4 392 6/17/2022
6.1.3 395 6/17/2022
6.1.2 385 6/8/2022
6.1.1 448 4/18/2022
6.1.0 401 4/14/2022
6.0.5 427 4/13/2022
6.0.4 1,747 1/23/2022
6.0.3 255 1/5/2022
6.0.2 267 12/31/2021
6.0.1 248 12/31/2021
6.0.0 313 11/18/2021

8.5.2022 v6.2.0: I now compare and script DefaultValueCheckConstraints and Foreign Key check
constraints. After working on one of my databases I realized constraints that have No Check
are not working. Still the Generate Scripts is saving me time as it improves.

6.17.2022 v6.1.4: I updated DataJuggler.Cryptography package.

6.8.2022: I updated DataJuggler.Cryptography package.


4.18.2022: After only 18 years, I discovered that I the data type Date in SQL Server was not mapped.
I always use DateTime, but I have a project with just Date data type and realized this isn't parsed.
One of the advantages of being unpopular is no one sees my mistakes.

4.14.2022: I added two properties to DataTable and StoredProcedure classes, to keep track of
UsesAnsiNulls and UseQuotedIdentifiers. I now set these objects when I load the DatabaseSchema.
It turns out, the text for the Defition of the View or Stored Procedure already had this, so not
really needed. Generate Scripts now creates missing fields, tables, views and stored procedures.
Next is constraints and keys and that is 99% of all updates I do.

4.13.2022: I added a new method to SQL Database Connector to get the text for a view. This was needed for
DB Compare had a bug when it tried to generate sql for a view. Tables are easy, views I had to get the actual text
to make sure all the joins are correct.

12.31.2021
Version 6.0.1: I upgraded the reference to Microsoft.Data.SqlClient to 4.0.0. Turns out this breaks everything without encrypt =false,
so I took this out.

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