示例#1
0
        public void QueryExecute_DescribeAsQueryString_NoExceptionsThrown()
        {
            // Arrange
            Query query = new Query("DESCRIBE Person;");

            // Act
            MySqlConnectionReader connectionReader = query.Execute();

            connectionReader.Connection.Close();
        }
示例#2
0
        public static void ResetTables()
        {
            Query query = new Query("SHOW TABLES;");
            MySqlConnectionReader connectionReader = query.Execute();
            List <string>         tables           = new List <string>();

            while (connectionReader.Reader.Read())
            {
                tables.Add(connectionReader.Reader.GetString(0));
            }
            foreach (string table in tables)
            {
                Query.ExecuteQueryString("DROP TABLE IF EXISTS " + table + ";");
            }
            connectionReader.Connection.Close();
            Program.SetupTables(ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ToString());
            Program.SetupAdmin(ConfigurationManager.ConnectionStrings["MySQLConnectionString"].ToString());
        }