/// <summary>
 /// Defines the mapping between logical enum key and actual connection string key.
 /// </summary>
 [AttributeUsage(AttributeTargets.Field)]
 public sealed class ConnectionKeyAttribute(string name, params string[] synonyms) : Attribute
 {
 public string Name { get; } = name;
 public HashSet<string> Synonyms = [.. synonyms];
 }

 /// <summary>
 /// Enumerates supported SQL Server connection string keys.
 /// </summary>
 public enum SqlConnectionKeys
 {
 [ConnectionKey(DbConnectionStringKeywords.ApplicationIntent, DbConnectionStringSynonyms.ApplicationIntent)]
 ApplicationIntent,
 [ConnectionKey(DbConnectionStringKeywords.ApplicationName, DbConnectionStringSynonyms.App)]
 ApplicationName,
 [ConnectionKey(DbConnectionStringKeywords.AttachDbFilename, DbConnectionStringSynonyms.ExtendedProperties, DbConnectionStringSynonyms.InitialFileName)]
 AttachDbFilename,
 [ConnectionKey(DbConnectionStringKeywords.AttestationProtocol)]
 AttestationProtocol,
 [ConnectionKey(DbConnectionStringKeywords.Authentication)]
 Authentication,
 [ConnectionKey(DbConnectionStringKeywords.ColumnEncryptionSetting)]
 ColumnEncryptionSetting,
 [ConnectionKey(DbConnectionStringKeywords.CommandTimeout)]
 CommandTimeout,
 [ConnectionKey(DbConnectionStringKeywords.ConnectRetryCount, DbConnectionStringSynonyms.ConnectRetryCount)]
 ConnectRetryCount,
 [ConnectionKey(DbConnectionStringKeywords.ConnectRetryInterval, DbConnectionStringSynonyms.ConnectRetryInterval)]
 ConnectRetryInterval,
 [ConnectionKey(DbConnectionStringKeywords.ConnectTimeout, DbConnectionStringSynonyms.ConnectionTimeout, DbConnectionStringSynonyms.Timeout)]
 ConnectTimeout,
 [ConnectionKey(DbConnectionStringKeywords.ContextConnection)]
 ContextConnection,
 [ConnectionKey(DbConnectionStringKeywords.CurrentLanguage, DbConnectionStringSynonyms.Language)]
 CurrentLanguage,
 [ConnectionKey(DbConnectionStringKeywords.DataSource, DbConnectionStringSynonyms.Addr, DbConnectionStringSynonyms.Address, DbConnectionStringSynonyms.NetworkAddress, DbConnectionStringSynonyms.Server)]
 DataSource,
 [ConnectionKey(DbConnectionStringKeywords.EnclaveAttestationUrl)]
 EnclaveAttestationUrl,
 [ConnectionKey(DbConnectionStringKeywords.Encrypt)]
 Encrypt,
 [ConnectionKey(DbConnectionStringKeywords.Enlist)]
 Enlist,
 [ConnectionKey(DbConnectionStringKeywords.FailoverPartner)]
 FailoverPartner,
 [ConnectionKey(DbConnectionStringKeywords.FailoverPartnerSpn, DbConnectionStringSynonyms.FailoverPartnerSpn)]
 FailoverPartnerSpn,
 [ConnectionKey(DbConnectionStringKeywords.HostNameInCertificate, DbConnectionStringSynonyms.HostNameInCertificate)]
 HostNameInCertificate,
 [ConnectionKey(DbConnectionStringKeywords.InitialCatalog, DbConnectionStringSynonyms.Database)]
 InitialCatalog,
 [ConnectionKey(DbConnectionStringKeywords.IntegratedSecurity, DbConnectionStringSynonyms.TrustedConnection)]
 IntegratedSecurity,
 [ConnectionKey(DbConnectionStringKeywords.IpAddressPreference, DbConnectionStringSynonyms.IpAddressPreference)]
 IpAddressPreference,
 [ConnectionKey(DbConnectionStringKeywords.LoadBalanceTimeout, DbConnectionStringSynonyms.ConnectionLifetime)]
 LoadBalanceTimeout,
 [ConnectionKey(DbConnectionStringKeywords.MultipleActiveResultSets, DbConnectionStringSynonyms.MultipleActiveResultSets)]
 MultipleActiveResultSets,
 [ConnectionKey(DbConnectionStringKeywords.MaxPoolSize)]
 MaxPoolSize,
 [ConnectionKey(DbConnectionStringKeywords.MinPoolSize)]
 MinPoolSize,
 [ConnectionKey(DbConnectionStringKeywords.MultiSubnetFailover, DbConnectionStringSynonyms.MultiSubnetFailover)]
 MultiSubnetFailover,
 [ConnectionKey(DbConnectionStringKeywords.PacketSize)]
 PacketSize,
 [ConnectionKey(DbConnectionStringKeywords.Password, DbConnectionStringSynonyms.Pwd)]
 Password,
 [ConnectionKey(DbConnectionStringKeywords.PersistSecurityInfo, DbConnectionStringSynonyms.PersistSecurityInfo)]
 PersistSecurityInfo,
 [ConnectionKey(DbConnectionStringKeywords.Pooling)]
 Pooling,
 [ConnectionKey(DbConnectionStringKeywords.PoolBlockingPeriod, DbConnectionStringSynonyms.PoolBlockingPeriod)]
 PoolBlockingPeriod,
 [ConnectionKey(DbConnectionStringKeywords.Replication)]
 Replication,
 [ConnectionKey(DbConnectionStringKeywords.ServerCertificate, DbConnectionStringSynonyms.ServerCertificate)]
 ServerCertificate,
 [ConnectionKey(DbConnectionStringKeywords.ServerSpn, DbConnectionStringSynonyms.ServerSpn)]
 ServerSpn,
 [ConnectionKey(DbConnectionStringKeywords.TrustServerCertificate, DbConnectionStringSynonyms.TrustServerCertificate)]
 TrustServerCertificate,
 [ConnectionKey(DbConnectionStringKeywords.TransactionBinding)]
 TransactionBinding,
 [ConnectionKey(DbConnectionStringKeywords.TypeSystemVersion)]
 TypeSystemVersion,
 [ConnectionKey(DbConnectionStringKeywords.UserId, DbConnectionStringSynonyms.Uid, DbConnectionStringSynonyms.User)]
 UserId,
 [ConnectionKey(DbConnectionStringKeywords.UserInstance)]
 UserInstance,
 [ConnectionKey(DbConnectionStringKeywords.WorkstationId, DbConnectionStringSynonyms.WsId)]
 WorkstationId
 }

 /// <summary>
 /// Abstract base class for type-safe connection string management.
 /// </summary>
 public abstract class ConnectionStringBase<TKey>
 where TKey : struct, Enum
 {
 protected static readonly IReadOnlySet<string> NormalizeAliases = InitializeNormalizedAlias();
 protected static readonly IReadOnlyDictionary<string, TKey> AliasToKey = InitializeAliasToKeyDictionary();
 protected static readonly IReadOnlyDictionary<TKey, string> KeyToAlias = InitializeKeyToAliasDictionary();
 #region Initialize dictionary
 private static HashSet<string> InitializeNormalizedAlias()
 => [.. Enum<TKey>.GetAttributes<ConnectionKeyAttribute>().Select(a => a.Name)];
 private static Dictionary<string, TKey> InitializeAliasToKeyDictionary()
 => new(Enum<TKey>
 .GetEnumAttributePairs<ConnectionKeyAttribute>()
 .SelectMany(pairs =>
 {
 var allAlias = pairs.Value.Synonyms;
 allAlias.Add(pairs.Value.Name);
 return allAlias.Select(a => KeyValuePair.Create(a, pairs.Key));
 }));
 private static Dictionary<TKey, string> InitializeKeyToAliasDictionary()
 => Enum<TKey>
 .GetEnumAttributePairs<ConnectionKeyAttribute>()
 .ToDictionary(x => x.Key, x => x.Value.Name);
 #endregion
 protected string NormalizeAlias(string incomingAlias)
 {
 try
 {
 return NormalizeAliases.Contains(incomingAlias) ? incomingAlias : KeyToAlias[AliasToKey[incomingAlias]];
 }
 catch (KeyNotFoundException)
 {
 IoC.Instance.Resolve<IConsoleLogger>().Error($"this attributes '{incomingAlias}' is not an official key to construct connection string");
 return string.Empty;
 }
 }
 
 }