Skip to content
sunkaixuan edited this page May 4, 2019 · 9 revisions

Description

Some special operations on databases

1.Example
var tables = db.DbMaintenance.GetTableInfoList();
foreach (var table in tables)
{
     Console.WriteLine(table.Description);
}

2. APi

name description return type
GetViewInfoList Get all tables in the database List
GetTableInfoList Get all views in the database List
GetColumnInfosByTableName Get columnInfos By tableName---- List
GetIsIdentities Get identity columns List
GetPrimaries Get Primary key columns List
IsAnyTable Is any table bool
IsAnyColumn Is any column bool
IsPrimaryKey Is primary key bool
IsIdentity Is identity bool
IsAnyConstraint Is any constraint bool
DropTable Drop table bool
TruncateTable Truncate table bool
CreateTable Create table bool
AddColumn Add column bool
UpdateColumn Update column bool
Clone this wiki locally