Here are the examples of the csharp api class System.Data.Common.DbProviderFactories.GetFactory(string) taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
89 Examples
0
1. Example
View licenseprotected override DbProviderFactory CreateFactory()
{
return DbProviderFactories.GetFactory("Sap.Data.Hana");
}0
2. Example
View licensepublic DbProviderFactory GetDbProviderFactory(string connectionStringName)
{
_logger.Info("Get App Setting - Looking up DbProviderFactory value '{0}' to see what DbProviderFactory should be retrieved", connectionStringName);
return DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName);
}0
3. Example
View licensepublic override DbProviderFactory GetFactory()
{
return DbProviderFactories.GetFactory("System.Data.OleDb");
}0
4. Example
View licenseprivate static DbProviderFactory GetFactory(string provider)
{
return DbProviderFactories.GetFactory(provider);
}0
5. Example
View licenseprivate static DbProviderFactory ImportDbProviderFactory(DbProviderType providerType, string conStr)
{
string providerName = providerInvariantNames[providerType];
DbProviderFactory factory = null;
try
{
//?????????
switch (providerType)
{
//case DbProviderType.MySql:
// factory = new MySql.Data.MySqlClient.MySqlClientFactory();
// break;
default:
factory = DbProviderFactories.GetFactory(providerName);
break;
}
}
catch (Exception)
{
factory = null;
}
return factory;
}0
6. Example
View licensepublic DbProviderFactory ResolveProviderFactory(DbConnection connection)
{
#if NET_45_OR_GREATER
return DbProviderFactories.GetFactory(connection);
#else
return DbProviderFactories.GetFactory(MySqlProviderInvariantName.ProviderName);
#endif
}0
7. Example
View licenseprivate static DbProviderFactory GetFactory(string name) {
if (ConfigurationManager.ConnectionStrings[name] == null)
throw new ConfigurationErrorsException("No connection string found with name \"" + name + "\"");
// Store the provider name.
ProviderName = ConfigurationManager.ConnectionStrings[name].ProviderName;
// Create the factory.
return DbProviderFactories.GetFactory(ConfigurationManager.ConnectionStrings[name].ProviderName);
}0
8. Example
View licensepublic static DatabaseManager CreateFromConnectionStringName(string connectionStringName, string providerName)
{
var manager = new DatabaseManager { Provider = DbProviderFactories.GetFactory(providerName) };
if (manager.Provider == null)
throw new ArgumentException("Provider is a required component of the connection string.",
nameof(providerName));
manager._connectionString = ConfigurationManager.ConnectionStrings[connectionStringName]
.ConnectionString;
return manager;
}0
9. Example
View licensepublic static DatabaseManager CreateFromConnectionString(string connectionString, string providerName)
{
var manager = new DatabaseManager
{
_connectionString = connectionString,
Provider = DbProviderFactories.GetFactory(providerName)
};
if (manager.Provider == null)
throw new ArgumentException("Provider is a required component of the connection string.",
nameof(providerName));
return manager;
}0
10. Example
View licenseprotected DbProviderFactory GetDbProviderFactory(string databaseProviderName) {
try {
return DbProviderFactories.GetFactory(databaseProviderName);
}
catch (Exception ex) {
throw new DataClientFactoryNotFoundException(databaseProviderName, ex);
}
}0
11. Example
View licenseinternal static void VerifyProvider()
{
try
{
DbProviderFactories.GetFactory(ProviderInvariantName);
}
catch (Exception ex)
{
throw new EffortException(
ExceptionMessages.AutomaticRegistrationFailed,
ex);
}
}0
12. Example
View licensepublic static DbProviderFactory GetProviderFactory(String invariantName)
{
//if(invariantName.Equals("pg", StringComparison.InvariantCultureIgnoreCase)
// || invariantName.Equals("pgsql", StringComparison.InvariantCultureIgnoreCase)
// || invariantName.Equals("npgsql", StringComparison.InvariantCultureIgnoreCase)
// || invariantName.Equals("psql", StringComparison.InvariantCultureIgnoreCase))
// return Npgsql.NpgsqlFactory.Instance;
//else if(!String.IsNullOrEmpty(invariantName))
// return DbProviderFactories.GetFactory(invariantName);
//else
return DbProviderFactories.GetFactory("System.Data.SqlClient");
}0
13. Example
View licensepublic static DbProviderFactory GetProvider(string connectionName)
{
string providerName = GetProviderName(connectionName);
DbProviderFactory provider = DbProviderFactories.GetFactory(providerName);
return provider;
}0
14. 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
15. 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
16. 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
17. 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
18. Example
View licensestatic DbProviderFactory GetProviderFactory(string providerInvariantName) {
if (providerInvariantName == null) throw new ArgumentNullException(nameof(providerInvariantName));
DbProviderFactory factory = factories.GetOrAdd(providerInvariantName, n => DbProviderFactories.GetFactory(n));
return factory;
}0
19. Example
View licenseinternal static void RegisterDatabase(string databaseId, string providerInvariantName, string connectionString)
{
RegisterDatabase(databaseId, DbProviderFactories.GetFactory(providerInvariantName), connectionString);
}0
20. Example
View licenseprivate static DbProviderFactory GetFactory(string connectionStringName)
{
var providerName = "System.Data.SqlClient";
if (!string.IsNullOrWhiteSpace(ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName))
providerName = ConfigurationManager.ConnectionStrings[connectionStringName].ProviderName;
var factory = DbProviderFactories.GetFactory(providerName);
return factory;
}0
21. Example
View licensepublic static DbConnection CreateConnection(string connectionString, string providerName)
{
var factory = DbProviderFactories.GetFactory(providerName);
var connection = factory.CreateConnection();
if (connection != null)
{
connection.ConnectionString = connectionString;
}
return connection;
}0
22. Example
View licensepublic static DbConnection CreateConnection(string providerInvariantName)
{
DbProviderFactory factory = DbProviderFactories.GetFactory(providerInvariantName);
return factory.CreateConnection();
}0
23. Example
View licenseinternal static DbConnection WrapConnection(DbConnection connection, params string[] wrapperProviderInvariantNames)
{
foreach (string invariantName in wrapperProviderInvariantNames)
{
DbProviderFactory factory = DbProviderFactories.GetFactory(invariantName);
var connectionWrapper = factory.CreateConnection();
DbConnectionWrapper wrapper = (DbConnectionWrapper)connectionWrapper;
wrapper.WrappedConnection = connection;
connection = connectionWrapper;
}
return connection;
}0
24. Example
View licensepublic static DbProviderFactory GetFactory(string providerName)
{
DbProviderFactory factory;
if (!factories.TryGetValue(providerName, out factory))
{
var newFactories = new Dictionary<string, DbProviderFactory>(factories);
DbProviderFactories.GetFactory(providerName);
factory = newFactories[providerName] = DbProviderFactories.GetFactory(providerName);
factories = newFactories;
}
return factory;
}0
25. Example
View licenseprivate DbConnection GetDbConnection(string name)
{
var dbConfig = ConfigurationManager.ConnectionStrings[name];
if (dbConfig == null) throw new InvalidOperationException("Unable to find 'TestDb' in the config file.");
var dbProviderFactory = DbProviderFactories.GetFactory(dbConfig.ProviderName);
var connection = dbProviderFactory.CreateConnection();
connection.ConnectionString = dbConfig.ConnectionString;
return connection;
}0
26. Example
View licenseprivate DbConnection CreateConnection()
{
DbProviderFactory factory = DbProviderFactories.GetFactory(_connectionStringSettings.ProviderName);
DbConnection connection = factory.CreateConnection();
if (connection == null)
{
throw new DataException("Could not create database connection");
}
connection.ConnectionString = _connectionStringSettings.ConnectionString;
return connection;
}0
27. Example
View licensepublic static DbConnectionStringEqualityComparer GetConnectionStringEqualityComparer(string providerInvariantName)
{
providerInvariantName = Check.EmptyCheck(providerInvariantName);
DbProviderFactory factory = DbProviderFactories.GetFactory(providerInvariantName);
return GetConnectionStringEqualityComparer(factory);
}0
28. Example
View licensepublic static DbConnectionStringTester GetConnectionStringTester(string providerInvariantName)
{
providerInvariantName = Check.EmptyCheck(providerInvariantName);
DbProviderFactory factory = DbProviderFactories.GetFactory(providerInvariantName);
return GetConnectionStringTester(factory);
}0
29. Example
View licenseprivate static DbProviderFactory GetProviderFactoryForProviderGuid( this IVsDataProviderManager dataProviderManager, Guid provider )
{
var providerInvariantName = dataProviderManager.GetProviderInvariantName( provider );
DbProviderFactory factory = null;
if ( string.IsNullOrEmpty( providerInvariantName ) )
return factory;
try
{
factory = DbProviderFactories.GetFactory( providerInvariantName );
}
catch ( ConfigurationException )
{
}
catch ( ArgumentException )
{
}
return factory;
}0
30. Example
View licensepublic System.Data.Common.DbConnection CreateConnection(string nameOrConnectionString)
{
if (nameOrConnectionString == "Disco.Data.Repository.DiscoDataContext")
{
var connectionString = DiscoDataContextConnectionString;
if (connectionString == null)
{
throw new InvalidOperationException("The Disco DataContext Connection String has not been configured");
}
// Build DiscoDataContext - Use Default Connection Factory (SQLClient)
//return this.DefaultConnectionFactory.CreateConnection(connectionString);
var connection = DbProviderFactories.GetFactory("System.Data.SqlClient").CreateConnection();
connection.ConnectionString = connectionString;
return connection;
}
return SqlCeConnectionFactory.CreateConnection(nameOrConnectionString);
}0
31. Example
View licenseprivate void LoadConfiguration()
{
var connectionString = ConfigurationManager.ConnectionStrings["MusicStoreEntities"];
var factory = DbProviderFactories.GetFactory(connectionString.ProviderName);
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString.ConnectionString;
connection.Open();
MvcMusicStore.Framework.Configuration.Current = connection.Query<ConfigurationModel>("SELECT * FROM Configuration").First();
}
}0
32. Example
View licenseprivate static DbConnection InternalCreateDbConnection( string connectionString, string dbProviderFactoryInvariantName )
{
if ( String.IsNullOrWhiteSpace( connectionString ) )
{
throw new ArgumentNullException( "connectionString" );
}
if ( String.IsNullOrWhiteSpace( dbProviderFactoryInvariantName ) )
{
throw new ArgumentNullException( "dbProviderFactoryInvariantName" );
}
DbProviderFactory dbProviderFactory = DbProviderFactories.GetFactory( dbProviderFactoryInvariantName );
DbConnection connection = dbProviderFactory.CreateConnection();
if ( connection == null )
{
throw new Exception( "An unknown error occurred creating a connection as the call to DbProviderFactory.CreateConnection() returned null." );
}
connection.ConnectionString = connectionString;
return connection;
}0
33. Example
View licensepublic static DbCommand GetDbCommand()
{
var dbProviderFactory = DbProviderFactories.GetFactory( "System.Data.SqlClient" );
var connection = dbProviderFactory.CreateConnection();
var dbCommand = connection.CreateCommand();
return dbCommand;
}0
34. Example
View licenseprivate IDbConnection CreateAndOpenConnection()
{
if (_connectionString == null)
{
_connectionString = ConfigurationManager.ConnectionStrings["sqlaccountrepository"];
if (_connectionString == null)
throw new ConfigurationErrorsException(
"Failed to find connection string for the SqlAccountRepository. Create one named 'sqlaccountrepository' in the connectionStrings section of web.config.");
}
if (_factory == null)
{
_factory = DbProviderFactories.GetFactory(_connectionString.ProviderName);
if (_factory == null)
throw new ConfigurationErrorsException("Failed to find a provider factory named '" +
_connectionString.ProviderName + "'.");
}
var connection = _factory.CreateConnection();
if (connection == null)
throw new InvalidOperationException("Provider factory did not create an connection");
connection.ConnectionString = _connectionString.ConnectionString;
connection.Open();
return connection;
}0
35. Example
View licensepublic static Database Create(string connectionStringName)
{
CheckUtil.ArgumentN/n ..... /n //View Source file for more details /n }0
36. Example
View licenseprivate IEnumerable<TResult> CreateConnectionAndEnumerate(string connectionStringName, object parameters)
{
var connectionStringSettings = ConfigurationManager.ConnectionStrings[connectionStringName];
//todo: default to sql server
var factory = DbProviderFactories.GetFactory(connectionStringSettings.ProviderName);
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = connectionStringSettings.ConnectionString;
connection.Open();
foreach (var result in connection.Query<TResult>(Sql, parameters))
yield return result;
}
}0
37. Example
View license[Test]
public void WhenCreatedWithDbFactoryThenCanReturnConnection()
{
var factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
var provider = new DbProviderFactoryDriveConnectionCommandProvider(factory);
using(var connection =provider.CreateConnection())
{
Assert.That(connection, Is.Not.Null);
}
}0
38. Example
View license[Test]
public void WhenCreatedWithDbFactoryThenCanReturnCommand()
{
var factory = DbProviderFactories.GetFactory("System.Data.OracleClient");
var provider = new DbProviderFactoryDriveConnectionCommandProvider(factory);
using (var command = provider.CreateCommand())
{
Assert.That(command, Is.Not.Null);
}
}0
39. Example
View licenseprotected void EnsureFactory()
{
try
{
string name = ResolveProviderName(this.ProviderName);
if (name == WELLKNOWN_PROVIDER_OLEDB)
{
EnsureOleDbSyntax();
}
_factory = DbProviderFactories.GetFactory(name);
}
catch (ArgumentException ex)
{
var error = new ErrorRecord(ex, "ProviderNotFound", ErrorCategory.InvalidArgument, this.ProviderName);
ThrowTerminatingError(error);
}
}0
40. Example
View licenseDbConnection GetConnection()
{
DbConnectionStringBuilder b = new DbConnectionStringBuilder/n ..... /n //View Source file for more details /n }0
41. Example
View licensepublic static DbConnection CreateConnection(string connectionName)
{
string connectionString;
var providerName = GetProviderInvariantName(connectionName, out connectionString);
if (providerName == null) return null;
var factory = DbProviderFactories.GetFactory(providerName);
var connection = factory.CreateConnection();
if (connection != null)
{
connection.ConnectionString = connectionString;
}
return connection;
}0
42. Example
View licensepublic static DbDataAdapter CreateDataAdapter(DbConnection connection)
{
var providerName = GetProviderInvariantNameByConnectionString(connection.ConnectionString);
return providerName != null ? DbProviderFactories.GetFactory(providerName).CreateDataAdapter() : null;
}0
43. Example
View licensepublic static DbParameter CreateParameter(DbConnection connection, string name, object value)
{
var providerName = GetProviderInvariantNameByConnectionString(connection.ConnectionString);
if (providerName != null)
{
var parameter = DbProviderFactories.GetFactory(providerName).CreateParameter();
parameter.ParameterName = name;
parameter.Value = value;
return parameter;
}
return null;
}0
44. Example
View licenseprotected override void DoOpen()
{
Assert.State(!_initialized, "Reader is already initialized.");
Assert.IsNull(_dataReader, "Data reader is still opened.");
try
{
_factory = DbProviderFactories.GetFactory(ConnectionString.ProviderName);
InitializeConnection();
InitializeDataReader();
}
catch (Exception)
{
Close();
throw;
}
}0
45. Example
View licensepublic static DbConnection OpenConnection(this ConnectionStringSettings connectionStringSettings)
{
if (connectionStringSettings == null) throw new ArgumentNullException("connectionStringSettings");
var providerFactory = DbProviderFactories.GetFactory(connectionStringSettings.ProviderName);
var connection = providerFactory.CreateConnection();
if (connection != null)
{
connection.ConnectionString = connectionStringSettings.ConnectionString;
connection.Open();
}
return connection;
}0
46. Example
View licenseprivate static IDictionary<string, object> DetermineConnectionStringKeyValuePairs(
/n ..... /n //View Source file for more details /n }0
47. Example
View licensepublic List<CartItem> GetCartDetials()
{
var connectionString = ConfigurationManager.ConnectionStrings["MusicStoreEntities"];
var factory = DbProviderFactories.GetFactory(connectionString.ProviderName);
using (var connection = factory.CreateConnection())
{
connection.ConnectionString = connectionString.ConnectionString;
connection.Open();
return connection.Query<CartItem>(string.Format("SELECT C.RecordId, C.CartId, C.AlbumId, C.Count, C.DateCreated, A.Title AS AlbumTitle, A.Price AS AlbumPrice, AR.Name AS ArtistName, G.Name AS GenreName FROM Carts C LEFT JOIN Albums A ON C.AlbumId = A.AlbumId LEFT JOIN Artists AR ON A.ArtistId = AR.ArtistId LEFT JOIN Genres G ON A.GenreId = G.GenreId WHERE CartId = '{0}'", ShoppingCartId)).ToList();
}
}0
48. Example
View licensepublic EntityConnection AdaptConnection(string connectionString)
{
// Parse the connection string for relevant data
var connectionData = new EntityConnectionStringBuilder(connectionString);
// If the connection string contains only a reference to a .config name, load that referenced connection string
if (!string.IsNullOrEmpty(connectionData.Name))
connectionData = new EntityConnectionStringBuilder(ConfigurationManager.ConnectionStrings[connectionData.Name].ConnectionString);
// Create our connection and populate it with the connectionString value
var connection = DbProviderFactories.GetFactory(connectionData.Provider).CreateConnection();
connection.ConnectionString = connectionData.ProviderConnectionString;
// Generate an entity connection with the resultant connection, walk the workspace, and return
return new EntityConnection(AdaptWorkspace(connectionData), connection);
}0
49. Example
View licenseprivate void ParseDbName()
{
var factory = DbProviderFactories.GetFactory(this.ProviderName);
var con = factory.CreateConnection();
con.ConnectionString = this.ConnectionString;
var database = con.Database;
//System.Data.OracleClient ???????????????
if (string.IsNullOrWhiteSpace(database))
{
//Oracle ???????Schema????????
var match = Regex.Match(this.ConnectionString, @"User Id=\s*(?<dbName>\w+)\s*");
if (!match.Success)
{
throw new NotSupportedException("?????????????????????" + this.ConnectionString);
}
database = match.Groups["dbName"].Value;
}
this._database = database;
}0
50. Example
View licenseprivate void CommonConstruct()
{
_transactionDepth = 0;
EnableAutoSelect = true;
EnableNamedParams = true;
ForceDateTimesToUtc = true;
if (_providerName != null)
_factory = DbProviderFactories.GetFactory(_providerName);
string dbtype = (_factory == null ? _sharedConnection.GetType() : _factory.GetType()).Name;
if (dbtype.StartsWith("MySql")) _dbType = DBType.MySql;
else if (dbtype.StartsWith("SqlCe")) _dbType = DBType.SqlServerCE;
else if (dbtype.StartsWith("Npgsql")) _dbType = DBType.PostgreSQL;
else if (dbtype.StartsWith("Oracle")) _dbType = DBType.Oracle;
else if (dbtype.StartsWith("SQLite")) _dbType = DBType.SQLite;
if (_dbType == DBType.MySql && _connectionString != null && _connectionString.IndexOf("Allow User Variables=true") >= 0)
_paramPrefix = "?";
if (_dbType == DBType.Oracle)
_paramPrefix = ":";
}