73 lines
2.0 KiB
C#
73 lines
2.0 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.Collections.Specialized;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using System.Text;
|
||
using System.Threading.Tasks;
|
||
|
||
namespace MJTop.Data.SPI
|
||
{
|
||
public interface IDBInfo
|
||
{
|
||
Tool Tools { get; }
|
||
|
||
string DBName { get; }
|
||
|
||
string Version { get; }
|
||
|
||
double VersionNumber { get; }
|
||
|
||
/// <summary>
|
||
/// 注意：刷新数据失败的情况，根据返回值做对应处理。
|
||
/// </summary>
|
||
/// <returns></returns>
|
||
bool Refresh();
|
||
|
||
List<string> TableNames { get; }
|
||
|
||
NameValueCollection TableComments { get; }
|
||
|
||
IgCaseDictionary<TableInfo> TableInfoDict { get; }
|
||
|
||
IgCaseDictionary<List<string>> TableColumnNameDict { get; }
|
||
|
||
IgCaseDictionary<List<ColumnInfo>> TableColumnInfoDict { get; }
|
||
|
||
IgCaseDictionary<NameValueCollection> TableColumnComments { get; }
|
||
|
||
NameValueCollection Views { get; }
|
||
|
||
NameValueCollection Procs { get; }
|
||
|
||
[Obsolete("注意：Oralce暂不支持查询所有数据库名称。", false)]
|
||
List<string> DBNames { get; }
|
||
|
||
List<string> this[string tableName] { get; }
|
||
|
||
ColumnInfo this[string tableName, string columnName] { get; }
|
||
|
||
bool IsExistTable(string tableName);
|
||
|
||
bool IsExistColumn(string tableName, string columnName);
|
||
|
||
string GetColumnComment(string tableName, string columnName);
|
||
|
||
string GetTableComment(string tableName);
|
||
|
||
List<ColumnInfo> GetColumns(string tableName);
|
||
|
||
bool SetTableComment(string tableName, string comment);
|
||
|
||
bool SetColumnComment(string tableName, string columnName, string comment);
|
||
|
||
bool DropTable(string tableName);
|
||
|
||
bool DropColumn(string tableName, string columnName);
|
||
|
||
[Obsolete("注意：MySql的所有表存储引擎必须为MyISAM 方才查询支持，方才查询准确。", false)]
|
||
Dictionary<string, DateTime> GetTableStruct_Modify();
|
||
|
||
}
|
||
}
|