protected override string GetTableName(EntityInfo entityInfo) { var table = this.Context.EntityMaintenance.GetTableName(entityInfo.EntityName); var tableArray = table.Split('.'); var noFormat = table.Split(']').Length == 1; if (tableArray.Length > 1 && noFormat) { var dbMain = new SqlServerDbMaintenance() { Context = this.Context }; var schmes = dbMain.GetSchemas(); if (!schmes.Any(it => it.EqualCase(tableArray.First()))) { return(tableArray.Last()); } else { return(dbMain.SqlBuilder.GetTranslationTableName(table)); } } else { return(table); } }
public void Test_GetViewInfoList() { IDbMaintenance maintenance = new SqlServerDbMaintenance(); var result = maintenance.GetViewInfoList(); foreach (var info in result) { Console.WriteLine($"表名:{info.Name},备注:{info.Description}"); } }
/// <summary> /// 初始化数据库字典 /// </summary> private void InitDbDic() { if (DbMaintenance == null) { DbMaintenance = new SqlServerDbMaintenance(); } var tableInfos = DbMaintenance.GetTableInfoList(); foreach (var item in tableInfos) { var columns = DbMaintenance.GetColumnInfosByTableName(item.Name); DbDic.Add(item.Name, new Tuple <DbTableInfo, List <DbColumnInfo> >(item, columns)); } }
public void Test_GetColumnInfosByTableName_SqlServer() { IDbMaintenance maintenance = new SqlServerDbMaintenance(); var result = maintenance.GetTableInfoList(); foreach (var info in result) { Console.WriteLine($"表名:{info.Name},备注:{info.Description}"); var columns = maintenance.GetColumnInfosByTableName(info.Name); foreach (var column in columns) { Console.WriteLine($" 列名:{column.DbColumnName},数据类型:{column.DataType},长度:{column.Length},默认值:{column.DefaultValue},主键:{column.IsPrimaryKey},可空:{column.IsNullable},备注:{column.ColumnDescription}"); } } }