/// <summary>
/// 创建数据库连接
/// </summary>
/// <returns></returns>
public static IDbConnection CreateConnection()
{
IDbConnection conn = DBTypeExtenstions.CreateConnectionByDBType();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
return(conn);
}
/// <summary>
/// 设置数据库类型相关的变量
/// </summary>
/// <param name="type">数据库类型</param>
private static void InitializeDBType(DBTypeEnum type)
{
DBTypeExtenstions.SetDBType(type);
//update sql dialect in dapper extension
if (type == DBTypeEnum.ORACLE)
{
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.OracleSqlDialect();
}
else if (type == DBTypeEnum.MYSQL)
{
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.MySqlDialect();
}
else if (type == DBTypeEnum.KINGBASE)
{
DapperExtensions.DapperExtensions.SqlDialect = new DapperExtensions.Sql.KingbaseSqlDialect();
}
}
