private void Button_Click(object sender, RoutedEventArgs e)
{
//WaitingRoom wr = new WaitingRoom() { Name = "query8" };
//KQueryMSSQL q1 = new KQueryMSSQL();
//List<WaitingRoom> wrs = new List<WaitingRoom>();
//wrs.Add(wr);
//wrs.Add(wr);
//q1.Insert<WaitingRoom>(wrs);
// KQueryMySql mySql = new KQueryMySql();
//mySql.Insert<user>(new List<user>() { new user() { Name = "zz" } });
// List<user> us = mySql.Less("ID", 2).Select<user>();
IDatabase mysql = new SQLServerMeta();
mysql.Connect("localhost", "sa", "000000");
MessageBox.Show(mysql.GetTable("DBTrain", "Led").Name);
}
/// <summary>
/// 连接至指定服务器以获取数据库名称列表
/// </summary>
/// <param name="serverName">服务器名</param>
/// <param name="enType">论证方式</param>
/// <param name="uid">用户ID(仅当认证方式为SQL帐户时)</param>
/// <param name="pwd">用户密码(仅当认证方式为SQL帐户时)</param>
/// <param name="lstDBName">成功获取到的数据库名称列表</param>
/// <returns>成功获取返回true,否则为false</returns>
private bool GetCurrentServerDataBaseList(
string serverName,
EnConnectionType enType,
string uid,
string pwd,
out List <string> lstDBName
)
{
lstDBName = null;
//未读取过当前选择的实例下的数据库列表
SQLServerMeta meta = new SQLServerMeta();
SQLConnStringConfig connStrCfg = new SQLConnStringConfig();
connStrCfg.ServerIP = serverName;//服务器名称/IP
//connStrCfg.DataBaseName = "master";
switch (enType)
{
case EnConnectionType.Integrated: //集成身份认证
connStrCfg.ConnectionType = EnConnectionType.Integrated;
break;
case EnConnectionType.DataBaseAccount: //SQL Server 认证
connStrCfg.ConnectionType = EnConnectionType.DataBaseAccount;
connStrCfg.UserName = uid; //用户名
connStrCfg.PassWord = pwd; //密码
break;
}
//尝试连接至服务器
if (!connStrCfg.TryConnect())
{
return(false);//无法连接至服务器
}
meta.ConnStrCfg = connStrCfg;
lstDBName = meta.GetAllDataBaseName();
//无法枚举到任何数据库
if (null == lstDBName || lstDBName.Count < 1)
{
return(false);
}
return(true);
}
/// <summary>
/// 连接至指定服务器以获取数据库名称列表
/// </summary>
/// <param name="serverName">服务器名</param>
/// <param name="enType">论证方式</param>
/// <param name="uid">用户ID(仅当认证方式为SQL帐户时)</param>
/// <param name="pwd">用户密码(仅当认证方式为SQL帐户时)</param>
/// <param name="lstDBName">成功获取到的数据库名称列表</param>
/// <returns>成功获取返回true,否则为false</returns>
private bool GetCurrentServerDataBaseList(
string serverName,
EnConnectionType enType,
string uid,
string pwd,
out List<string> lstDBName
)
{
lstDBName = null;
//未读取过当前选择的实例下的数据库列表
SQLServerMeta meta = new SQLServerMeta();
SQLConnStringConfig connStrCfg = new SQLConnStringConfig();
connStrCfg.ServerIP = serverName;//服务器名称/IP
//connStrCfg.DataBaseName = "master";
switch (enType)
{
case EnConnectionType.Integrated://集成身份认证
connStrCfg.ConnectionType = EnConnectionType.Integrated;
break;
case EnConnectionType.DataBaseAccount://SQL Server 认证
connStrCfg.ConnectionType = EnConnectionType.DataBaseAccount;
connStrCfg.UserName = uid;//用户名
connStrCfg.PassWord = pwd;//密码
break;
}
//尝试连接至服务器
if (!connStrCfg.TryConnect())
return false;//无法连接至服务器
meta.ConnStrCfg = connStrCfg;
lstDBName = meta.GetAllDataBaseName();
//无法枚举到任何数据库
if (null == lstDBName || lstDBName.Count < 1)
return false;
return true;
}
