Here are the examples of the csharp api class System.Data.Common.DbProviderFactory.CreateConnection() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
168 Examples
0
1. Example
View licensepublic override DbConnection CreateConnection()
{
var connection = _dbProviderFactory.CreateConnection();
if (connection == null)
{
return null;
}
var profiledConnection = connection as ProfiledDbConnection;
if (profiledConnection != null)
{
return profiledConnection;
}
return new ProfiledDbConnection(connection, _dbProfiler);
}0
2. Example
View licensepublic IDbConnection CreateConnection(string connectionString)
{
var connection = Factory.CreateConnection();
connection.ConnectionString = connectionString;
return connection;
}0
3. Example
View licensepublic DbConnection CreateConnection()
{
DbConnection newConnection = dbProvider.DbProviderFactory.CreateConnection();
newConnection.ConnectionString = ConnectionString;
return newConnection;
}0
4. Example
View licensepublic DbConnection CreateConnection()
{
DbConnection newConnection = dbProvider.DbProviderFactory.CreateConnection();
newConnection.ConnectionString = ConnectionString;
return newConnection;
}0
5. Example
View licensepublic DbConnection CreateConnection()
{
DbConnection newConnection = dbProvider.DbProviderFactory.CreateConnection();
newConnection.ConnectionString = ConnectionString;
return newConnection;
}0
6. Example
View licenseprivate IDbConnection CreateConnection() => _connectionFactory.CreateConnection(_connectionString);
0
7. Example
View licensepublic static IDbConnection CreateConnection(this DbProviderFactory factory, string connectionString)
{
var connection = factory.CreateConnection();
// ReSharper disable once PossibleNullReferenceException
connection.ConnectionString = connectionString;
return connection;
}0
8. Example
View licensepublic static IDbConnection CreateConnection(this DbProviderFactory factory, string connectionString)
{
var connection = factory.CreateConnection();
// ReSharper disable once PossibleNullReferenceException
connection.ConnectionString = connectionString;
return connection;
}0
9. Example
View licenseprivate DbConnection GetConnection(string connectionString)
{
DbConnection conn = _factory.CreateConnection();
if (conn == null)
{
throw new InvalidOperationException("Factory failed to create connection. Returned null.");
}
conn.ConnectionString = connectionString;
return conn;
}0
10. Example
View licensepublic virtual DbConnection CreateConnection()
{
DbConnection newConnection = _DbProviderFactory.CreateConnection();
newConnection.ConnectionString = ConnectionString;
return newConnection;
}0
11. Example
View licensepublic DbConnection CreateConnection()
{
return dbProviderFactory.CreateConnection();
}0
12. Example
View licensepublic DbConnection getConnection() {
DbConnection conn = _provider.CreateConnection();
conn.ConnectionString = _url;
return conn;
}0
13. Example
View licensepublic DbConnection getConnection() {
DbConnection conn = _provider.CreateConnection();
conn.ConnectionString = _url;
return conn;
}0
14. Example
View licensepublic override DbConnection CreateConnection()
{
return new ProfiledDbConnection(tail.CreateConnection(), profiler);
}0
15. Example
View licenseprivate static IDbConnection GetConnection(string name) {
IDbConnection conn = _factory.CreateConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings[name].ConnectionString;
return conn;
}0
16. Example
View licenseprotected virtual IDbConnection GetConnection()
{
if( this.connection != null )
{
return this.connection;
}
else if( this.providerFactory != null )
{
IDbConnection conn = this.providerFactory.CreateConnection();
conn.ConnectionString = this.connectionString;
return conn;
}
else
{
throw new InvalidOperationException();
}
}0
17. Example
View licensepublic virtual IDbConnection GetConnection() {
return DbProviderFactory.CreateConnection();
}0
18. Example
View licensepublic static IDbConnection CreateConnection(string connectionString)
{
var connection = DbFactory.CreateConnection();
connection.ConnectionString = connectionString;
return connection;
}0
19. Example
View licenseprotected DbConnection CreateConnection(string connectionString)
{
connectionString = Check.EmptyCheck(connectionString);
DbConnection connection = this.ProviderFactory.CreateConnection();
connection.ConnectionString = connectionString;
return connection;
}0
20. Example
View licensepublic IDbConnection GetConnection()
{
var conn = this.factory.CreateConnection();
conn.ConnectionString = @"Data Source=" + this.databaseName;
conn.Open();
return conn;
}0
21. Example
View licenseprotected virtual DbConnection GetDbConnection()
{
var connection = ProviderFactory.CreateConnection();
if (connection == null)
{
throw new ApplicationException("Unable to create conneciton. Please make sure all DLL libraries have been installed.");
}
connection.ConnectionString = ConnectionString;
connection.Open();
return connection;
}0
22. Example
View licensepublic static DbConnection CreateConnection(string invariantName, string connectionString)
{
if (String.IsNullOrWhiteSpace(invariantName))
{
throw new ArgumentNullException(nameof(invariantName));
}
if (String.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException(nameof(connectionString));
}
var factory = factoryCache.GetOrAdd(invariantName, GetFactory).Factory;
var connection = factory.CreateConnection();
if (connection == null)
{
throw new InvalidOperationException($"Database provider factory: '{invariantName}' did not return a connection object.");
}
connection.ConnectionString = connectionString;
return connection;
}0
23. Example
View licenseprivate static bool DbFactoryWorks(DbProviderFactory factory)
{
if (factory != null)
{
try
{
using (var conn = factory.CreateConnection())
{
conn.ConnectionString = "Data Source=:memory:;Pooling=true;";
conn.Open();
return true;
}
}
catch
{
}
}
return false;
}0
24. Example
View licensepublic override DbConnection CreateConnection()
{
try
{
DbConnection dbConnection = dbProviderFactory.CreateConnection();
dbConnection.ConnectionString = ConnectionString;
dbConnection.Open();
return dbConnection;
}
catch (DbException ex)
{
String detail = "DbException: " + ex.Message + " VendorError: " + ex.ErrorCode;
throw new DatabaseConfigException(
"Error obtaining database connection using connection-string '" + ConnectionString +
"' with detail " + detail, ex);
}
}0
25. Example
View licensepublic override DbConnection CreateConnection()
{
DbConnection dbConnection = dbProviderFactory.CreateConnection();
dbConnection.ConnectionString = ConnectionString;
dbConnection.Open();
return dbConnection;
}0
26. Example
View licensepublic override DbConnection CreateConnection()
{
try
{
DbConnection dbConnection = dbProviderFactory.CreateConnection();
dbConnection.ConnectionString = ConnectionString;
dbConnection.Open();
return dbConnection;
}
catch (DbException ex)
{
String detail = "DbException: " + ex.Message + " VendorError: " + ex.ErrorCode;
throw new DatabaseConfigException(
"Error obtaining database connection using connection-string '" + ConnectionString +
"' with detail " + detail, ex);
}
}0
27. Example
View licensepublic override DbConnection CreateConnection()
{
DbConnection dbConnection = dbProviderFactory.CreateConnection();
dbConnection.ConnectionString = ConnectionString;
dbConnection.Open();
return dbConnection;
}0
28. Example
View licensepublic virtual DbConnection OpenConnection()
{
var result = _factory.CreateConnection();
result.ConnectionString = ConnectionProfile.ConnectionString;
result.Open();
return result;
}0
29. Example
View licensepublic virtual DbConnection OpenConnection()
{
var result = _factory.CreateConnection();
result.ConnectionString = ConnectionString;
result.Open();
return result;
}0
30. Example
View licensepublic DbConnection CreateDbConnection(string connectionName)
{
var key = ConfigurationManager.AppSettings[connectionName];
var connectionDetails = WebConfigurationManager.ConnectionStrings[key];
var factory = DbProviderFactories.GetFactory(connectionDetails.ProviderName);
var connection = factory.CreateConnection();
connection.ConnectionString = connectionDetails.ConnectionString;
return connection;
}0
31. Example
View licensepublic override DbConnection CreateConnection()
{
var connection = InnerFactory.CreateConnection();
if (IsAdoMonitoringNeeded())
{
return new GlimpseDbConnection(connection, this);
}
return connection;
}0
32. Example
View licensepublic static DbConnection CreateConnection(string connectionName)
{
var connectionStringSettings = ConfigurationManager.ConnectionStrings[connectionName];
var factory = DbProviderFactories.GetFactory(connectionStringSettings.ProviderName);
DbConnection connection = factory.CreateConnection();
connection.ConnectionString = connectionStringSettings.ConnectionString;
return connection;
}0
33. Example
View licenseprivate DbCommand CreateNewCommand()
{
DbConnection conn = ProviderFactory.CreateConnection();
conn.ConnectionString = ConnectionString;
DbCommand cmd = conn.CreateCommand();
SetSqlMode(cmd);
return cmd;
}0
34. Example
View licenseprivate DbConnection OpenConnection()
{
var connection = _providerFactory.CreateConnection();
connection.ConnectionString = _connectionString;
connection.Open();
return connection;
}0
35. Example
View licenseprivate DbConnection CreateConnection() {
var connection = _ProviderFactory.CreateConnection();
connection.ConnectionString = _ConnectionString;
connection.Open();
return connection;
}0
36. Example
View licenseprivate DbConnection CreateConnection() {
var connection = _ProviderFactory.CreateConnection();
connection.ConnectionString = _ConnectionString;
connection.Open();
return connection;
}0
37. Example
View licenseprotected virtual DbConnection CreateConnection()
{
if (dbProviderFactory == null) {
lock (lck) {
if (dbProviderFactory == null) {
var configDbConnString = ConfigurationManager.ConnectionStrings[dbConnStringName];
dbProviderFactory = DbProviderFactories.GetFactory(configDbConnString.ProviderName ?? "System.Data.SqlClient");
}
}
}
var conn = dbProviderFactory.CreateConnection();
conn.ConnectionString = dbConnString;
return conn;
}0
38. Example
View licenseprotected virtual DbConnection CreateConnection()
{
if (dbProviderFactory == null)
{
lock (lck)
{
if (dbProviderFactory == null)
{
var configDbConnString = ConfigurationManager.ConnectionStrings[dbConnStringName];
dbProviderFactory = DbProviderFactories.GetFactory(configDbConnString.ProviderName ?? "System.Data.SqlClient");
}
}
}
var conn = dbProviderFactory.CreateConnection();
conn.ConnectionString = dbConnString;
return conn;
}0
39. Example
View licensepublic void Dispose()
{
using (var conn = dbProviderFactory.CreateConnection()) {
conn.Open();
conn.Execute("delete from Applications where Path = @path", new { path });
conn.Execute("delete from ApplicationConfigs where Path = @path", new { path });
conn.Execute("delete from Globals where ConfKey = @confKey", new { confkey });
}
}0
40. Example
View licensepublic void Dispose()
{
using (var conn = dbProviderFactory.CreateConnection()) {
conn.Open();
conn.Execute("delete from Users where Id = @userId", new { userId });
conn.Execute("delete from UserClaims where UserId = @userId", new { userId });
}
}0
41. Example
View licensepublic void Dispose()
{
using (var conn = dbProviderFactory.CreateConnection()) {
conn.Open();
conn.Execute("delete from Applications where Path = @path", new { path });
conn.Execute("delete from ApplicationConfigs where Path = @path", new { path });
conn.Execute("delete from Globals where ConfKey = @confKey", new { confkey });
}
}0
42. Example
View licensepublic void Dispose()
{
using (var conn = dbProviderFactory.CreateConnection()) {
conn.Open();
conn.Execute("delete from Users where Id = @userId", new { userId });
conn.Execute("delete from UserClaims where UserId = @userId", new { userId });
}
}0
43. Example
View licensestatic IDbConnection CreateConnection(string connectionString, string callerProviderInvariantName, out string providerInvariantName) {
connectionString = connectionString ?? DatabaseConfiguration.DefaultConnectionString;
providerInvariantName = callerProviderInvariantName ?? DatabaseConfiguration.DefaultProviderInvariantName;
if (connectionString == null) {
throw new InvalidOperationException($"A default connection string name must be specified in the {typeof(DatabaseConfiguration).FullName}.{nameof(DatabaseConfiguration.DefaultConnectionString)} property.");
}
if (providerInvariantName == null) {
throw new InvalidOperationException($"A default provider name must be specified in the {typeof(DatabaseConfiguration).FullName}.{nameof(DatabaseConfiguration.DefaultProviderInvariantName)} property.");
}
DbProviderFactory factory = GetProviderFactory(providerInvariantName);
IDbConnection connection = factory.CreateConnection();
connection.ConnectionString = connectionString;
return connection;
}0
44. Example
View licenseprotected virtual Context GetContext()
{
var provider = GetProvider();
var connection = provider.CreateConnection();
connection.ConnectionString = ConnectionString;
return new Context(connection);
}0
45. Example
View licensepublic virtual DbConnection OpenConnection()
{
var result = _factory.CreateConnection();
result.ConnectionString = ConnectionString;
result.Open();
return result;
}0
46. Example
View licensepublic virtual DbConnection OpenConnection()
{
var result = _factory.CreateConnection();
result.ConnectionString = _connectionString;
result.Open();
return result;
}0
47. Example
View licensestatic DbConnection CreateConnection()
{
return DbConfiguration.DependencyResolver.GetService<DbProviderFactory>(NuoDbProviderServices.ProviderInvariantName).CreateConnection();
}0
48. Example
View licensepublic virtual IDbConnection DbConnection()
{
var fact = Factory.CreateConnection();
if (fact == null)
{
throw new Exception("Factory returned null");
}
fact.ConnectionString = "Data Source=" + DbFile();
return fact;
}0
49. Example
View licensepublic static DbConnection CreateConnection(string invariantName, string connectionString)
{
if (String.IsNullOrWhiteSpace(invariantName))
{
throw new ArgumentNullException(nameof(invariantName));
}
if (String.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException(nameof(connectionString));
}
var factory = factoryCache.GetOrAdd(invariantName, GetFactory).Factory;
var connection = factory.CreateConnection();
if (connection == null)
{
throw new InvalidOperationException($"Database provider factory: '{invariantName}' did not return a connection object.");
}
connection.ConnectionString = connectionString;
return connection;
}0
50. Example
View licenseprivate DbCommand CreateNewCommand()
{
DbConnection conn = ProviderFactory.CreateConnection();
conn.ConnectionString = ConnectionString;
DbCommand cmd = conn.CreateCommand();
SetSqlMode(cmd);
return cmd;
}