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;
}
}
}