本文整理汇总了C#中IConnectionProvider.CreateConnection方法的典型用法代码示例。如果您正苦于以下问题：C# IConnectionProvider.CreateConnection方法的具体用法？C# IConnectionProvider.CreateConnection怎么用？C# IConnectionProvider.CreateConnection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IConnectionProvider的用法示例。
在下文中一共展示了IConnectionProvider.CreateConnection方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Execute
protected virtual string Execute(IQuery query,
IDictionary<string, string> parameters, IConnectionProvider provider) {
using (IDbConnection connection = provider.CreateConnection())
using (var builder = new CommandBuilder(connection)) {
builder
.SetText(query.QueryText)
.SetType(GetCommandType(query.Options))
.SetTimeout(query.Options
.GetInteger(Strings.kCommandTimeoutOption, 30));
BindParameters(builder, query.Parameters, parameters);
string preferred_json_collection = query.Options
.GetString(Strings.kJsonCollectionOption,
Strings.kDefaultJsonCollection);
IDbCommand cmd = builder.Build();
connection.Open();
string response =
(query.QueryMethod == QueryMethod.Get)
? ExecuteReader(cmd, query, preferred_json_collection)
: ExecuteNonQuery(cmd, query, preferred_json_collection);
connection.Close();
return response;
}
}示例2: TestCreateConnection
public void TestCreateConnection()
{
provider = new MsSqlConnectionProvider(connectionStringName);
object actual = provider.CreateConnection();
Assert.IsNotNull(actual);
Assert.IsInstanceOfType(typeof (IDbConnection), actual);
Assert.IsFalse(string.IsNullOrEmpty(((IDbConnection)actual).ConnectionString));
Assert.AreEqual(ConnectionState.Closed, ((IDbConnection) actual).State);
}示例3: GetServerVersion
private string GetServerVersion(IConnectionProvider connectionProvider)
{
using (var connection = connectionProvider.CreateConnection())
{
using (var command = connection.CreateCommand())
{
command.CommandType = CommandType.Text;
command.CommandText = "SELECT VERSION();";
connection.OpenIfClosed();
return command.ExecuteScalar() as string;
}
}
}示例4: MicrOrmDataStrategy
protected MicrOrmDataStrategy(IConnectionProvider connectionProvider)
{
ConnectionProvider = connectionProvider;
Connection = connectionProvider.CreateConnection();
Connection.Open();
}