{"id":8915907,"name":"sqltransactionaloutbox.sqlserver.systemdatans","ecosystem":"nuget","description":"The SQL Server outbox implementation of SqlTransactionalOutbox framework using legacy System.Data.SqlClient libraries.\n      A lightweight library \u0026 framework for implementing the Transactional Outbox pattern in .Net with default implementaions for SQL Server \u0026 messaging via Azure Service Bus. Some of the key benefits offered are support for running in serverless environments (e.g. AzureFunctions) or in standard hosted .Net applications (via asynchronous background 'worker threads'), and support for enforcing true FIFO processing to preserve ordering, scheduled events for future delivery, and simplified abstractions for the Outbox, Outbox Processing, and Messaging systems utilized.","homepage":"https://github.com/cajuncoding/SqlTransactionalOutbox","licenses":"MIT","normalized_licenses":["MIT"],"repository_url":"https://github.com/cajuncoding/SqlTransactionalOutbox","keywords_array":["sql","server","sqlserver","sql-server","transactional","outbox","transactional-outbox","outbox-pattern","microservice","eventservices","event-services","event-notifications","azure","service","bus","azurefunctions","azure-functions"],"namespace":null,"versions_count":9,"first_release_published_at":"2021-02-11T06:27:02.833Z","latest_release_published_at":"2026-03-04T07:09:27.890Z","latest_release_number":"1.1.0","last_synced_at":"2026-04-04T09:37:23.053Z","created_at":"2024-02-26T01:21:56.951Z","updated_at":"2026-04-04T10:23:31.775Z","registry_url":"https://www.nuget.org/packages/sqltransactionaloutbox.sqlserver.systemdatans/","install_command":"Install-Package sqltransactionaloutbox.sqlserver.systemdatans","documentation_url":null,"metadata":{"copyright":"Copyright © 2021","license_info":{"type":"expression","text":"MIT","version":null},"license_url":"https://licenses.nuget.org/MIT","require_license_acceptance":false,"repository":{"type":"git","url":"https://github.com/cajuncoding/SqlTransactionalOutbox","branch":null,"commit":"3b3202730b86f2e3bed30e9c49d550db9f73007b"},"development_dependency":false,"serviceable":false,"framework_assemblies":[],"package_types":[],"release_notes":"Release Notes:\n      - New support for scheduled publishing of Events from the Outbox for publishing/delivery at any time in the future.\n      - Significant updates to the Sample Apps have been added and fully illustrate the new Scheduled delivery feature.\n      - Azure Functions Sample App has been fully migrated to the `isolated process` model; as the legacy `in-process` model is deprecated.\n      - Implemented new SQL reader performance improvements and safety for handling NULL values.\n      - Fixed AsyncThreadOutboxProcessingAgent to correctly implement distributed locking by default as a best practice; with parameters to support disabling and customizing the lock name.\n      - Add full support for CancellationToken throughout the API as it was missing!\n      - Various code cleanup, Json parsing fixes (to now support DateTime), and stability improvements.\n      - Most are non-breaking changes and optional additions.\n\n      Prior Release Notes:\n      - Update Microsoft.Data.SqlClient package to new version to resolve vulnerability risks in older version.\n      - Update System.Data.SqlClient package to new version to resolve vulnerability risks in older version.\n      - Fix bug in DefaultSqlServerOutboxRepository to use new customizable global configuration as Default.\n      - Improved support for customizing OutboxTable Configuration and Distributed Mutex Lock settings via SqlTransactionalOutboxInitializer.Configure() initialization.\n      - Also fixed several bugs/issues with Database loading of Null values.\n      - Improved Error Handling when Processing of Outbox has unexpected Exceptions.\n      - Bump version of SqlTransactionalOutbox.Common.\n      - Fix bug with Null values not being set correctly when Adding/Updating Outbox Items.\n      - Initial BETA release for default implementations of SQL Server transactional outbox.","dependency_summary":{"total_dependency_groups":1,"target_frameworks":[".NETStandard2.1"],"total_dependencies":4}},"repo_metadata":{"id":44914471,"uuid":"328014874","full_name":"cajuncoding/SqlTransactionalOutbox","owner":"cajuncoding","description":"A lightweight library for implementing the Transactional Outbox pattern in .NET with default implementation in SQL Server \u0026 Azure Service Bus. Key benefits offered are support for running in Azure Functions serverless environments and support for enforcing FIFO ordering of processing \u0026 publishing even in horizontally scaled environments (e.g. serverless or load balanced).","archived":false,"fork":false,"pushed_at":"2026-03-04T07:26:51.000Z","size":656,"stargazers_count":21,"open_issues_count":1,"forks_count":2,"subscribers_count":1,"default_branch":"main","last_synced_at":"2026-03-04T13:03:06.611Z","etag":null,"topics":["azure","azure-functions","azure-service-bus","azuresql","event-based-notification","event-notifications","event-services","fifo-processing","outbox","outbox-database","outbox-pattern","preserve-ordering","serverless-environments","sql","sql-server","sqlserver","transactional-outbox","transactional-outbox-pattern"],"latest_commit_sha":null,"homepage":"http://cajuncoding.com","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/cajuncoding.png","metadata":{"files":{"readme":"README.md","changelog":null,"contributing":null,"funding":null,"license":"LICENSE","code_of_conduct":null,"threat_model":null,"audit":null,"citation":null,"codeowners":null,"security":null,"support":null,"governance":null,"roadmap":null,"authors":null,"dei":null,"publiccode":null,"codemeta":null,"zenodo":null,"notice":null,"maintainers":null,"copyright":null,"agents":null,"dco":null,"cla":null}},"created_at":"2021-01-08T21:20:02.000Z","updated_at":"2026-03-04T07:26:56.000Z","dependencies_parsed_at":"2024-02-29T23:25:21.546Z","dependency_job_id":"4c159198-d8df-4ae7-8bd4-a3d6f9b42b17","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox","commit_stats":null,"previous_names":[],"tags_count":10,"template":false,"template_full_name":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox","repository_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox","tags_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags","releases_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/releases","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/manifests","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/cajuncoding","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/refs/heads/main","sbom_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/sbom","scorecard":null,"host":{"name":"GitHub","url":"https://github.com","kind":"github","repositories_count":286080680,"owners_count":30088349,"icon_url":"https://github.com/github.png","version":null,"created_at":"2022-05-30T11:31:42.601Z","updated_at":"2026-03-04T15:40:14.053Z","status":"ssl_error","status_checked_at":"2026-03-04T15:40:13.655Z","response_time":59,"last_error":"SSL_read: unexpected eof while reading","robots_txt_status":"success","robots_txt_updated_at":"2025-07-24T06:49:26.215Z","robots_txt_url":"https://github.com/robots.txt","online":false,"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":"cajuncoding","name":"Brandon","uuid":"20844814","kind":"user","description":"Always tryin' to cook up something good!\r\n    \r\n\r\n","email":"","website":"http://www.cajuncoding.com","location":"United States","twitter":"TheCajunCoder","company":"CajunCoding (for Fun) \u0026 EXLRT (for Work)","icon_url":"https://avatars.githubusercontent.com/u/20844814?u=fee6578d5fa07f8e991736e963849dcb688e8886\u0026v=4","repositories_count":11,"last_synced_at":"2023-03-06T10:20:34.091Z","metadata":{"has_sponsors_listing":false},"html_url":"https://github.com/cajuncoding","funding_links":[],"total_stars":null,"followers":null,"following":null,"created_at":"2022-11-16T09:35:18.856Z","updated_at":"2023-03-06T10:20:34.104Z","owner_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/cajuncoding","repositories_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/owners/cajuncoding/repositories"},"tags":[{"name":"v1.1.0","sha":"3b3202730b86f2e3bed30e9c49d550db9f73007b","kind":"commit","published_at":"2026-03-04T07:08:44.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.1.0","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.1.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.1.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.1.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.1.0/manifests"},{"name":"v1.0.5","sha":"2341bd7cb3d28853c4baee41825c48a17a486a07","kind":"commit","published_at":"2025-07-23T20:02:35.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.0.5","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.0.5","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.0.5","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.5","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.5/manifests"},{"name":"v1.0.4","sha":"cf7ee40214e54334778b1ba755e8fb55d947adc3","kind":"commit","published_at":"2025-07-22T17:48:04.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.0.4","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.0.4","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.0.4","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.4","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.4/manifests"},{"name":"v1.0.3","sha":"98e572039f4afedcf5b3073ec83cab4492015f37","kind":"commit","published_at":"2024-02-23T05:16:26.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.0.3","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.3/manifests"},{"name":"v1.0.2","sha":"1b75c19a2b15360cb762d93ae59eb4e891575de3","kind":"commit","published_at":"2022-08-22T18:50:06.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.0.2","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.2/manifests"},{"name":"v1.0.1","sha":"dde57580211351ac3c041e32106cf1307ec0d4f2","kind":"commit","published_at":"2022-08-19T20:14:42.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.0.1","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.1/manifests"},{"name":"v1.0.0","sha":"d847f6dbc5406a82dd86c5e0f4a6e6d0ab0e47a1","kind":"commit","published_at":"2022-01-18T22:59:32.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v1.0.0","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v1.0.0","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v1.0.0","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.0","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v1.0.0/manifests"},{"name":"v0.0.3","sha":"df941546abda7fa82162f0c2f9452458e3703a9d","kind":"commit","published_at":"2021-02-16T05:33:06.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v0.0.3","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v0.0.3","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v0.0.3","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v0.0.3","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v0.0.3/manifests"},{"name":"v0.0.2","sha":"7367625f43660422490daa902cf41c32161c7d12","kind":"commit","published_at":"2021-02-13T02:45:19.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v0.0.2","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v0.0.2","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v0.0.2","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v0.0.2","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v0.0.2/manifests"},{"name":"v0.0.1","sha":"a3b4fc3b169ecc3c81bea60ac41c5d50632412de","kind":"commit","published_at":"2021-02-11T06:25:46.000Z","download_url":"https://codeload.github.com/cajuncoding/SqlTransactionalOutbox/tar.gz/v0.0.1","html_url":"https://github.com/cajuncoding/SqlTransactionalOutbox/releases/tag/v0.0.1","dependencies_parsed_at":null,"dependency_job_id":null,"purl":"pkg:github/cajuncoding/SqlTransactionalOutbox@v0.0.1","tag_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v0.0.1","manifests_url":"https://repos.ecosyste.ms/api/v1/hosts/GitHub/repositories/cajuncoding%2FSqlTransactionalOutbox/tags/v0.0.1/manifests"}]},"repo_metadata_updated_at":"2026-04-04T10:23:31.754Z","dependent_packages_count":0,"downloads":4384,"downloads_period":"total","dependent_repos_count":0,"rankings":{"downloads":32.96024461030769,"dependent_repos_count":14.97801439290325,"dependent_packages_count":20.3376452392213,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":22.758634747477412},"purl":"pkg:nuget/sqltransactionaloutbox.sqlserver.systemdatans","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/nuget/sqltransactionaloutbox.sqlserver.systemdatans","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/nuget/sqltransactionaloutbox.sqlserver.systemdatans","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/nuget/sqltransactionaloutbox.sqlserver.systemdatans/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":{"last_synced_at":"2025-08-25T19:08:46.336Z","issues_count":4,"pull_requests_count":4,"avg_time_to_close_issue":427041.5,"avg_time_to_close_pull_request":47.75,"issues_closed_count":2,"pull_requests_closed_count":4,"pull_request_authors_count":1,"issue_authors_count":1,"avg_comments_per_issue":5.0,"avg_comments_per_pull_request":0.25,"merged_pull_requests_count":4,"bot_issues_count":0,"bot_pull_requests_count":0,"past_year_issues_count":1,"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":1,"past_year_avg_comments_per_issue":1.0,"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/cajuncoding%2FSqlTransactionalOutbox/issues","maintainers":[{"login":"cajuncoding","count":4,"url":"https://issues.ecosyste.ms/api/v1/hosts/GitHub/authors/cajuncoding"}],"active_maintainers":[]},"versions_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/sqltransactionaloutbox.sqlserver.systemdatans/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/sqltransactionaloutbox.sqlserver.systemdatans/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/sqltransactionaloutbox.sqlserver.systemdatans/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/sqltransactionaloutbox.sqlserver.systemdatans/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/packages/sqltransactionaloutbox.sqlserver.systemdatans/codemeta","maintainers":[{"uuid":"cajuncoding","login":"cajuncoding","name":null,"email":null,"url":null,"packages_count":38,"html_url":"https://www.nuget.org/profiles/cajuncoding","role":null,"created_at":"2024-02-26T02:06:20.979Z","updated_at":"2024-02-26T02:06:20.979Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/maintainers/cajuncoding/packages"},{"uuid":"raerae1616","login":"raerae1616","name":null,"email":null,"url":null,"packages_count":37,"html_url":"https://www.nuget.org/profiles/raerae1616","role":null,"created_at":"2024-02-26T02:06:21.022Z","updated_at":"2024-02-26T02:06:21.022Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/nuget.org/maintainers/raerae1616/packages"}]}