ASC.DbLoggerUtility
1.0.2
dotnet add package ASC.DbLoggerUtility --version 1.0.2
NuGet\Install-Package ASC.DbLoggerUtility -Version 1.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="ASC.DbLoggerUtility" Version="1.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="ASC.DbLoggerUtility" Version="1.0.2" />
<PackageReference Include="ASC.DbLoggerUtility" />
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 ASC.DbLoggerUtility --version 1.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: ASC.DbLoggerUtility, 1.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 ASC.DbLoggerUtility@1.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=ASC.DbLoggerUtility&version=1.0.2
#tool nuget:?package=ASC.DbLoggerUtility&version=1.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
DbLoggerUtility
DbLoggerUtility is a lightweight and reusable helper for logging database calls in ASP.NET Core applications. It supports both ADO.NET and EF Core, and standardizes execution time, error, and result logging using ILogger.
Features
- โฑ Measures and logs DB call execution time.
- ๐ Logs whether records were found or not.
- ๐จ Catches and logs exceptions in DB queries.
- โ๏ธ Works with EF Core and raw ADO.NET.
- ๐งช Easy to plug into any repository or service.
Example Usage
EF Core Example
var result = await DbLoggerUtility.LogDbCallAsync(
() => _context.Users.Where(u => u.IsActive).ToListAsync(),
procedureName: "GetActiveUsers",
user: "admin@demo.com",
requestId: HttpContext.TraceIdentifier,
logger: _logger
);
ADO.NET Example
var result = await DbLoggerUtility.LogDbCallAsync(
async () =>
{
using var cmd = new SqlCommand("GetUsers", connection);
cmd.CommandType = CommandType.StoredProcedure;
using var reader = await cmd.ExecuteReaderAsync();
var list = new List<User>();
while (await reader.ReadAsync())
{
list.Add(new User { Id = reader.GetInt32(0) });
}
return list;
},
procedureName: "GetUsers",
user: "admin@demo.com",
requestId: HttpContext.TraceIdentifier,
logger: _logger
);
License
MIT
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net6.0 is compatible. 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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Microsoft.AspNetCore.Http.Abstractions (>= 2.3.0)
- Microsoft.Extensions.Logging.Abstractions (>= 9.0.6)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.