public string ConnectionString(ConexionType conexionType, string server, string db, string user, string password)
{
var connectionString = "";
switch (_conexionType)
{
case ConexionType.MSSQLServer:
SqlConnectionStringBuilder sqlbuilder = new SqlConnectionStringBuilder
{
DataSource = server,
InitialCatalog = db,
UserID = user,
Password = password
};
connectionString = sqlbuilder.ConnectionString;
break;
//case ConexionType.PostgreSQL:
// PgSqlConnectionStringBuilder pgbuilder = new PgSqlConnectionStringBuilder();
// pgbuilder.Host = server;
// pgbuilder.Database = db;
// pgbuilder.UserId = user;
// pgbuilder.Password = password;
// connectionString = pgbuilder.ConnectionString;
// break;
}
return(connectionString);
}
protected void ConexionInit(ConexionType conexionType, string connectionString)
{
ConexionTimeOut = 30;
_conexionType = conexionType;
switch (_conexionType)
{
case ConexionType.MSSQLServer:
_conexion = new SqlConnection(connectionString);
var csb = new System.Data.SqlClient.SqlConnectionStringBuilder(connectionString);
_connectionString = new ConnectionString(csb.DataSource, csb.InitialCatalog, csb.UserID, csb.Password);
break;
//case ConexionType.PostgreSQL:
// _conexion = new PgSqlConnection(conectionString);
// break;
}
DbSchema = new ConexionSchema(this, conexionType);
//ConexionHelper = new ConexionHelper(this, conexionType)
//{
// ConectionString = conectionString,
// DbConnection = _conexion
//};
}
protected void ConexionInit(ConexionType conexionType, string conectionString)
{
ConexionTimeOut = 30;
_conexionType = conexionType;
switch (_conexionType)
{
case ConexionType.MSSQLServer:
_conexion = new SqlConnection(conectionString);
break;
//case ConexionType.PostgreSQL:
// _conexion = new PgSqlConnection(conectionString);
// break;
}
//ConexionHelper = new ConexionHelper(this, conexionType)
//{
// ConectionString = conectionString,
// DbConnection = _conexion
//};
}
public Conexion(ConexionType conexionType, ConnectionString connectionString)
{
ConexionInit(conexionType, this.ConnectionStringBuilder(conexionType, connectionString.Server, connectionString.Database, connectionString.User, connectionString.Password));
}
public Conexion(ConexionType conexionType, string connectionString)
{
ConexionInit(conexionType, connectionString);
}
public Conexion(ConexionType conexionType, string server, string db, string user, string password)
{
ConexionInit(conexionType, ConnectionStringBuilder(conexionType, server, db, user, password));
}
public ConexionSchema(Conexion conexion, ConexionType conexionType)
{
_conexion = conexion;
ConexionType = conexionType;
}
