DataJuggler.Net9
9.0.0
See the version list below for details.
dotnet add package DataJuggler.Net9 --version 9.0.0
NuGet\Install-Package DataJuggler.Net9 -Version 9.0.0
<PackageReference Include="DataJuggler.Net9" Version="9.0.0" />
paket add DataJuggler.Net9 --version 9.0.0
#r "nuget: DataJuggler.Net9, 9.0.0"
// Install DataJuggler.Net9 as a Cake Addin #addin nuget:?package=DataJuggler.Net9&version=9.0.0 // Install DataJuggler.Net9 as a Cake Tool #tool nuget:?package=DataJuggler.Net9&version=9.0.0
News
9.13.2024: NuGet packages DataJuggler.UltimateHelper and Microsoft.Data.SqlClient were updated.
5.19.2024: A new video was created for DataTier .Net, which is powered by this project
First Ever Opensource Saturday - Sunday Edition https://youtu.be/uxa1xR6xpzk
12.26.2023: TargetFrameworkEnum was updated to include .NET8
11.20.2023: DataJuggler.UltimateHelper was updated.
11.14.2023: DataJuggler.NET8 is has been released!
8.9.2023: .NET 8 has been released. All the code is the same as the .NET 7 version, except some of the features for DataTier.Net have been removed as the DataWatcher.cs class is no longer created.
DataJuggler.Net 8 will power the following projects by November. Currently these projects are on .NET 7.
DB Compare https://github.com/DataJuggler/DBCompare
DB Compare reads the database schema and compares two SQL Server databases and displays a report of any schema differences. The generate scripts feature is a work in progress.
Another project that uses this and is open source is:
DataJuggler.Excelerate https://github.com/DataJuggler/Excelerate
Nuget DataJuggler.Excelerate
Live Demo https://excelerate.datajuggler.com
Code Generate C# Classes From Excel Header Rows
Blazor Source Code For Above Site
Blazor Excelerate
https://github.com/DataJuggler/Blazor.Excelerate
And my latest project is SQL Snapshot
Nuget DataJuggler.SQLSnapshot https://github.com/DataJuggler/SQLSnapshot
Export an entire SQL Server database to Excel including all rows with 3 lines of code.
-
Another site that is powered by an earlier version of DataJuggler.NET8 is, and is my favorite project.
DataTier.Net https://github.com/DataJuggler/DataTier.Net
DataTier.Net is an Entity Framework alternative that uses all stored procedures.
If you feel any of the projects are worth the price of free, please leave a star on Git Hub and / or subscribe to my YouTube channel.
https://youtube.com/DataJuggler
Thanks,
Corby / Data Juggler
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net9.0 is compatible. |
-
net9.0
- DataJuggler.Cryptography (>= 9.0.0)
- DataJuggler.UltimateHelper (>= 9.0.0)
- Microsoft.Data.SqlClient (>= 5.2.2)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
11.20.2023: DataJuggler.UltimateHelper was updated.
11.14.2023: This project has been updated to .NET8.
7.22.2023: CSharpClassWriter was updated for DataJuggler.Excelerate. All other functionality should be the same.
7.16.2023: DataJuggler.Cryptography was updated to 7.1.0, as the constructor for Rfc2898DeriveBytes was
deemed obsolete. Also DataJuggler.UltimateHelper was updated to verison 7.1.3.
4.11.2023: I added a new delegate ProgressStatusCallback that can be passed into the LoadDataTablesData method
to receive callbacks during long operations. I also put a try catch around LoadDataRowsWithoutBinaryData method
so that if one table or view has a problem the others are not affected.
7.16.2023: DataJuggler.Cryptography was updated to 7.1.0, as the constructor for Rfc2898DeriveBytes was
deemed obsolete.
4.1.2023: Everyone who likes this project on Git Hub will receive 3 good luck wishes.
Results may vary.
11.15.2022: I added TargetFrameworkEnum to this library. This enum is used by DataTier.Net
and DataJuggler.Excelerate to determine the references to include.
11.8.2022
v7.0.1: This project has been updated for .NET 7.0. Use DataJuggler.Net6 for for .NET6.
10.19.2022 (Take Two):
v7.0.1-rc1: I added an optional parameter to the BuildConnectionString methods, so that the
connectionstrings will ad Encrypt=False unless the user passes in true for Encrypt.
10.19.2022:
v7.0.0-rc1 - The biggest breaking change so far is I updated Microsoft.Data.SqlClient to version 5.1.x (preview for now)
that I skipped on version 6 of this library. Last time there were too many breaking changes for me to handle a change
to connection strings. I am attempting to fix that this year.
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