Method |
Description |
|
Compare ( Database db ) : DatabaseDiff |
|
|
CreateFromDir ( bool overwrite, string databaseFilesPath = null, string>.Action log = null ) : void |
|
|
Database ( IList filteredTypes = null ) : System |
|
|
Database ( string name, IList filteredTypes = null ) : System |
|
|
ExecCreate ( bool dropIfExists ) : void |
|
|
ExportData ( string tableHint = null, string>.Action log = null ) : void |
|
|
FindAssembly ( string name ) : SqlAssembly |
|
|
FindConstraint ( string name ) : Constraint |
|
|
FindForeignKey ( string name, string owner ) : ForeignKey |
|
|
FindProp ( string name ) : DbProp |
|
|
FindRoutine ( string name, string schema ) : Routine |
|
|
FindSynonym ( string name, string schema ) : Synonym |
|
|
FindTable ( string name, string owner, bool isTableType = false ) : Table |
|
|
FindTablesRegEx ( string pattern ) : List
Private Methods
Method |
Description |
|
FindTableBase ( IEnumerabletables, stringname, stringowner ) : Table
|
|
GetScripts ( ) : List |
|
|
LoadCLRAssemblies ( SqlCommand cm ) : void |
|
|
LoadCheckConstraints ( SqlCommand cm ) : void |
|
|
LoadColumnComputes ( SqlCommand cm ) : void |
|
|
LoadColumnDefaults ( SqlCommand cm ) : void |
|
|
LoadColumnIdentities ( SqlCommand cm ) : void |
|
|
LoadColumns ( SqlCommand cm ) : void |
|
|
LoadColumnsBase ( IDataReader dr, Listtables ) : void
|
|
LoadConstraintsAndIndexes ( SqlCommand cm ) : void |
|
|
LoadForeignKeys ( SqlCommand cm ) : void |
|
|
LoadProps ( SqlCommand cm ) : void |
|
|
LoadRoles ( SqlCommand cm ) : void |
|
|
LoadRoutines ( SqlCommand cm ) : void |
|
|
LoadSchemas ( SqlCommand cm ) : void |
|
|
LoadSynonyms ( SqlCommand cm ) : void |
|
|
LoadTables ( SqlCommand cm ) : void |
|
|
LoadTablesBase ( System.Data.SqlClient.SqlDataReader dr, bool areTableTypes, Listtables ) : void
Method Details
public Compare ( Database db ) : DatabaseDiff |
db |
Database |
|
return |
DatabaseDiff |
|
CreateFromDir()
public method
public CreateFromDir ( bool overwrite, string databaseFilesPath = null, string>.Action log = null ) : void |
overwrite |
bool |
|
databaseFilesPath |
string |
|
log |
string>.Action
| |
return |
void |
|
public Database ( IList filteredTypes = null ) : System |
filteredTypes |
IList |
|
return |
System |
|
public Database ( string name, IList filteredTypes = null ) : System |
name |
string |
|
filteredTypes |
IList |
|
return |
System |
|
ExecCreate()
public method
public ExecCreate ( bool dropIfExists ) : void |
dropIfExists |
bool |
|
return |
void |
|
ExportData()
public method
public ExportData ( string tableHint = null, string>.Action log = null ) : void |
tableHint |
string |
|
log |
string>.Action
| |
return |
void |
|
FindAssembly()
public method
public FindAssembly ( string name ) : SqlAssembly |
name |
string |
|
return |
SqlAssembly |
|
FindConstraint()
public method
public FindConstraint ( string name ) : Constraint |
name |
string |
|
return |
Constraint |
|
FindForeignKey()
public method
public FindForeignKey ( string name, string owner ) : ForeignKey |
name |
string |
|
owner |
string |
|
return |
ForeignKey |
|
public FindProp ( string name ) : DbProp |
name |
string |
|
return |
DbProp |
|
FindRoutine()
public method
public FindRoutine ( string name, string schema ) : Routine |
name |
string |
|
schema |
string |
|
return |
Routine |
|
FindSynonym()
public method
public FindSynonym ( string name, string schema ) : Synonym |
name |
string |
|
schema |
string |
|
return |
Synonym |
|
FindTable()
public method
public FindTable ( string name, string owner, bool isTableType = false ) : Table |
name |
string |
|
owner |
string |
|
isTableType |
bool |
|
return |
Table |
|
FindTablesRegEx()
public method
public FindTablesRegEx ( string pattern ) : List
pattern |
string |
|
return |
List
public FindUser ( string name ) : SqlUser |
name |
string |
|
return |
SqlUser |
|
FindViewIndex()
public method
public FindViewIndex ( string name ) : Constraint |
name |
string |
|
return |
Constraint |
|
ImportData()
public method
public ImportData ( string>.Action log = null ) : void |
log |
string>.Action
| |
return |
void |
|
public Load ( ) : void |
return |
void |
|
ScriptCreate()
public method
ScriptPropList()
public static method
public static ScriptPropList ( IList props ) : string |
props |
IList |
|
return |
string |
|
ScriptToDir()
public method
public ScriptToDir ( string tableHint = null, string>.Action log = null ) : void |
tableHint |
string |
|
log |
string>.Action
| |
return |
void |
|
Property Details
Assemblies public property
public List Assemblies |
return |
List |
|
Connection public property
public string Connection |
return |
string |
|
DataTables public property
public ListDataTables
return |
List
public string Dir |
return |
string |
|
ForeignKeys public property
public List ForeignKeys |
return |
List |
|
public string Name |
return |
string |
|
public List Props |
return |
List |
|
public List Roles |
return |
List |
|
public List Routines |
return |
List |
|
public List Schemas |
return |
List |
|
public List Synonyms |
return |
List |
|
TableTypes public property
public ListTableTypes
return |
List
public ListTables
return |
List
UserDefinedTypes public property
public List UserDefinedTypes |
return |
List |
|
public List Users |
return |
List |
|
ViewIndexes public property
public List ViewIndexes |
return |
List |
|
| | | | | | | | | | | |