/// <summary> /// 按数据类型获取数据库访问实现类 /// </summary> /// <param name="dbType">数据库类型</param> /// <returns>数据库访问实现类</returns> public static string GetDbHelperClass(DbTypeName dbType) { string returnValue = "DotNet.Utilities.SqlHelper"; switch (dbType) { case DbTypeName.SqlServer: returnValue = "DotNet.Utilities.SqlHelper"; break; case DbTypeName.Oracle: returnValue = "DotNet.Utilities.MSOracleHelper"; break; case DbTypeName.Access: returnValue = "DotNet.Utilities.OleDbHelper"; break; case DbTypeName.MySql: returnValue = "DotNet.Utilities.MySqlHelper"; break; case DbTypeName.DB2: returnValue = "DotNet.Utilities.DB2Helper"; break; case DbTypeName.SQLite: returnValue = "DotNet.Utilities.SqLiteHelper"; break; } return(returnValue); }
static DataParameter() { foreach (string DbTypeName in System.Enum.GetNames(typeof(System.Data.DbType))) { DbTypeCollection.Add(DbTypeName.ToLower(), System.Enum.Parse(typeof(System.Data.DbType), DbTypeName)); } }
public static IATranslator CreateInstance(DbTypeName dbType, IASTNodeFactory nodeFactory) { if (dbType == DbTypeName.Oracle) { return(new OracleTranslator(nodeFactory)); } return(new SqlServerTranslator(nodeFactory)); }
/// <summary> /// 数据库连接的类型判断 /// </summary> /// <param name="dbType">数据库类型</param> /// <returns>数据库类型</returns> public static DbTypeName GetDbType(string dbType) { DbTypeName returnValue = DbTypeName.SqlServer; foreach (DbTypeName currentDbType in Enum.GetValues(typeof(DbTypeName))) { if (currentDbType.ToString().Equals(dbType)) { returnValue = currentDbType; break; } } return(returnValue); }
/// <summary> /// 获取指定的数据库连接 /// </summary> /// <param name="dataBaseType">数据库类型(默认:SqlServer)</param> /// <param name="connectionString">数据库连接串(默认:CenterDbConnection)</param> /// <returns>数据库访问类</returns> public static IDbHelper GetHelper(string connectionString, DbTypeName dbType = DbTypeName.SqlServer) { // 这里是每次都获取新的数据库连接,否则会有并发访问的问题存在 string dbHelperClass = GetDbHelperClass(dbType); Assembly assembly = Assembly.Load("JSNet.DbUtilities");//JSNet.DbUtilities.SqlHelper IDbHelper dbHelper = (IDbHelper)assembly.CreateInstance(dbHelperClass, true); if (!string.IsNullOrEmpty(connectionString)) { dbHelper.ConnectionString = connectionString; } else { throw new Exception("connectionString is null"); } return(dbHelper); }
public static IViewDefinition CreateInstance(DbTypeName dbType, string viewName, string selectStatement) { return(new ViewDefinition(dbType, viewName, selectStatement)); }
public static IViewDefinition CreateInstance(DbTypeName dbType) { return(CreateInstance(dbType, "", "")); }
public ViewDefinition(DbTypeName dbType) : this(dbType, "", "") { }
public ViewDefinition(DbTypeName dbType, string viewName, string selectStatement) { DbType = dbType; ViewName = viewName; SelectStatement = selectStatement; }
/// <summary> /// 获取指定的数据库连接 /// </summary> /// <param name="connectionString">数据库连接串</param> /// <returns>数据库访问类</returns> public static IDbHelper GetHelper(string connectionString) { DbTypeName dbType = DbTypeName.SqlServer; return(GetHelper(connectionString, dbType)); }