private void connect()
{
if (sql == null)
{
sql = FactorySql.Create(sqlprovider);
}
if (password != string.Empty && !passEstablished)
{
sqlConnectionString += password;
passEstablished = true;
}
conn = sql.Connection(sqlConnectionString);
conn.Open();
}
/// <summary>
/// Conecta a la base de datos mediante una única conexión.
/// </summary>
/// <param name="connStringName">Nombre de la connectionString que está definida en el archivo de configuración de la aplicación.</param>
static public void Connect(string connStringName)
{
if (uniqueconn != null)
{
string sqlConnString = ConfigurationManager.ConnectionStrings [connStringName].ConnectionString;
string sqlProvider = ConfigurationManager.ConnectionStrings [connStringName].ProviderName;
ISql consql = FactorySql.Create(sqlProvider);
if (password != string.Empty)
{
sqlConnString += password;
}
uniqueconn = consql.Connection(sqlConnString);
uniqueconn.Open();
}
}
private void InitBD()
{
string connString = ConfigurationManager.ConnectionStrings["GebatDataConnectionString"].ConnectionString;
connString += "Password=root";
string provider = ConfigurationManager.ConnectionStrings ["GebatDataConnectionString"].ProviderName;
ISql manager = FactorySql.Create(provider);
FileInfo file = new FileInfo(scriptfilename);
StreamReader lector = file.OpenText();
string script = lector.ReadToEnd();
lector.Close();
DbConnection conn = manager.Connection(connString);
conn.Open();
DbCommand comando = manager.Command(script, conn);
comando.ExecuteNonQuery();
conn.Close();
}
static public bool AttemptConnection(string connStringName)
{
try
{
string trysqlConnectionString = ConfigurationManager.ConnectionStrings[connStringName].ConnectionString;
string trysqlprovider = ConfigurationManager.ConnectionStrings [connStringName].ProviderName;
ISql tryisql = FactorySql.Create(trysqlprovider);
if (password != string.Empty)
{
trysqlConnectionString += password;
}
DbConnection tryconn = tryisql.Connection(trysqlConnectionString);
tryconn.Open();
tryconn.Close();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
