C# Класс Acme.PROJECTNAME.Install.SqlServers

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
HasLength ( System dataType ) : bool
RunEmbeddedFile ( SqlConnection connection, SqlTransaction transaction, string resourceFileName ) : void

Приватные методы

Метод Описание
BuildConnectionString ( bool integratedSecurity, string databaseName, string serverName, string userName, string password ) : string
CreateDatabase ( string connectString, string databaseName ) : void
DeleteExtendedPropery ( string connectionString, string property, string user, string table, string column ) : void
ExecuteSQL ( SqlConnection connection, SqlTransaction transaction, string sql ) : void
ExtendedPropertyExists ( string connectionString, string property, string user, string table, string column ) : bool
GetDatabaseColumnExtendedProperty ( string connectionString, string propertyName, string tableName, string columnName ) : string
GetDatabaseExtendedProperty ( string connectionString, string propertyName ) : string
GetDatabaseNames ( string connectString ) : string[]
GetDatabaseTableExtendedPropertiesLike ( string connectionString, string tableName, string likeStatement ) : string[]
GetDatabaseTableExtendedProperty ( string connectionString, string tableName, string propertyName ) : string
GetServers ( ) : string[]
GetSqlColumnsForTable ( string tableName ) : string
GetSqlForForeignKeys ( string parentTable, string childTable, string constraintName ) : string
GetSqlForRelationships ( string tableName ) : string
GetSqlForTableExtendedPropertyLikeCount ( string tableName, string likeString ) : string
GetTableColumns ( string connectString, string tableName ) : DataSet
GetTableNamesAsArrayList ( string connectString ) : ArrayList
GetTables ( string connectString ) : string[]
HasCreatePermissions ( string connectString ) : bool
InsertExtendedPropery ( string connectionString, string property, string propertyValue, string user, string table, string column ) : void
ReadSQLFileSectionsFromFile ( string fileName ) : string[]
ReadSQLFileSectionsFromResource ( string resourceFileName ) : string[]
RemoveTable ( string connectString, string tableName ) : void
SQLAllocHandle ( short hType, IntPtr inputHandle, IntPtr &outputHandle ) : short
SQLBrowseConnect ( IntPtr hconn, StringBuilder inString, short inStringLength, StringBuilder outString, short outStringLength, short &outLengthNeeded ) : short
SQLFreeHandle ( short hType, IntPtr handle ) : short
SQLSetEnvAttr ( IntPtr henv, int attribute, IntPtr valuePtr, int strLength ) : short
SelectExtendedProperty ( string connectionString, string property, string user, string table, string column ) : string
SqlRemoveTable ( string tableName ) : string
SqlServers ( ) : System
TestConnectionString ( string connectString ) : bool
UpdateDatabaseColumnExtendedProperty ( string connectionString, string tableName, string columnName, string propertyName, string propertyValue ) : void
UpdateDatabaseExtendedProperty ( string connectionString, string propertyName, string propertyValue ) : void
UpdateDatabaseTableExtendedProperty ( string connectionString, string tableName, string propertyName, string propertyValue ) : void
UpdateExtendedPropery ( string connectionString, string property, string propertyValue, string user, string table, string column ) : void

Описание методов

HasLength() публичный статический Метод

public static HasLength ( System dataType ) : bool
dataType System
Результат bool

RunEmbeddedFile() публичный статический Метод

public static RunEmbeddedFile ( SqlConnection connection, SqlTransaction transaction, string resourceFileName ) : void
connection System.Data.SqlClient.SqlConnection
transaction System.Data.SqlClient.SqlTransaction
resourceFileName string
Результат void