EngramaCoreStandar 1.1.2
dotnet add package EngramaCoreStandar --version 1.1.2
NuGet\Install-Package EngramaCoreStandar -Version 1.1.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="EngramaCoreStandar" Version="1.1.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="EngramaCoreStandar" Version="1.1.2" />
<PackageReference Include="EngramaCoreStandar" />
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 EngramaCoreStandar --version 1.1.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: EngramaCoreStandar, 1.1.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 EngramaCoreStandar@1.1.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=EngramaCoreStandar&version=1.1.2
#tool nuget:?package=EngramaCoreStandar&version=1.1.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Engrama Core (EngramaCoreStandar)
NuGet library for Engrama apps: Dapper + SQL Server stored procedures (API) and HttpClient helpers (Blazor PWA).
Install / reference
From source (this template): project-reference EngramaCoreStandar (version 1.1.2).
From NuGet: EngramaCoreStandar — publish 1.1.2 after packing this project.
DI
// API
builder.Services.AddEngramaDependenciesAPI();
// Blazor WASM
builder.Services.AddEngramaDependenciesBlazor();
// also register HttpClient with BaseAddress
Connection string key (required for Dapper helpers):
"ConnectionStrings": {
"EngramaCloudConnection": "Server=...;Database=...;..."
}
Dapper helpers — which method to use
| Helper | SP receives TVP list? | Returns |
|---|---|---|
GetAsync<TResult, TRequest> |
No | 1 row |
GetAllAsync<TResult, TRequest> |
No | N rows |
GetWithListAsync<TResult, TRequest> |
Yes (IEnumerable<DT*>) |
1 row |
GetAllWithListAsync<TResult, TRequest> |
Yes | N rows |
TVP rules
- SQL:
CREATE TYPE dbo.DTMyType AS TABLE (...)and SP param@Items DTMyType READONLY. - C#: class named exactly
DTMyTypewith matching columns. Requestproperty:IEnumerable<DTMyType> Items(name = SQL param without@).- Empty lists are supported (schema is built from the element type).
Full Engrama walkthrough: MetodologiaEngrama/8- Guia Consultas SP.md in TemplatePWA.
Servicios (Blazor)
IHttpService—Get,Post,Put,Delete, multipart helpersIValidaServicioService— mapsResponse<T>HTTP wrappers toSeverityMessagefor UI
1.1.2 improvements
- Fixed
BuildSqlCommand(compile error) GetAllWithListAsyncqualifies SP with schema ([dbo].[sp…])- Empty TVP DataTables keep column schema
- Safer reader column mapping
- Fixed inverted null check in
ValidateSPResult - Script
GetAsyncusesQueryFirstOrDefaultAsync(not scalar) - Added
Put/DeleteonIHttpService
| Product | Versions 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. net9.0 was computed. 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. |
| .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.
-
.NETStandard 2.1
- AutoMapper (>= 15.1.3)
- Dapper (>= 2.1.66)
- Microsoft.Data.SqlClient (>= 5.2.2)
- Microsoft.Extensions.Configuration.Abstractions (>= 9.0.2)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 9.0.6)
- Microsoft.Extensions.Logging.Abstractions (>= 9.0.6)
- Newtonsoft.Json (>= 13.0.3)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.