/// <summary> /// Finds all of the column names in the given <paramref name="table"/>. /// </summary> /// <param name="table">The table.</param> /// <returns>All of the column names in the given <paramref name="table"/>.</returns> public IEnumerable <string> GetTableColumns(string table) { var ret = new List <string>(); using (var conn = _connectionPool.Acquire()) { using (var cmd = conn.Connection.CreateCommand()) { cmd.CommandText = string.Format("SELECT * FROM `{0}` WHERE 0=1", table); using (var r = cmd.ExecuteReader()) { var fields = r.FieldCount; for (var i = 0; i < fields; i++) { var fieldName = r.GetName(i); ret.Add(fieldName); } } } } return(ret); }
/// <summary> /// Gets the next available connection. /// </summary> /// <returns>Next available connection.</returns> public IPoolableDbConnection GetConnection() { var poolableConn = _connectionPool.Acquire(); return(poolableConn); }