Skip to content

Instantly share code, notes, and snippets.

@Fhernd
Created March 28, 2018 12:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Fhernd/34ef13490c39335adaa86f352758b41d to your computer and use it in GitHub Desktop.
Save Fhernd/34ef13490c39335adaa86f352758b41d to your computer and use it in GitHub Desktop.
Codificación de cadena de conexión con el uso de SqlConnectionStringBuilder. OrtizOL.
using System;
using System.Data.SqlClient;
namespace R903CadenaConexionBD
{
class R903Programa
{
static void Main(string[] args)
{
String cadenaConexion = @"Data source =.\SQLEXPRESS; Initial catalog = Northwind;Integrated Security=SSPI;" +
"Min Pool Size= 5; Max Pool Size = 15; Connection Reset = True; Connection Lifetime = 600";
SqlConnectionStringBuilder cadenaConexionBuilder = new SqlConnectionStringBuilder(cadenaConexion);
Console.WriteLine("Parámetros de la cadena de conexión:");
Console.WriteLine("\tFuente de datos: {0}", cadenaConexionBuilder.DataSource);
Console.WriteLine("\tBase de datos: {0}", cadenaConexionBuilder.InitialCatalog);
Console.WriteLine("\t¿Usa Integrated Security?: {0}", cadenaConexionBuilder.IntegratedSecurity);
Console.WriteLine("\tTamaño mínimo del pool: {0}", cadenaConexionBuilder.MinPoolSize);
Console.WriteLine("\tTamaño máximo del pool: {0}", cadenaConexionBuilder.MaxPoolSize);
Console.WriteLine("\tTiempo de vida: {0}", cadenaConexionBuilder.LoadBalanceTimeout);
Console.WriteLine("\nPresione Enter para continuar...");
Console.ReadLine();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment