SharpPersistence 0.0.2

.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 SharpPersistence --version 0.0.2
                    


                    

                
NuGet\Install-Package SharpPersistence -Version 0.0.2
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="SharpPersistence" Version="0.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="SharpPersistence" Version="0.0.2" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="SharpPersistence" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add SharpPersistence --version 0.0.2
                    


                    

                
#r "nuget: SharpPersistence, 0.0.2"
#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. 
#:package SharpPersistence@0.0.2
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package. 
#addin nuget:?package=SharpPersistence&version=0.0.2
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=SharpPersistence&version=0.0.2
                    


                            Install as a Cake Tool
Branch Status
main Dotnet 9

SharpPersistence

SharpPersistence is a robust, extensible, and thoroughly tested .NET library for working with relational database systems.

Installation

To install, run one of the following commands:

dotnet add package SharpPersistence

and

dotnet add package SharpPersistence.Abstractions

Or visit SharpPersistence on NuGet and SharpPersistence.Abstractions on NuGet

Features

  • RepositoryBase with IRepositoryBase

    • All CRUD operations with async support
    • Multiple overloads for flexible querying
    • Proper EF Core tracking management
    • Dependency injection ready
    • Readable, maintainable, and well-formatted code

  • UnitOfWork with IUnitOfWork

    • Transactional management of multiple repository operations
    • Ensures atomicity and consistency across changes
    • Integrates seamlessly with the repository pattern
    • Simplifies commit/rollback logic in service layers

  • SQL Check Constraint Generator (SqlCheckConstrainGenerator)

    • Type-safe, raw SQL check constraint generation
    • Supports multiple RDBMS (SQL Server, PostgreSQL, MySQL)
    • Naming convention support (PascalCase, lower_snake_case, UPPER_SNAKE_CASE)
    • Handles all SQL comparison, logical, and set operators
    • Proper string escaping and identifier delimiting
    • Fully tested for edge cases and all method combinations

Testing

  • All features are covered by xUnit v3 and Shouldly assertions.
  • Tests cover all overloads, edge cases, and RDBMS/naming convention combinations.
  • To run tests: 
    dotnet test

Contributing

Contributions are welcome! Please open issues or submit pull requests for bug fixes, improvements, or new features.

Product Compatible and additional computed target framework versions.
.NET net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.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
0.0.7 0 9/12/2025
0.0.6 185 6/27/2025
0.0.4 289 6/10/2025
0.0.3 148 6/4/2025
0.0.2 155 5/29/2025
0.0.1 154 5/29/2025