/// <summary>
/// 获取数据库连接，返回的连接已经打开(open)；在 mvc 框架中不用关闭，框架会自动关闭连接。
/// 之所以要传入 EntityInfo，因为 ORM 支持多个数据库，不同的类型有可能映射到不同的数据库。
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public static IDbConnection getConnection(EntityInfo et)
{
String db = et.Database;
String connectionString = DbConfig.GetConnectionString(db);
IDbConnection connection;
getConnectionAll().TryGetValue(db, out connection);
if (connection == null)
{
connection = DataFactory.GetConnection(connectionString, et.DbType);
connection.Open();
setConnection(db, connection);
if (shouldTransaction())
{
IDbTransaction trans = connection.BeginTransaction();
setTransaction(db, trans);
}
return(connection);
}
if (connection.State == ConnectionState.Closed)
{
connection.ConnectionString = connectionString;
connection.Open();
}
return(connection);
}
/// <summary>
/// 获取数据库连接，返回的连接已经打开(open)；在 mvc 框架中不用关闭，框架会自动关闭连接。
/// 之所以要传入 EntityInfo，因为 ORM 支持多个数据库，不同的类型有可能映射到不同的数据库。
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public static IDbConnection getReadOnlyConnection()
{
String dbname = "readonly";
DatabaseType dbType = DatabaseType.Access;
foreach (KeyValuePair <String, Object> kv in DbConfig.Instance.DbType)
{
dbname = kv.Key;
dbType = DbTypeChecker.GetFromString(kv.Value.ToString());
if (kv.Key == "readonly")
{
break;
}
}
String connectionString = DbConfig.GetConnectionString(dbname);
IDbConnection connection;
Dictionary <String, IDbConnection> connections = getConnectionAll();
connections.TryGetValue(dbname, out connection);
if (connection == null)
{
try
{
connection = DataFactory.GetConnection(connectionString, dbType);
}
catch (Exception ex)
{
LogManager.GetLogger().Error("数据库连接字符串错误：" + connectionString);
throw ex;
}
connection.Open();
OrmHelper.initCount++;
LogManager.GetLogger("Class:System.Data.DbContext Method:getConnection").Info("数据库连接已开启【" + OrmHelper.initCount + "】");
setConnection(dbname, connection);
if (shouldTransaction())
{
IDbTransaction trans = connection.BeginTransaction();
setTransaction(dbname, trans);
}
return(connection);
}
if (connection.State == ConnectionState.Closed)
{
connection.ConnectionString = connectionString;
connection.Open();
OrmHelper.initCount++;
LogManager.GetLogger("Class:System.Data.DbContext Method:getConnection").Info("数据库连接已开启【" + OrmHelper.initCount + "】");
}
return(connection);
}
/// <summary>
/// 获取数据库连接，返回的连接已经打开(open)；在 mvc 框架中不用关闭，框架会自动关闭连接。
/// 之所以要传入 EntityInfo，因为 ORM 支持多个数据库，不同的类型有可能映射到不同的数据库。
/// </summary>
/// <param name="et"></param>
/// <returns></returns>
public static IDbConnection getConnection(EntityInfo et)
{
String db = et.Database;
String connectionString = DbConfig.GetConnectionString(db);
IDbConnection connection;
Dictionary <String, IDbConnection> connections = getConnectionAll();
connections.TryGetValue(db, out connection);
if (connection == null)
{
try
{
connection = DataFactory.GetConnection(connectionString, et.DbType);
}
catch (Exception ex)
{
LogManager.GetLogger().Error("数据库连接字符串错误：" + connectionString);
throw ex;
}
connection.Open();
OrmHelper.initCount++;
LogManager.GetLogger("Class:System.Data.DbContext Method:getConnection").Info("数据库连接已开启【" + OrmHelper.initCount + "】");
setConnection(db, connection);
if (shouldTransaction())
{
IDbTransaction trans = connection.BeginTransaction();
setTransaction(db, trans);
}
return(connection);
}
if (connection.State == ConnectionState.Closed)
{
connection.ConnectionString = connectionString;
connection.Open();
OrmHelper.initCount++;
LogManager.GetLogger("Class:System.Data.DbContext Method:getConnection").Info("数据库连接已开启【" + OrmHelper.initCount + "】");
}
return(connection);
}