Tatum.ClientSecretFetcher 1.0.1

ClientSecretService

##Overview ClientSecretService is a service designed to securely retrieve client secrets from a database and cache them for optimized performance. It leverages Dapper for efficient database queries and MemoryCache for in-memory caching to reduce database load.

##Features Retrieves client secrets from the Vendors table. Caches secrets in-memory for 24 hours to minimize database queries. Implements robust error handling for timeouts, SQL errors, and system failures.

Installation

You can install this package using NuGet Package Manager:

dotnet add package Tatum.ClientSecretFetcher

Or in the NuGet Package Manager Console:

Install-Package Tatum.ClientSecretFetcher

##Usage

#For ASP.NET Core applications, register ClientSecretService as a singleton in the dependency injection container:

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddSingleton<IClientSecretService>(sp =>
	new ClientSecretService("Server=myServer;Database=myDB;User Id=myUser;Password=myPass;"));

var app = builder.Build();

#Injecting ClientSecretService in Controllers or Services E.g Using ClientSecretService in an API Controller public class AuthController : ControllerBase { private readonly IClientSecretService _clientSecretService;

	public AuthController(IClientSecretService clientSecretService)
	{
		_clientSecretService = clientSecretService;
	}

	[HttpGet("/get-secret/{clientId}")]
	public async Task<IActionResult> GetSecret(string clientId)
	{
		var response = await _clientSecretService.GetClientSecretAsync(clientId);
		return Ok(response);
	}
}

#If you prefer not to use dependency injection, initialize ClientSecretService manually:

var clientSecretService = new ClientSecretService("Server=myServer;Database=myDB;User Id=myUser;Password=myPass;");
var secret = await clientSecretService.GetClientSecretAsync("someClientId");

API Reference

# `Task<Response> GetClientSecretAsync(string clientId)`

# Parameters:
	`clientId` *(string)*: The unique identifier for the client.

# Returns:
	 Response` object containing:
	`Code` (string): Status code (Success, ResourceNotFound, or Error codes).
	`Message` (string): Description of the response.
	`Data` (string): The client secret if found.

# Example Response:
json
{
  "Code": "00",
  "Message": "Success",
  "Data": "SomeSecretKey"
}
```

Error Handling

The service gracefully handles the following errors:

• Database Connection Issues: Returns an error message if the database is unreachable.
• SQL Timeout: Handles timeouts and advises users to retry later.
• Resource Not Found: Returns an appropriate response if the client secret does not exist.
• General Exceptions: Captures unexpected errors and returns a system malfunction message.

How It Works

1. Checks if the client secret is cached.
2. If found, returns the cached value.
3. If not found, queries the database.
4. If retrieved successfully, caches it for 24 hours.
5. If any error occurs, returns an appropriate response.