本文整理汇总了C#中SqlDatabase.CreateConnection方法的典型用法代码示例。如果您正苦于以下问题：C# SqlDatabase.CreateConnection方法的具体用法？C# SqlDatabase.CreateConnection怎么用？C# SqlDatabase.CreateConnection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlDatabase的用法示例。
在下文中一共展示了SqlDatabase.CreateConnection方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ConnectionTest
public void ConnectionTest()
{
DatabaseConfigurationView view = new DatabaseConfigurationView(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = view.GetConnectionStringSettings("NewDatabase");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
DbConnection connection = sqlDatabase.CreateConnection();
Assert.IsNotNull(connection);
Assert.IsTrue(connection is SqlConnection);
connection.Open();
DbCommand cmd = sqlDatabase.GetSqlStringCommand("Select * from Region");
cmd.CommandTimeout = 60;
Assert.AreEqual(cmd.CommandTimeout, 60);
}示例2: CheckNoPasswordInConnectionStringWithPersistInfoEqualsFalse
public void CheckNoPasswordInConnectionStringWithPersistInfoEqualsFalse()
{
try
{
CreateUser();
DatabaseConfigurationView view = new DatabaseConfigurationView(TestConfigurationSource.CreateConfigurationSource());
ConnectionStringSettings data = view.GetConnectionStringSettings("NorthwindPersistFalse");
SqlDatabase sqlDatabase = new SqlDatabase(data.ConnectionString);
DbConnection dbConnection = sqlDatabase.CreateConnection();
dbConnection.Open();
dbConnection.Close();
string connectionString = dbConnection.ConnectionString;
if (connectionString.ToLower().Contains("pwd") || connectionString.ToLower().Contains("password"))
{
Assert.Fail();
}
}
finally
{
DeleteUser();
}
}示例3: CheckNoPasswordWithPersistInfoEqualsFalseForDynamicConnectionString
public void CheckNoPasswordWithPersistInfoEqualsFalseForDynamicConnectionString()
{
try
{
CreateUser();
ConnectionString testString =
new ConnectionString(@"server=(local)\SQLEXPRESS;database=Northwind;uid=entlib;pwd=hdf7&834k(*KA;Persist Security Info=false", "UserId,UId", "Password,Pwd");
SqlDatabase sqlDatabase = new SqlDatabase(testString.ToString());
DbConnection dbConnection = sqlDatabase.CreateConnection();
dbConnection.Open();
dbConnection.Close();
string connectionString = dbConnection.ConnectionString;
if (connectionString.ToLower().Contains("pwd") || connectionString.ToLower().Contains("password"))
{
Assert.Fail();
}
}
finally
{
DeleteUser();
}
}示例4: ClosingAnXmlReaderExecutedWithATrasactionDoesNotCloseTheUnderlyingConnection_Bug2751
public void ClosingAnXmlReaderExecutedWithATrasactionDoesNotCloseTheUnderlyingConnection_Bug2751()
{
var database = new SqlDatabase(@"server=(local)\SQLEXPRESS;database=Northwind;Integrated Security=true");
using (var connection = database.CreateConnection())
{
connection.Open();
var transaction = connection.BeginTransaction();
var command = new SqlCommand { CommandText = "Select * from Region for xml auto", CommandType = CommandType.Text };
using (var reader = database.ExecuteXmlReader(command, transaction))
{
Assert.AreNotEqual(ConnectionState.Closed, command.Connection.State);
}
Assert.AreNotEqual(ConnectionState.Closed, command.Connection.State);
}
}