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}");
}
}
}
