using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.
SqlClient;
using Models;
using System.Configuration;
using System.Xml;
namespace DAL
{
public class DBConfig
{
/// <summary>
/// 禁止实例化
/// </summary>
private DBConfig() { }
public static List<Databases> GetDatabaseName(string connStr)
{
SqlConnection conn
= new
SqlConnection(connStr);
SqlCommand cmd
= new
SqlCommand("select name from sys.databases where name like '%Training%'", conn);
List<Databases> list
= new List<Databases>();
try
{
conn.Open();
SqlDataReader reader
= cmd.ExecuteReader();
while (reader.Read())
{
list.Add(new Databases() { DatabaseName
=reader[0].ToString() });
}
return list;
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
}
}
/// 获取ConnectionStrings
public static string GetConnectionStringsConfig(string connectionName)
{
string connectionString
= ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;
return connectionString;
}
///
/// 更新
连接字符串
public static void UpdateConnectionStringsConfig(string key, string conString)
{
bool isModified
= false; //记录该
连接串是否已经存在
if (ConfigurationManager.ConnectionStrings[key] !
= null)
{
isModified
= true;
}
//新建一个
连接字符串实例
ConnectionStringSettings mySettings
= new ConnectionStringSettings(key, conString);
// 打开可执行的配置文件*.exe.config
Configuration config
= ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
// 如果
连接串已存在，首先删除它
if (isModified)
{
config.ConnectionStrings.ConnectionStrings.Remove(key);
}
// 将新的
连接串添加到配置文件中.
config.ConnectionStrings.ConnectionStrings.Add(mySettings);
// 保存对配置文件所作的更改
config.Save(ConfigurationSaveMode.Modified);
// 强制重新载入配置文件的ConnectionStrings配置节
ConfigurationManager.RefreshSection("connectionStrings");
}
/// <summary>
/// 修改AppSettings中配置
/// </summary>
/// <param name
="key">key值</param>
/// <param name
="value">相应值</param>
public static bool SetConfigValue(string key, string value)
{
try
{
Configuration config
= ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
if (config.AppSettings.Settings[key] !
= null)
config.AppSettings.Settings[key].Value
= value;
else
config.AppSettings.Settings.Add(key, value);
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("appSettings");
return
true;
}
catch
{
return
false;
}
}
/// <summary>
/// 获取AppSettings中某一节点值
/// </summary>
/// <param name
="key"></param>
public static string GetConfigValue(string key)
{
Configuration config
= ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
if (config.AppSettings.Settings[key] !
= null)
return config.AppSettings.Settings[key].Value;
else
return string.Empty;
}
/// <summary>
/// 测试
连接数据库是否成功
/// </summary>
/// <returns></returns>
public static bool ConnectionTest(string ConnectionString)
{
//创建
连接对象
SqlConnection
mySqlConnection
= new
SqlConnection(ConnectionString);
bool IsConnectionInfo
= true;
//ConnectionTimeout 在.net 1.x 可以设置 在.net 2.0后是只读属性，则需要在
连接字符串设置
//如：server
=.;uid
=sa;pwd
=;database
=PMIS;
Integrated Security=SSPI; Connection Timeout
=30
//
mySqlConnection.ConnectionTimeout
= 1;//设置
连接超时的时间
try
{
//Open DataBase
//打开
数据库
mySqlConnection.Open();
IsConnectionInfo
= true;
}
catch
{
//Can not Open DataBase
//打开不成功 则
连接不成功
IsConnectionInfo
= false;
}
finally
{
//Close DataBase
//关闭
数据库连接
mySqlConnection.Close();
}
//
mySqlConnection is a
SqlConnection object
if (
mySqlConnection.State
== ConnectionState.Closed ||
mySqlConnection.State
== ConnectionState.Broken)
{
//Connection is not available
return IsConnectionInfo;
}
else
{
//Connection is available
return IsConnectionInfo;
}
}
}
}
本文探讨SQL数据库连接中的Integrated Security选项，包括SSPI、True和False的含义及用法。 Integrated Security用于指定身份验证方式，SSPI使用Windows凭据，True与SSPI效果相同，False则使用SQL Server身份验证。示例代码展示了不同设置下的连接方法。
订阅专栏 解锁全文
扫一扫
4661
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
