C# (CSharp) SolarFlareCommon MySqlConnectionHelper Examples

Example #1

File: MySqlConnectionProvider.cs Project: tom-weatherhead/solar-flare

        public MySqlConnection GetMySqlConnection()
        {
            MySqlConnection con = MySqlConnectionCache;

            if (con == null)
            {
                con = MySqlConnectionHelper.GetConnection(m_strConnectionString);
                MySqlConnectionCache = con;
                return(con);
            }

            if (con.State != ConnectionState.Open)
            {
#if TRY_TO_REOPEN_CONNECTIONS
                bool bGetNewConnection = false;

                try
                {
                    con.Close();
                    con.Open();

                    if (con.State != ConnectionState.Open)
                    {
                        bGetNewConnection = true;
                    }
                }
                catch
                {
                    bGetNewConnection = true;
                }

                if (bGetNewConnection)
                {
                    MySqlConnectionCache = null;
                    con.Dispose();
                    con = MySqlConnectionHelper.GetConnection(m_strConnectionString);
                    MySqlConnectionCache = con;
                }
#else
                MySqlConnectionCache = null;
                con.Dispose();
                con = MySqlConnectionHelper.GetConnection(m_strConnectionString);
                MySqlConnectionCache = con;
#endif
            }

            return(con);
        }

Example #2

File: MySqlConnectionProvider.cs Project: tom-weatherhead/solar-flare

 public MySqlConnection GetMySqlConnection()
 {
     return(MySqlConnectionHelper.GetFlareConnection());
 }