public static MySqlInternalConnection GetConnection(MySqlConnectionString settings) { // make sure the manager is initialized if (MySqlPoolManager.pools == null) { MySqlPoolManager.Initialize(); } string text = settings.GetConnectionString(); lock (pools.SyncRoot) { MySqlPool pool; if (!pools.Contains(text)) { pool = new MySqlPool(settings); pools.Add(text, pool); } else { pool = (pools[text] as MySqlPool); } return(pool.GetConnection()); } }
public MySqlPool(MySqlConnectionString settings) { minSize = settings.MinPoolSize; maxSize = settings.MaxPoolSize; this.settings = settings; inUsePool =new ArrayList(); idlePool = new ArrayList( settings.MinPoolSize ); // prepopulate the idle pool to minSize for (int i=0; i < minSize; i++) CreateNewPooledConnection(); }
public MySqlPool(MySqlConnectionString settings) { minSize = settings.MinPoolSize; maxSize = settings.MaxPoolSize; this.settings = settings; inUsePool = new ArrayList(); idlePool = new ArrayList(settings.MinPoolSize); // prepopulate the idle pool to minSize for (int i = 0; i < minSize; i++) { CreateNewPooledConnection(); } }
public void Open(MySqlConnectionString settings) { // connect to one of our specified hosts try { StreamCreator sc = new StreamCreator(settings.Server, settings.Port, settings.PipeName); stream = sc.GetStream(settings.ConnectionTimeout); } catch (Exception ex) { throw new MySqlException("Unable to connect to any of the specified MySQL hosts", ex); } if (stream == null) { throw new MySqlException("Unable to connect to any of the specified MySQL hosts"); } writer = new BufferedStream(stream); // read off the welcome packet and parse out it's values Packet packet = ReadPacket(); protocol = packet.ReadByte(); versionString = packet.ReadString(); serverVersion = DBVersion.Parse(versionString); threadID = (uint)packet.ReadInteger(4); encryptionSeed = packet.ReadString(); // read in Server capabilities if they are provided serverCaps = 0; if (packet.HasMoreData) { serverCaps = (int)packet.ReadInteger(2); } Authenticate(settings.UserId, settings.Password, settings.UseCompression); // if we are using compression, then we use our CompressedStream class // to hide the ugliness of managing the compression if (settings.UseCompression) { stream = new CompressedStream(stream); writer = new BufferedStream(stream); } isOpen = true; }
public void Open( MySqlConnectionString settings ) { // connect to one of our specified hosts try { StreamCreator sc = new StreamCreator( settings.Server, settings.Port, settings.PipeName ); stream = sc.GetStream( settings.ConnectionTimeout ); } catch (Exception ex) { throw new MySqlException("Unable to connect to any of the specified MySQL hosts", ex); } if (stream == null) throw new MySqlException("Unable to connect to any of the specified MySQL hosts"); writer = new BufferedStream( stream ); // read off the welcome packet and parse out it's values Packet packet = ReadPacket(); protocol = packet.ReadByte(); versionString = packet.ReadString(); serverVersion = DBVersion.Parse( versionString ); threadID = (uint)packet.ReadInteger(4); encryptionSeed = packet.ReadString(); // read in Server capabilities if they are provided serverCaps = 0; if (packet.HasMoreData) serverCaps = (int)packet.ReadInteger(2); Authenticate( settings.UserId, settings.Password, settings.UseCompression ); // if we are using compression, then we use our CompressedStream class // to hide the ugliness of managing the compression if (settings.UseCompression) { stream = new CompressedStream( stream ); writer = new BufferedStream( stream ); } isOpen = true; }
public static MySqlInternalConnection GetConnection( MySqlConnectionString settings ) { // make sure the manager is initialized if (MySqlPoolManager.pools == null) MySqlPoolManager.Initialize(); string text = settings.GetConnectionString(); lock( pools.SyncRoot ) { MySqlPool pool; if (!pools.Contains( text )) { pool = new MySqlPool( settings ); pools.Add( text, pool ); } else { pool = (pools[text] as MySqlPool); } return pool.GetConnection(); } }
public MySqlInternalConnection( MySqlConnectionString connectString ) { settings = connectString; serverVariablesSet = false; }
// Have a constructor that takes a connection string. /// <summary> /// Creates a new connection using the specified connection string. /// </summary> /// <param name="connectString"></param> public MySqlConnection(string connectString) { settings = new MySqlConnectionString(connectString); }
public MySqlInternalConnection(MySqlConnectionString connectString) { settings = connectString; serverVariablesSet = false; }
/// <summary> /// Creates a new connection /// </summary> /// <param name="container"></param> public MySqlConnection(System.ComponentModel.IContainer container) { settings = new MySqlConnectionString(); }
/// <summary> /// Creates a new connection /// </summary> public MySqlConnection() { settings = new MySqlConnectionString("server=localhost"); }
// Have a constructor that takes a connection string. /// <summary> /// Creates a new connection using the specified connection string. /// </summary> /// <param name="connectString"></param> public MySqlConnection(string connectString) { settings = new MySqlConnectionString(connectString); }
/// <summary> /// Creates a new connection /// </summary> /// <param name="container"></param> public MySqlConnection(System.ComponentModel.IContainer container) { settings = new MySqlConnectionString(); }
/// <summary> /// Creates a new connection /// </summary> public MySqlConnection() { settings = new MySqlConnectionString("server=localhost"); }