How to connect amazon RDS database through c#????

Questions & Answers
1

How to connect amazon RDS database through c#???
code?
set-up something?
install something?
please help me T.T!!!

2

//use other script to call method

using UnityEngine;
using System;
using System.Data;
using System.Collections;
using MySql.Data.MySqlClient;
using MySql.Data;
using System.IO;

public class SqlAccess
{

public static MySqlConnection dbConnection;

static string host = "192.168.1.106";  
static string id = "root";
static string pwd = "1234";
static string database = "aaa"; 


public SqlAccess()
{
	OpenSql();
}

public static void OpenSql()
{
   
	try
	{
		string connectionString = string.Format("Server = {0};port={4};Database = {1}; User ID = {2}; Password = {3};",host,database,id,pwd,"3306");
		dbConnection = new MySqlConnection(connectionString);
		dbConnection.Open(); 
	}catch (Exception e)
	{
        throw new Exception("error" + e.Message.ToString());  
		
	}
	
}

public DataSet CreateTable (string name, string[] col, string[] colType)
{
    if (col.Length != colType.Length) 
	{

        throw new Exception ("columns.Length != colType.Length");

    }

    string query = "CREATE TABLE " + name + " (" + col[0] + " " + colType[0];

    for (int i = 1; i < col.Length; ++i) {

        query += ", " + col _+ " " + colType*;*_

}
query += “)”;
return ExecuteQuery(query);
}

* public DataSet CreateTableAutoID (string name, string[] col, string[] colType)*
{
if (col.Length != colType.Length)
* {*
throw new Exception (“columns.Length != colType.Length”);
}
string query = “CREATE TABLE " + name + " (” + col[0] + " " + colType[0] + " NOT NULL AUTO_INCREMENT";
for (int i = 1; i < col.Length; ++i) {

query += ", " + col + " " + colType*;*
}
query += “, PRIMARY KEY (”+ col[0] +“)” + “)”;

* Debug.Log(query);*

return ExecuteQuery(query);
}

* public DataSet InsertInto (string tableName, string[] values)*
{
string query = “INSERT INTO " + tableName + " VALUES (” + “'”+ values[0]+ “'”;
for (int i = 1; i < values.Length; ++i) {
query += ", " + “'”+values*+ “'”;*
}
query += “)”;

* Debug.Log(query);*
return ExecuteQuery (query);
}

* public DataSet InsertInto (string tableName, string[] col,string[] values)*
{

* if (col.Length != values.Length)*
* {*
throw new Exception (“columns.Length != colType.Length”);
}

string query = “INSERT INTO " + tableName + " (” + col[0];
* for (int i = 1; i < col.Length; ++i)*
* {*
query += ", "+col*;*
}

* query += “) VALUES (” + “'”+ values[0]+ “'”;*
for (int i = 1; i < values.Length; ++i)
* {*
query += ", " + “'”+values*+ “'”;*
}
query += “)”;

* Debug.Log(query);*
return ExecuteQuery (query);
}

* public DataSet SelectWhere (string tableName, string[] items, string[] col, string[] operation, string[] values)*
{
if (col.Length != operation.Length || operation.Length != values.Length) {
throw new Exception (“col.Length != operation.Length != values.Length”);
}
string query = "SELECT " + items[0];
for (int i = 1; i < items.Length; ++i) {
query += ", " + items*;*
}
query += " FROM " + tableName + " WHERE " + col[0] + operation[0] + “'” + values[0] + "’ ";
for (int i = 1; i < col.Length; ++i) {
query += " AND " + col + operation + “'” + values[0] + "’ ";
}
return ExecuteQuery (query);
}

* public DataSet UpdateInto (string tableName, string []cols,string []colsvalues,string selectkey,string selectvalue)*
* {*
* string query = "UPDATE “+tableName+” SET “+cols[0]+” = "+colsvalues[0];*
* for (int i = 1; i < colsvalues.Length; ++i) {*
query += “, " +cols_+” ="+ colsvalues*;
}
query += " WHERE “+selectkey+” = “+selectvalue+” ";
return ExecuteQuery (query);
}*_

* public DataSet Delete(string tableName,string []cols,string []colsvalues)*
* {*
* string query = "DELETE FROM “+tableName + " WHERE " +cols[0] +” = " + colsvalues[0];*
* for (int i = 1; i < colsvalues.Length; ++i)*
* {*
query += " or " +cols_+" = "+ colsvalues*;
}
Debug.Log(query);
return ExecuteQuery (query);
}*_

* public void Close()*
* {*

* if(dbConnection != null)*
* {*
* dbConnection.Close();*
* dbConnection.Dispose();*
* dbConnection = null;*
* }*

* }*

public static DataSet ExecuteQuery(string sqlString)
{
* if(dbConnection.State==ConnectionState.Open)*
* {*
* DataSet ds = new DataSet();*
* try*
* {*

* MySqlDataAdapter da = new MySqlDataAdapter(sqlString, dbConnection);*
* da.Fill(ds);*

* }*
* catch (Exception ee)*
* {*
* throw new Exception(“SQL:” + sqlString + “/n” + ee.Message.ToString());*
* }*
* finally*
* {*
* }*
* return ds;*
* }*
* return null;*
* }*

}