SmartSQL/SmartSQL.Framework/Util/ConnectionStringUtil.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Dm;
using MySql.Data.MySqlClient;
using Npgsql;
using System;
using System.Collections.Generic;
using System.Data.OracleClient;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace SmartSQL.Framework.Util
{
    public static class ConnectionStringUtil
    {
        /// <summary>
        /// SQLServer连接字符串
        /// </summary>
        /// <param name="serverAddress"></param>
        /// <param name="port"></param>
        /// <param name="database"></param>
        /// <param name="userName"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public static string SqlServerString(string serverAddress, int port, string database, string userName, string password)
        {
            var serAddress = $"{serverAddress},{port}";
            if (serverAddress.Equals(".") || serverAddress.Contains(@"\"))
            {
                serAddress = serverAddress;
            }
            var sqlConnectionStringBuilder = new SqlConnectionStringBuilder
            {
                DataSource = serAddress,
                InitialCatalog = database,
                UserID = userName,
                Password = EncryptHelper.Decode(password)
            };
            return sqlConnectionStringBuilder.ConnectionString;
        }

        /// <summary>
        /// MySql数据库字符串
        /// </summary>
        /// <param name="serverAddress"></param>
        /// <param name="port"></param>
        /// <param name="database"></param>
        /// <param name="userName"></param>
        /// <param name="password"></param>
        /// <returns></returns>
        public static string MySqlString(string serverAddress, int port, string database, string userName, string password)
        {
            var mySqlConnectionStringBuild = new MySqlConnectionStringBuilder
            {
                Server = serverAddress,
                Port = Convert.ToUInt32(port),
                UserID = userName,
                Password = EncryptHelper.Decode(password),
                SslMode = MySqlSslMode.Preferred,
                AllowUserVariables = true,