public void testTrust()
{
// 下面也可以
// Data Source=.;Initial Catalog=mytest;Integrated Security=True
// Data Source=.;Initial Catalog=mytest;Trusted_Connection=True
String str = "Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;";
IDatabaseDialect x = new SQLServerDialect();
String dbname = x.GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "myDataBase");
String dbserver = x.GetConnectionItem(str, ConnectionItemType.Server);
Assert.AreEqual(dbserver, "myServerAddress");
String IsTrusted = x.GetConnectionItem(str, ConnectionItemType.IsTrusted);
Assert.AreEqual(IsTrusted, "True");
String IsTrusted2 = x.GetConnectionItem("Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True", ConnectionItemType.IsTrusted);
Assert.AreEqual(IsTrusted2, "True");
}
public void getDatabase()
{
String str = "server=localhost\\SQL2005;uid=abctest;pwd=***;database=dbnametest;";
String dbname = new SQLServerDialect().GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "dbnametest");
}
public override Object SetParameter( IDbCommand cmd, String parameterName, Object parameterValue )
{
parameterValue = base.processValue( parameterValue );
parameterName = new SQLServerDialect().GetParameterAdder( parameterName );
IDbDataParameter parameter = new SqlParameter( parameterName, parameterValue );
cmd.Parameters.Add( parameter );
return parameterValue;
}
public void testExpress()
{
String str = "Server=.\\SQLExpress;AttachDbFilename=C:\\MyFolder\\MyDataFile.mdf;Database=dbname;Trusted_Connection=Yes;";
IDatabaseDialect x = new SQLServerDialect();
String dbname = x.GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "dbname");
String dbserver = x.GetConnectionItem(str, ConnectionItemType.Server);
Assert.AreEqual(dbserver, ".\\SQLExpress");
String IsTrusted = x.GetConnectionItem(str, ConnectionItemType.IsTrusted);
Assert.AreEqual(IsTrusted, "Yes");
}
public void getDatabase()
{
String str = "server=localhost\\SQL2005;uid=abctest;pwd=***;database=dbnametest;";
IDatabaseDialect x = new SQLServerDialect();
String dbname = x.GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "dbnametest");
String dbserver = x.GetConnectionItem(str, ConnectionItemType.Server);
Assert.AreEqual(dbserver, "localhost\\SQL2005");
String userId = x.GetConnectionItem(str, ConnectionItemType.UserId);
Assert.AreEqual(userId, "abctest");
String pwd = x.GetConnectionItem(str, ConnectionItemType.Password);
Assert.AreEqual(pwd, "***");
}
public void testOther2()
{
String str = "Server=.;Database=myDataBase;User Id=myUsername;Password=myPassword;";
IDatabaseDialect x = new SQLServerDialect();
String dbname = x.GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "myDataBase");
String dbserver = x.GetConnectionItem(str, ConnectionItemType.Server);
Assert.AreEqual(dbserver, ".");
String userId = x.GetConnectionItem(str, ConnectionItemType.UserId);
Assert.AreEqual(userId, "myUsername");
String pwd = x.GetConnectionItem(str, ConnectionItemType.Password);
Assert.AreEqual(pwd, "myPassword");
}
public void testPort2()
{
String str = "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;";
IDatabaseDialect x = new SQLServerDialect();
String dbname = x.GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "myDataBase");
String dbserver = x.GetConnectionItem(str, ConnectionItemType.Server);
Assert.AreEqual(dbserver, "190.190.200.100,1433");
String userId = x.GetConnectionItem(str, ConnectionItemType.UserId);
Assert.AreEqual(userId, "myUsername");
String pwd = x.GetConnectionItem(str, ConnectionItemType.Password);
Assert.AreEqual(pwd, "myPassword");
}
public void testPort()
{
String str = "server=192.168.1.122,1230;uid=myname;pwd=abc111;database=mydb;";
IDatabaseDialect x = new SQLServerDialect();
String dbname = x.GetConnectionItem(str, ConnectionItemType.Database);
Assert.AreEqual(dbname, "mydb");
String dbserver = x.GetConnectionItem(str, ConnectionItemType.Server);
Assert.AreEqual(dbserver, "192.168.1.122,1230");
String userId = x.GetConnectionItem(str, ConnectionItemType.UserId);
Assert.AreEqual(userId, "myname");
String pwd = x.GetConnectionItem(str, ConnectionItemType.Password);
Assert.AreEqual(pwd, "abc111");
}
