C# 比使用app.config,用自定义的ConnectionString

using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Reflection;

namespace Assist
{
    public class ContextHelper
    {
        public static string ConnectionString;
        public static string SerializePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)+ @"\serialize\Connection\ConnStr.dat";


        static  ContextHelper()
        {
            if (File.Exists(SerializePath))
                ConnectionString = SerializeHelper.Deserialize<string>(SerializePath);
        }

        /// <summary>
        /// 测试数据库是否能连接
        /// </summary>
        /// <returns></returns>
        public static bool ConnectionTest( )
        {
            bool result = false;
            using (SqlConnection conn = new SqlConnection(ConnectionString))
            {
                conn.Open();
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                    result = true;
                }
            }
            return result;
        }
    }
}

 

posted @ 2023-11-28 16:46  剑小秀  阅读(43)  评论(0)    收藏  举报