Nginx .Net Core5 Mysql C# Connection (SslMode)

Nginx .Net Core5 Mysql Connection String

 

       static private MySqlConnection EDC_conn;
        static private string EDC_GetConnectionString()
        {
            return "Server=서버IP ; Port=3306; Database=log_in; Uid =  아이디; Pwd=비밀번호;  SslMode=Required;";
        }

 static  private string member_search(Member_CHK Items)
        {
            try
            {
              
            string EDC_connectionString = EDC_GetConnectionString();
            using (EDC_conn = new MySqlConnection(EDC_connectionString))
                {

                   
                    MySqlCommand EDC_string = new MySqlCommand
                    {
                        Connection = EDC_conn
                    };
                    EDC_conn.Open();

             
                 var _HPS = new MySqlParameter("@HPS", Items.HP);



                //    EDC_string.CommandText = " select p_memo from log_member where p_num = @Pnum ";
                    EDC_string.CommandText = " select * from log_member ";
                    EDC_string.Parameters.Add(_HPS);

                  
                    MySqlDataReader DB_reader_Eclass_All = EDC_string.ExecuteReader();

                    DataTable DT = new DataTable();
                    DT.Load(DB_reader_Eclass_All);
                    EDC_string.Parameters.Clear();
                    EDC_conn.Close();

     
                    if (DT is null || DT.Rows.Count < 1)
                    {
                        EDC_conn.Close();
                        return "NULL";
                    }

                        return DT.Rows[0].ItemArray[0].ToString();
                } // using
                }
                catch (Exception Ex)
                {
                    EDC_conn.Close();
                    return "ERROR! :"+Ex.Message;

                }
         

        }