GraphQL.RepoDb.SqlServer 12.0.1

.NET Standard 2.1 This package targets .NET Standard 2.1. 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 GraphQL.RepoDb.SqlServer --version 12.0.1                

                    
                

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

                    
                

            
#r "nuget: GraphQL.RepoDb.SqlServer, 12.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 GraphQL.RepoDb.SqlServer as a Cake Addin
#addin nuget:?package=GraphQL.RepoDb.SqlServer&version=12.0.1

// Install GraphQL.RepoDb.SqlServer as a Cake Tool
#tool nuget:?package=GraphQL.RepoDb.SqlServer&version=12.0.1

A set of extensions for working with HotChocolate GraphQL and RepoDb as the data access micro-orm without dependency on IQueryable.  This enables fully encapsulated control over SQL queries in every way within a Service or Repository layer of your application. This extension pack provides a significantly simplified facade to access critial elements such as Selections/Projections, Sort arguments, & Paging arguments with support for mapping them to Models using built in RepoDb functionality.  It also leverages RepoDb to provide a generic, Relay spec compatible, cursor pagination/slice query api for Sql Server.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  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. 
.NET Core netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.1 is compatible. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos 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
13.0.0 1,383 7/26/2023
12.4.1.1 1,762 1/11/2022
12.0.1 1,208 10/16/2021
11.3.8 1,271 10/16/2021
11.2.2.5 1,179 8/9/2021
11.2.2.3 1,133 5/13/2021
11.2.2.2 1,185 4/27/2021
11.0.4.3 1,181 4/26/2021
11.0.4.1 1,384 12/18/2020
11.0.2.1 1,318 12/11/2020
11.0.1.1 1,414 12/6/2020
11.0.0.3-preview02 1,174 11/17/2020
11.0.0.3-preview 1,112 11/17/2020
11.0.0.2 1,345 11/6/2020

- Upgraded to now support HotChocolate version 12 with v12.0.1 and synced Nuget Version

     Prior Releases Notes:
     - Bump HotChocolate version to v11.3.8 (latest v11 version before jumping to v12) and synced Nuget Version
     - Added support for raw sql where filtering with Parameterization for complex where filtering and field processing (e.g. LOWER(), TRIM() functions on fields, or Full Text Search via CONTAINS(), FREETEXT(), etc.).
     - Fix bug with TotalCount not returning when pagination or other filtering returns no results.
     - Potential Breaking Change: Fixed method signatures to all consistently support specifying table name; this might potentially have some breaking changes to method signatures, but functionality is compatible once signatures are corrected.
     - Provide RepoDb extension meethod QueryBulkResultsByIdAsync() which enalbes high performance retrieval of very large result sets in bulk based on int Id values; this safely alleviates the limitation of max 2100 parameter bindings on SqlCmd when using Contains() expressions.
     - Breaking change but simplified the RepoDB Custom extension methods for CursorPaging and OffsetPaging to take in IRepoDbCursorPagingParams and IRepoDbOffsetPagingParams respectively instead of discrete values.
     - This helps minimizes the risk of the issue arising from the Optimization to not rely on TotalCount; it introduced a non-intuitive breaking change in the ReboDB Custom extensions whereby the new 'IsTotalCountRequested' param from the GraphQLParamsContext must be explicitly provided.
     - This also makes future enhancements easier and the method signatures more maintainable going forward.
     - Also need to highlight another potential issue from the code optimization: Now the Cursor and Offset paging arguments are fully optional and both will default with consistent behavior to retrieve all data.
     - Therefore Any enforcement to require paging args or limit the data if they are not provided must now be done by the consuming code; this helps the library be less opinionated and flexible but may now open prior uses to selecting more data than intended; this may be improved with configuration value in a future release.
     - Bugfix where Count could be incorrect due to potential null values skipped by Sql Server Count() aggregation over specific field vs '*'.
     - Bump HotChocolate version to v11.2.2 stable and sync Nuget version.
     - Bump RepoDB (Sql Server) version to v1.1.3 stable
     - Optimized paging algorithm to eliminate the dependency on TotalCount for computing HasPreviousPage/HasNextPage paging metadata.
     - Optimized TotalCount query to now only be executed when requested (e.g. User requests totalCount in the GraphQL query).
     - Add full RepoDB support for OffsetPaging (e.g. using Skip/Take instead of Batch Query (Page Size/Page Number).
     - Some code cleanup and optimizations.
     - Sync version with the latest Pre-processing Extensions.
     - Add support (and fix consistency) with CommandTimeout for all query methods.
     - Add .ConfigureAwait(false) to all awaits for performance.
     - Bump version to HotChocolate v11.0.4.
     - Bump to HotChocolate v11.0.2 and sync with PreProcessingExtensions issue fix release.
     - Bump to HotChocolate v11.0.1 which now resolves a bug that we helped identify with interfaces in the initial release of v11.0.0.
     - Fix issue with Sort/OrderBy field not working if not also part of Selection. OffsetPaging is not working, it's still work in progress. But this release provides ability to trace log out some details for the query, execution time, etc. Also improves support for cancellation token throughout DB calls and minor optimizations and cleanup.