C# 连接SqlServer、MySql

demo

using MySql.Data.MySqlClient;
using System;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApp4
{

    class Program
    {
        //SqlServer
        static string SqlConn =
            "server=172.20.121.136;uid=sa;pwd=abc123;database=Platform";
        //MySql
        static string MySqlConn =
            @"server=172.20.180.42;Database=Platform;
              Uid=root;Pwd=abc123;Port=3306;Allow User Variables=True;";
        static void Main(string[] args)
        {
            string sql = "select * from SYS_User;";
            DataTable dtSql = GetSqlDataTable(SqlConn, sql);
            DataTable dtMySql = GetMySqlDataTable(MySqlConn, sql);
        }
        public static DataTable GetSqlDataTable(string conn, string sql
            , params SqlParameter[] parms)
        {
            using (SqlConnection connection = new SqlConnection(conn))
            {
                SqlCommand command = connection.CreateCommand();
                command.CommandText = sql;
                command.Parameters.AddRange(parms);
                SqlDataAdapter adapter = new SqlDataAdapter(command);
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                return dt;
            }
        }
        public static DataTable GetMySqlDataTable(string conn, string sql
            , params MySqlParameter[] parms)
        {
            using (MySqlConnection connection = new MySqlConnection(conn))
            {
                MySqlCommand command = connection.CreateCommand();
                command.CommandText = sql;
                command.Parameters.AddRange(parms);
                MySqlDataAdapter adapter = new MySqlDataAdapter(command);
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                return dt;
            }
        }

    }
}