DataJuggler.Net7 7.0.9

.NET 7.0 This package targets .NET 7.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.Net7 --version 7.0.9                

                    
                

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

                    
                

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

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

4.11.2023: I added a new delegate ProgressStatusCallback that can be passed into the LoadDataTablesData method to receive callbacks during long operations.

4.1.2023: DataJuggler.Net7 is a port of earlier versions of this project. All new development is performed on this version until .NET8 is released later this year. DataJuggler.Net7 is used to read SQL Server database schema using SQLDatabaseConnector.cs, and also has code generation features using CSharpClassWriter.cs.

DataJuggler.Net 7 powers the following projects

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.Net7 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 net7.0 is compatible.  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
7.3.1 1,963 8/26/2023
7.3.0 203 8/14/2023
7.2.8 1,712 7/22/2023
7.2.7 172 7/22/2023
7.1.0 414 7/16/2023
7.0.10 2,037 4/10/2023
7.0.9 393 4/10/2023
7.0.8 200 4/10/2023
7.0.7 198 4/10/2023
7.0.6 767 4/1/2023
7.0.4 1,308 3/28/2023
7.0.3 232 3/6/2023
7.0.2 21,377 11/15/2022
7.0.1 2,512 11/9/2022
7.0.1-rc1 808 10/19/2022
7.0.0-rc1 154 10/19/2022

4.11.2023: I added a new delegate ProgressStatusCallback that can be passed into the LoadDataTablesData method
to receive callbacks during long operations.

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