{"id":12508079,"name":"datajuggler.net.data","ecosystem":"nuget","description":"This class is for .NET10 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\ndriven data tiers. This class is a replacement for DataJuggler.NET5 - DataJuggler.NET9. All future work will be on this\nproject.\n\n-- Notes for .NET 8 carried over. Still Apply.\nBreaking Change: Now that this project uses Microsoft.Data.SqlClient 5.0+, connection strings must set Encrypt = False if your database is not encrypted. \n\nThe two main classes are:\nSQLDatabaseConnector - A wrapper for SqlDatabaseConnection that reads database schema.\n\nCSharpClassWriter - A class that is useful in code generating C# classes.","homepage":"https://github.com/DataJuggler/DataJuggler.Net6","licenses":"mit","normalized_licenses":["MIT"],"repository_url":"https://github.com/DataJuggler/DataJuggler.Net6","keywords_array":["C#","SQL","Server","DataTier.Net","DataJuggler.Net"],"namespace":null,"versions_count":14,"first_release_published_at":"2025-11-21T15:22:17.440Z","latest_release_published_at":"2026-10-12T03:46:01.520Z","latest_release_number":"10.2.4","last_synced_at":"2026-10-12T04:36:21.591Z","created_at":"2025-11-21T15:30:20.863Z","updated_at":"2026-10-12T04:36:21.591Z","registry_url":"https://www.nuget.org/packages/datajuggler.net.data/","install_command":"Install-Package datajuggler.net.data","documentation_url":null,"metadata":{"copyright":"Data Juggler - Corby Nichols","license_info":{"type":"file","text":"LICENSE.txt","version":null},"license_url":"https://aka.ms/deprecateLicenseUrl","require_license_acceptance":false,"readme":"README.md","repository":{"type":"Git Hub","url":"https://github.com/DataJuggler/DataJuggler.Net6.git","branch":null,"commit":"faaa69858c80a5aa4acb99811b95468434a606ea"},"development_dependency":false,"serviceable":false,"framework_assemblies":[],"package_types":[],"release_notes":"11.19.2024: This project has been updated to .NET9\n\n\t\t11.20.2023: DataJuggler.UltimateHelper was updated.\n\n\t\t11.14.2023: This project has been updated to .NET8.\n\n\t\t7.22.2023: CSharpClassWriter was updated for DataJuggler.Excelerate. All other functionality should be the same.\n\n\t\t7.16.2023: DataJuggler.Cryptography was updated to 7.1.0, as the constructor for Rfc2898DeriveBytes was\n\t\tdeemed obsolete. Also DataJuggler.UltimateHelper was updated to verison 7.1.3.\n\n\t\t4.11.2023: I added a new delegate ProgressStatusCallback that can be passed into the LoadDataTablesData method\n\t\tto receive callbacks during long operations. I also put a try catch around LoadDataRowsWithoutBinaryData method\n\t\tso that if one table or view has a problem the others are not affected.\n\n\t\t7.16.2023: DataJuggler.Cryptography was updated to 7.1.0, as the constructor for Rfc2898DeriveBytes was\n\t\tdeemed obsolete.\n\n\t\t4.1.2023: Everyone who likes this project on Git Hub will receive 3 good luck wishes.\n\t\tResults may vary.\n\n\t\t11.15.2022: I added TargetFrameworkEnum to this library. This enum is used by DataTier.Net\n\t\tand DataJuggler.Excelerate to determine the references to include.\n\n\t\t11.8.2022\n\t\tv7.0.1: This project has been updated for .NET 7.0. Use DataJuggler.Net6 for for .NET6.\n\n\t\t10.19.2022 (Take Two):\n\t\tv7.0.1-rc1: I added an optional parameter to the BuildConnectionString methods, so that the\n\t\tconnectionstrings will ad Encrypt=False unless the user passes in true for Encrypt.\n\n\t\t10.19.2022:\n\t\tv7.0.0-rc1 - The biggest breaking change so far is I updated Microsoft.Data.SqlClient to version 5.1.x (preview for now)\n\t\tthat I skipped on version 6 of this library. Last time there were too many breaking changes for me to handle a change\n\t\tto connection strings. I am attempting to fix that this year.\n\n\t\t8.5.2022 v6.2.0: I now compare and script DefaultValueCheckConstraints and Foreign Key check\n\t\tconstraints. After working on one of my databases I realized constraints that have No Check\n\t\tare not working. Still the Generate Scripts is saving me time as it improves.\n\n\t\t6.17.2022 v6.1.4: I updated DataJuggler.Cryptography package.\n\n\t\t6.8.2022: I updated DataJuggler.Cryptography package.\n\n\n\t\t4.18.2022: After only 18 years, I discovered that I the data type Date in SQL Server was not mapped.\n\t\tI always use DateTime, but I have a project with just Date data type and realized this isn't parsed.\n\t\tOne of the advantages of being unpopular is no one sees my mistakes.\n\n\t\t4.14.2022: I added two properties to DataTable and StoredProcedure classes, to keep track of\n\t\tUsesAnsiNulls and UseQuotedIdentifiers. I now set these objects when I load the DatabaseSchema.\n\t\tIt turns out, the text for the Defition of the View or Stored Procedure already had this, so not\n\t\treally needed. Generate Scripts now creates missing fields, tables, views and stored procedures.\n\t\tNext is constraints and keys and that is 99% of all updates I do.\n\n\t\t4.13.2022: I added a new method to SQL Database Connector to get the text for a view. This was needed for\n\t\tDB Compare had a bug when it tried to generate sql for a view. Tables are easy, views I had to get the actual text\n\t\tto make sure all the joins are correct.\n\n\t\t12.31.2021\n\t\tVersion 6.0.1: I upgraded the reference to Microsoft.Data.SqlClient to 4.0.0. Turns out this breaks everything without encrypt =false,\n\t\tso I took this out.\n\n\t\t3.0.6: I added a new property called CreatedFilePaths. This list of strings will contain the full path of all\n\t\tfiles created during WriteClasses method.\n\n\t\tAlso, 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.\n\n\t\tVersion 3.0.5: I updated the Read Me about a new project that uses CSharpClassWriter.\n\n\t\tVersion 3.0.4: Not sure why, but Nuget was giving me warning on 3.0.3 version. Trying again.\n\n\t\tVersion 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\n\t\tcan be used to create a class.\n\n\t\tVersion 3.0.1: I created a default constructor for CSharpClassWriter, so it is not only for DataTier.Net\n\n\t\tUpdate 9.15.2021\n\t\tVersion 3.0.2: I added DataType object for code generation outside of DataTier.Net.\n\n\t\tVersion 3.0.0: I changed out System.Data.SqlClient to Microsoft.Data.SqlClient, so I updated this package to\n\t\tversion 3.0.0 to be the same version as Microsoft.Data.SqlClient.\n\n\t\tVersion 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.\n\n\t\tVersion 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.\n\n\t\tI added new properties named Tag to DataField, DataRow and DataTable classes. I use these fields in a new\n\t\tproject I am working on called DataDiff, which will be used to find changes before and after something happens.\n\n\t\tI updated the reference to System.Data.SqlClient to 4.8.0\n\t\tI updated the reference to DataJuggler.UltimateHelper.Core to version 1.1.4","dependency_summary":{"total_dependency_groups":1,"target_frameworks":["net10.0"],"total_dependencies":4},"verified":false},"repo_metadata":{"id":62916391,"uuid":"429287145","full_name":"DataJuggler/DataJuggler.Net6","owner":"DataJuggler","description":"This is a port of DataJuggler.Net5, which is the main component of DataTier.Net and DBCompare. Useful for database schema reading and code generation.","archived":false,"fork":false,"pushed_at":"2022-08-05T11:18:17.000Z","size":282,"stargazers_count":0,"open_issues_count":0,"forks_count":0,"subscribers_count":1,"default_branch":"master","last_synced_at":"2026-10-01T23:35:55.930Z","etag":null,"topics":[],"latest_commit_sha":null,"homepage":null,"language":"C#","has_issues":true,"has_wiki":null,"has_pages":null,"mirror_url":null,"source_name":null,"license":"mit","status":null,"scm":"git","pull_requests_enabled":true,"icon_url":"https://github.com/DataJuggler.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE.txt","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null}},"created_at":"2021-11-18T03:45:58.000Z","updated_at":"2022-10-21T22:55:45.000Z","dependencies_parsed_at":"2022-11-09T04:01:33.197Z","dependency_job_id":null,"html_url":"https://github.com/DataJuggler/DataJuggler.Net6","commit_stats":null,"previous_names":[],"tags_count":0,"template":false,"template_full_name":null,"purl":"pkg:github/DataJuggler/DataJuggler.Net6","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/DataJuggler%2FDataJuggler.Net6","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/DataJuggler%2FDataJuggler.Net6/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/DataJuggler%2FDataJuggler.Net6/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/DataJuggler%2FDataJuggler.Net6/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/DataJuggler","download_url":"https://codeload.github.com/DataJuggler/DataJuggler.Net6/tar.gz/refs/heads/master","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/DataJuggler%2FDataJuggler.Net6/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":343170754,"owners_count":38126595,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-10-03T21:59:58.778Z","status":"online","status_checked_at":"2026-10-08T02:00:05.744Z","response_time":97,"last_error":null,"robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":true,"can_crawl_api":true,"host_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories","repository_names_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repository_names","owners_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners"},"owner_record":{"login":"DataJuggler","name":"Data Juggler","uuid":"26331133","kind":"user","description":"I have 20+ years experience designing and building databases, controls, applications, Windows and Web Services and more.\r\n\r\nMy primary skills are C# and SQL.","email":"","website":"https://datajuggler.com","location":"Houston, Texas","twitter":null,"company":"Data Juggler","icon_url":"https://avatars.githubusercontent.com/u/26331133?u=49f3efa87a12659c1bfa8b5c3853e929992f1c65\u0026v=4","repositories_count":19,"last_synced_at":"2023-03-15T21:11:40.144Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/DataJuggler","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2023-03-15T21:11:36.006Z","updated_at":"2023-03-15T21:11:40.145Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/DataJuggler","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/DataJuggler/repositories"},"tags":[]},"repo_metadata_updated_at":"2026-10-12T04:36:20.936Z","dependent_packages_count":0,"downloads":2516,"downloads_period":"total","dependent_repos_count":0,"rankings":{"downloads":57.02748545284712,"dependent_repos_count":6.501432884636249,"dependent_packages_count":17.438606657908,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":26.989174998463792},"purl":"pkg:nuget/datajuggler.net.data","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/nuget/datajuggler.net.data","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/nuget/datajuggler.net.data","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/nuget/datajuggler.net.data/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2026-10-10T21:51:50.591Z","issues_count":0,"pull_requests_count":0,"avg_time_to_close_issue":null,"avg_time_to_close_pull_request":null,"issues_closed_count":0,"pull_requests_closed_count":0,"pull_request_authors_count":0,"issue_authors_count":0,"avg_comments_per_issue":null,"avg_comments_per_pull_request":null,"merged_pull_requests_count":0,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":0,"past_year_pull_requests_count":0,"past_year_avg_time_to_close_issue":null,"past_year_avg_time_to_close_pull_request":null,"past_year_issues_closed_count":0,"past_year_pull_requests_closed_count":0,"past_year_pull_request_authors_count":0,"past_year_issue_authors_count":0,"past_year_avg_comments_per_issue":null,"past_year_avg_comments_per_pull_request":null,"past_year_bot_issues_count":0,"past_year_bot_pull_requests_count":0,"past_year_merged_pull_requests_count":0,"issues_url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/repositories/DataJuggler%2FDataJuggler.Net6/issues","maintainers":[],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/datajuggler.net.data/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/datajuggler.net.data/version_numbers","latest_version_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/datajuggler.net.data/latest_version","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/datajuggler.net.data/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/datajuggler.net.data/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/datajuggler.net.data/codemeta","maintainers":[{"uuid":"DataJuggler","login":"DataJuggler","name":null,"email":null,"url":null,"packages_count":62,"html_url":"https://www.nuget.org/profiles/DataJuggler","role":null,"created_at":"2025-11-21T15:41:35.947Z","updated_at":"2025-11-21T15:41:35.947Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/maintainers/DataJuggler/packages"}]}