DataJuggler.Net9 9.0.1

.NET 9.0 This package targets .NET 9.0. The package is compatible with this framework or higher.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package DataJuggler.Net9 --version 9.0.1                

                    
                

            
NuGet\Install-Package DataJuggler.Net9 -Version 9.0.1
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.Net9" Version="9.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add DataJuggler.Net9 --version 9.0.1                

                    
                

            
#r "nuget: DataJuggler.Net9, 9.0.1"
#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.Net9 as a Cake Addin
#addin nuget:?package=DataJuggler.Net9&version=9.0.1

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

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 Compatible and additional computed target framework versions.
.NET net9.0 is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

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

Package Downloads
DataJuggler.Excelerate

Excelerate has been updated for .NET9. Use an 8.x version for .NET8, a 7.x version for .NET7. Excelerate will change how you work with C# and Excel. Excelerate uses NPOI 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. Excelerate also has helper classes to allow you load and save entire workbooks or worksheets without ever having referring to a cell. Use my free site https://excelerate.datajuggler.com to code generate C# classes from Excel header rows. ExcelDataLoader will load a workbook by passing in a path or a Worksheet by passing in a a WorksheetInfo object to specify what to load. Background I have a couple of clients that I built programs that automate Excel processes. This project streamlines Excel development.
DataJuggler.DocGen.DataAccessComponent

This project is part of DataJuggler.DocGen, which reads a Visual Studioi solution and saves all the code objects in SQL Server. The purpose of DocGen is to assist in documentation generation and management

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
9.0.3 312 11/23/2024
9.0.2 106 11/22/2024
9.0.1 94 11/19/2024
9.0.0 85 11/19/2024

11.19.2024: This project has been updated to .NET9

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