/// <summary> /// 检测表是否存在 /// </summary> /// <param name="tableName">表名</param> /// <param name="conn">数据库链接</param> /// <param name="dalType">数据库类型</param> public static bool ExistsTable(string tableName, string conn, out DalType dalType, out string database) { dalType = DalType.None; database = string.Empty; if (string.IsNullOrEmpty(tableName) || tableName.Contains("(") && tableName.Contains(")")) { return(false); } using (DalBase helper = DalCreate.CreateDal(conn)) { dalType = helper.DataBaseType; database = helper.DataBase; } return(TableSchema.Exists(tableName, "U", conn)); }
/// <summary> /// 检测表是否存在 /// </summary> /// <param name="tableName">表名</param> /// <param name="conn">数据库链接</param> /// <param name="dalType">数据库类型</param> public static bool ExistsTable(string tableName, string conn, out DalType dalType, out string database) { dalType = DalType.None; database = string.Empty; if (string.IsNullOrEmpty(tableName) || tableName.Contains("(") && tableName.Contains(")")) { return(false); } DbBase helper = DalCreate.CreateDal(conn); dalType = helper.dalType; database = helper.DataBase; bool result = TableSchema.Exists("U", tableName, ref helper); helper.Dispose(); return(result); }