public System.Data.Common.DbProviderFactory GetFactory()
{
System.Data.Common.DbProviderFactory providerFactory = null;
providerFactory = System.Data.Common.DbProviderFactories.GetFactory("System.Data.OracleClient");
return(providerFactory);
} // End Function GetFactory
public System.Data.Common.DbProviderFactory GetFactory()
{
System.Data.Common.DbProviderFactory providerFactory = null;
providerFactory = System.Data.Common.DbProviderFactories.GetFactory("System.Data.OleDb");
return(providerFactory);
}
static SqlFactory()
{
s_cs = GetConnectionString();
s_fac = BlueMine.Data.DbProviderFactories.GetFactory(
typeof(System.Data.SqlClient.SqlClientFactory)
);
}
public ConnectionFactory(DataBase db
, Des3EncryptionService encryption
)
{
try
{
if (db.Factory != null)
{
this.m_factory = db.Factory;
}
else
{
this.m_factory = GetFactory(db.Type);
}
if (string.IsNullOrEmpty(db.ConnectionString))
{
this.m_cs = GetCS(db, this.m_factory);
}
else
{
this.m_cs = db.ConnectionString;
}
this.m_encryption = encryption;
this.m_db = db;
}
catch (System.Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}
} // End Constructor
///// <summary>
// /// 得到连接字符串
///// </summary>
// /// <returns>连接字符串</returns>
// static private string getConnString(string key)
// {
// string connStr = System.Configuration.ConfigurationManager.ConnectionStrings[key].ToString();
// if (connStr == null || connStr == "")
// {
// DBCoreHelper.ErrLog("DBCoreHelper.getConnString(string key):["+key+"]所指定的连接类型为空");
// }
// return connStr;
// }
//public static string GetConnectionEntityString(ref string prividerName)
//{
// var conn = System.Configuration.ConfigurationManager.ConnectionStrings[1].ConnectionString;
// // var esb = new System.Data.EntityClient.EntityConnectionStringBuilder(conn);
// // prividerName = esb.Provider;
// // return esb.ProviderConnectionString;
// //}
// return conn;
//}
//public static string GetConnectionEntityString(ref string prividerName, string connStr)
//{
// if (string.IsNullOrEmpty(connStr))
// return GetConnectionEntityString(ref prividerName);
// var conn = System.Configuration.ConfigurationManager.ConnectionStrings[connStr].ConnectionString;
// //var esb = new System.Data.EntityClient.EntityConnectionStringBuilder(conn);
// //prividerName = esb.Provider;
// //return esb.ProviderConnectionString;
// return conn;
//}
//public static string GetConnectionString(ref string prividerName, string connStr)
//{
// string conn = "";
// if (string.IsNullOrEmpty(connStr))
// conn = GetConnectionEntityString(ref prividerName);
// conn = System.Configuration.ConfigurationManager.ConnectionStrings[connStr].ConnectionString;
// var esb = new System.Data.EntityClient.EntityConnectionStringBuilder(conn);
// prividerName = esb.Provider;
// return esb.ProviderConnectionString;
//}
/// <summary>
/// 打开数据库连接
/// </summary>
/// <param name="connName">连接名</param>
/// <returns></returns>
public static System.Data.Common.DbConnection OpenConnect(string connectionStr, string providerName)
{
System.Data.Common.DbConnection Conn;
if (providerName.Contains("SQLite"))
{
Conn = new System.Data.SQLite.SQLiteConnection();
}
else
if (providerName.Contains("OracleClient"))
{
Conn = new OracleConnection();
}
else
if (providerName.Contains("MySqlClient"))
{
Conn = new MySql.Data.MySqlClient.MySqlConnection();
}
else
{
System.Data.Common.DbProviderFactory f = System.Data.Common.DbProviderFactories.GetFactory(providerName);
Conn = f.CreateConnection();
}
//得到连接字符串
Conn.ConnectionString = connectionStr;
Conn.Open();
return(Conn);
}
public IDbConnection GetConnection(string connectionString, string provider)
{
System.Data.Common.DbProviderFactory factory = System.Data.Common.DbProviderFactories.GetFactory(provider);
System.Data.Common.DbConnection conn = factory.CreateConnection();
conn.ConnectionString = connectionString;
return(conn);
}
public DalConfig(System.Data.Common.DbProviderFactory factory, string connectionString)
{
this.ProviderFactory = factory;
this.ProviderFactoryType = this.ProviderFactory.GetType();
this.ProviderName = this.ProviderFactoryType.Namespace;
this.ConnectionString = connectionString;
}
public WorkArea(string name, IDbCommand command, System.Data.Common.DbProviderFactory factory)
{
this.name = name;
this.command = command;
this.connection = this.command.Connection;
this.factory = factory;
}
public override Database GetDatabase(ConnectionStringSettings conn, System.Data.Common.DbProviderFactory factory)
{
Database db = base.GetDatabase(conn, factory);
TryEnsureSchema(db);
return(db);
}
} // End Function OdbcFunctionReplacementCallback
public System.Data.Common.DbProviderFactory GetFactory()
{
//AddFactoryClasses();
System.Data.Common.DbProviderFactory providerFactory = null;
//providerFactory = System.Data.Common.DbProviderFactories.GetFactory("MySql.Data.MySqlClient");
providerFactory = this.GetFactory(typeof(MySql.Data.MySqlClient.MySqlClientFactory));
return(providerFactory);
}
public System.Data.Common.DbProviderFactory GetFactory()
{
System.Data.Common.DbProviderFactory providerFactory = null;
// providerFactory = System.Data.Common.DbProviderFactories.GetFactory("System.Data.SqlClient");
providerFactory = this.GetFactory(typeof(System.Data.SqlClient.SqlClientFactory));
return(providerFactory);
} // End Function GetFactory
} // End Function CreateDataAdapter
public static System.Data.Common.DbDataAdapter CreateDataAdapter(this System.Data.Common.DbConnection connection, System.Data.Common.DbCommand cmd)
{
System.Data.Common.DbProviderFactory fact = GetProvider(connection);
System.Data.Common.DbDataAdapter da = fact.CreateDataAdapter();
da.SelectCommand = cmd;
return(da);
} // End Function CreateDataAdapter
/// <summary>
/// 初始化数据库连接
/// </summary>
/// <param name="schemaName">连接名称</param>
/// <param name="connStr">连接字符串</param>
public static void Open(string schemaName, string connStr)
{
factory = new System.Data.SQLite.SQLiteFactory();
Context = new DbContext(schemaName, connStr, factory);
//是否在执入后执行查询（主要针对Sqlite）
Context.IsSupportInsertAfterSelectIdentity = false;
//是否在Dispose后执行GC用于解决Dispose后无法删除的问题（主要针对Sqlite）
Context.IsSupportGCAfterDispose = true;
}
public WorkArea(string name, IDbConnection connection, System.Data.Common.DbProviderFactory factory)
{
this.name = name;
this.connection = connection;
this.factory = factory;
this.command = this.factory.CreateCommand();
this.command.CommandText = "select * from " + this.Name;
this.command.Connection = this.connection;
}
private System.Data.IDbConnection GetDbConnection()
{
ConnectionStringSettings oConnectionSettings = ConfigurationManager.ConnectionStrings[m_sConnectionString];
System.Data.Common.DbProviderFactory dbProvider = System.Data.Common.DbProviderFactories.GetFactory(oConnectionSettings.ProviderName);
System.Data.IDbConnection newConnection = dbProvider.CreateConnection();
newConnection.ConnectionString = oConnectionSettings.ConnectionString;
return(newConnection);
}
} // End Function GetConnectionString
public System.Data.Common.DbProviderFactory GetFactory()
{
//AddFactoryClasses();
System.Data.Common.DbProviderFactory providerFactory = null;
providerFactory = this.GetFactory(typeof(SQLiteFactory));
return(providerFactory);
} // End Function GetFactory
public System.Data.Common.DbProviderFactory GetFactory()
{
//AddFactoryClasses();
System.Data.Common.DbProviderFactory providerFactory = null;
//public FirebirdSql.Data.FirebirdClient.FirebirdClientFactory fbc = null;
providerFactory = this.GetFactory(typeof(FirebirdSql.Data.FirebirdClient.FirebirdClientFactory));
//providerFactory = System.Data.Common.DbProviderFactories.GetFactory("FirebirdSql.Data.FirebirdClient");
return(providerFactory);
}
public void _00_EnumerateProviders()
{
System.Data.DataTable table = System.Data.Common.DbProviderFactories.GetFactoryClasses();
foreach (System.Data.DataRow row in table.Rows)
{
TestContext.WriteLine("{0}, {1}, {2}, {3}", row[0], row[1], row[2], row[3]);
System.Data.Common.DbProviderFactory fact = System.Data.Common.DbProviderFactories.GetFactory(row);
}
}
private DbProviderFactory(ConnectionStringSettings settings)
{
if (settings != null)
{
_instance = System.Data.Common.DbProviderFactories.GetFactory(settings.ProviderName);//(settings.ProviderName);
this.settings = settings;
}
}
} // End Constructor
public ConnectionFactory(string connectionString, System.Data.Common.DbProviderFactory factory)
: this(
new DataBase() {
ConnectionString = connectionString,
Factory = factory
}
, new Des3EncryptionService()
)
{
}
/// <summary>
/// Gets a builder.
/// </summary>
/// <param name="factory">the <see cref="System.Data.Common.DbProviderFactory"/> that creating instances of a provider's implementation of the data source classes</param>
/// <param name="connectionString">the connection used to open the database</param>
/// <param name="name">the name of the provider</param>
/// <param name="dialect">the SQL dialect to apply</param>
/// <returns><see cref="LX.EasyDb.ConnectionFactoryBuilder"/></returns>
public static ConnectionFactoryBuilder NewBuilder(System.Data.Common.DbProviderFactory factory, String connectionString, String name, Dialect dialect)
{
ConnectionFactoryBuilder builder = new ConnectionFactoryBuilder();
builder._factory = factory;
builder._connectionString = connectionString;
builder._name = name;
builder._dialect = dialect;
return(builder);
}
static SqlService()
{
// s_Factory = DbProviderFactories.GetFactory<Npgsql.NpgsqlFactory>();
// s_Factory = DbProviderFactories.GetFactory(typeof(MySql.Data.MySqlClient.MySqlClientFactory));
// s_Factory = DbProviderFactories.GetFactory(typeof(System.Data.SqlClient.SqlClientFactory));
s_Factory = System.Data.SqlClient.SqlClientFactory.Instance;
s_ConnectionString = GetMsCs();
}
} // End Function GetFactory
private static System.Data.Common.DbProviderFactory GetFactory(string assemblyQualifiedName)
{
try
{
if (
"PG".Equals(assemblyQualifiedName, System.StringComparison.InvariantCultureIgnoreCase) ||
"Npgsql".Equals(assemblyQualifiedName, System.StringComparison.InvariantCultureIgnoreCase)
)
{
return(Npgsql.NpgsqlFactory.Instance);
}
if ("MySql".Equals(assemblyQualifiedName, System.StringComparison.InvariantCultureIgnoreCase) ||
"MySql.Data.MySqlClient".Equals(assemblyQualifiedName, System.StringComparison.InvariantCultureIgnoreCase)
)
{
return(MySql.Data.MySqlClient.MySqlClientFactory.Instance);
}
if ("MS".Equals(assemblyQualifiedName, System.StringComparison.InvariantCultureIgnoreCase) ||
"System.Data.SqlClient".Equals(assemblyQualifiedName, System.StringComparison.InvariantCultureIgnoreCase)
)
{
return(System.Data.SqlClient.SqlClientFactory.Instance);
}
if (!string.IsNullOrWhiteSpace(assemblyQualifiedName))
{
System.Data.Common.DbProviderFactory fac = null;
try
{
System.Type type = System.Type.GetType(assemblyQualifiedName, false, true);
fac = GetFactory(type);
}
catch (System.Exception)
{ }
if (fac != null)
{
return(fac);
}
}
}
catch (System.Exception ex)
{
System.Console.WriteLine(ex.Message);
throw;
}
return(System.Data.SqlClient.SqlClientFactory.Instance);
}
} // End Function GetConnectionString
// http://npgsql.projects.postgresql.org/docs/manual/UserManual.html
public System.Data.Common.DbProviderFactory GetFactory()
{
//AddFactoryClasses();
System.Data.Common.DbProviderFactory providerFactory = null;
providerFactory = this.GetFactory(typeof(Npgsql.NpgsqlFactory));
//providerFactory = this.GetFactory("Npgsql.NpgsqlFactory, Npgsql");
//providerFactory = Mono.Sucks.DbProviderFactories.GetFactory("Npgsql");
//providerFactory = System.Data.Common.DbProviderFactories.GetFactory("Npgsql");
return(providerFactory);
} // End Function GetFactory
//public static IConnectionObject createMSSQLConnection()
//{
// return
//}
internal static IConnectionObject createConnection(string provider, string server, string initDB, bool trusted, string username, string password, string port, string sid)
{
dbFactory = System.Data.Common.DbProviderFactories.GetFactory(providers[provider]);
if (provider.Equals("Oracle"))
{
return(OracleConn.GetInstance(server, port, sid, username, password, dbFactory));
}
if (provider.Equals("MSSQL"))
{
return(DBConn.GetInstance(server, initDB, trusted, username, password, dbFactory));
}
throw new NotImplementedException();
}
/// <summary>
/// 打开数据库连接
/// </summary>
/// <param name="connName">连接名</param>
/// <returns></returns>
public static System.Data.Common.DbConnection OpenConnect(string connName)
{
System.Data.Common.DbConnection Conn;
//得到配置文件中的连接信息
System.Configuration.ConnectionStringSettings s =
System.Configuration.ConfigurationManager.ConnectionStrings[connName];
//得到驱动类型
System.Data.Common.DbProviderFactory f = System.Data.Common.DbProviderFactories.GetFactory(s.ProviderName);
Conn = f.CreateConnection();
//得到连接字符串
Conn.ConnectionString = s.ConnectionString;
Conn.Open();
return(Conn);
} //OpenConnect(string connName)
public static void Create(System.Data.Common.DbProviderFactory factory)
{
System.Type t = typeof(TableType);
lock (s_lock)
{
if (TableInfoCache <TableType> .Instance != null)
{
return;
}
TableInfoCache <TableType> .Instance = new TableInfo();
}
}
/// <summary>
/// Creates a new instance of a DataTable.
/// </summary>
public DataTable(System.Data.Common.DbProviderFactory provider)
: this()
{
factory = provider;
this._ActiveConnection = factory.CreateConnection();
this._Ad = factory.CreateDataAdapter();
this._Cmd = _Ad.SelectCommand;
this._Cmds = factory.CreateCommandBuilder();
_Cmds.DataAdapter = _Ad;
if (_ActiveConnection.State == ConnectionState.Closed)
{
_ActiveConnection.Open();
}
}
public static void Close()
{
try
{
//factory.Dispose();
}
catch (Exception ex) { }
factory = null;
try
{
Context.Dispose();
}
catch (Exception ex) { }
Context = null;
}
public void Fill()
{
System.Data.Common.DbProviderFactory fac = this.GetFactory();
using (System.Data.Common.DbDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("cmd", "conn"))
{
// da.Update
System.Data.DataRow dr = null;
DataRow dar = null;
//da.UpdateBatchSize
// da.GetFillParameters
// da.Fill(msDT);
} // End Using da
}
/// <summary>
/// Initializes a factory with an instance of <see cref="System.Data.Common.DbProviderFactory"/>.
/// </summary>
/// <param name="factory"></param>
public ConnectionFactory(System.Data.Common.DbProviderFactory factory)
{
_factory = factory;
SqlMapper.TypeMapRegistry = _mapping;
}
/// <summary>
/// Sets the <see cref="System.Data.Common.DbProviderFactory"/>.
/// </summary>
/// <param name="provider">an instance of <see cref="System.Data.Common.DbProviderFactory"/></param>
/// <returns></returns>
public ConnectionFactoryBuilder SetDbProviderFactory(System.Data.Common.DbProviderFactory provider)
{
_factory = provider;
return this;
}
/// <summary>
/// Sets the <see cref="System.Data.Common.DbProviderFactory"/> by its name.
/// </summary>
/// <param name="provider">the name of the provider</param>
/// <returns></returns>
public ConnectionFactoryBuilder SetDbProviderFactory(String provider)
{
_factory = GetProvider(provider);
return this;
}
