xss.ConnectionManager 3.1.0

This package handles the connection to the database. Allowing the developer to focus only in the SP and parameters he has to send, and no more configurations.

Install-Package xss.ConnectionManager -Version 3.1.0

dotnet add package xss.ConnectionManager --version 3.1.0

<PackageReference Include="xss.ConnectionManager" Version="3.1.0" />

paket add xss.ConnectionManager --version 3.1.0

#r "nuget: xss.ConnectionManager, 3.1.0"

Release Notes

v3.0.1
changed OpenConnection obsolete from true to false
v3.0.0
updated packages all
removed support for net472;netcore3.0;netcore2.0;netcore2.2
only supports net48;netcoreapp3.1;
Needed keys in webconfig:
v3.0.2
upgrade xss.ConfigurationEncrypter 2.0.0 and  xss.EncryptionKernel 3.0.1
<add key="db_primary" value="{connection name}" /><add key="db_crypto_environment" value="{Encrypted environment, can be empty}" />
     
     From version 2.3.0 it will read encrypted connectionStrings in Any environments.
     Contact Infrastructure team to get your encrypted connection string
      `
     Support .Netcore 3.0 and .netframework 4.8

     How to pass user defined table types:

     ListParameters parameters = new ListParameters();
     parameters.Add("@marketId", 7);
     parameters.Add("@countryCode", "");
     parameters.Add("@languageId", 1);

     CommandParameter queryCommand = new CommandParameter("Market_GetByParameters_Sp", parameters);
     DataRow rowResult = DbManager.Instance.ExecuteRegister(queryCommand);

     For Net Core projects you have to add this in the project setup main.cs, startup.cs, etc
     , or the place you stablished

     DbManager.SetConfiguration(IConfiguration config);

-v3.1.0 : Update methods for Dataset using DataAdapter and explicit closed connection

Dependencies

• .NETCoreApp 3.1

  • System.Configuration.ConfigurationManager (>= 4.7.0)
  • System.Data.SqlClient (>= 4.8.2)
  • xss.ConfigurationEncrypter (>= 2.0.0)
  • xss.EncryptionKernel (>= 3.0.1)
  • xss.FrameworkConfigurationProxy (>= 1.0.0.2)

• .NETFramework 4.8

  • System.Configuration.ConfigurationManager (>= 4.7.0)
  • System.Data.SqlClient (>= 4.8.2)
  • xss.ConfigurationEncrypter (>= 2.0.0)
  • xss.EncryptionKernel (>= 3.0.1)
  • xss.FrameworkConfigurationProxy (>= 1.0.0.2)

Used By

Version History