This class contains the SqlServer utility functions.
Declaration Syntax| C# | Visual Basic | Visual C++ |
public static class SqlClientUtils
Public NotInheritable Class SqlClientUtils
public ref class SqlClientUtils abstract sealed
Members| All Members | Methods | Properties | |||
| Icon | Member | Description |
|---|---|---|
  | BackupDatabase(String, String, String) |
Create backup of an Sql Server Database.
|
| BackupDatabase(String, String, String, Int32, Boolean) |
Create backup of an Sql Server Database.
|
| ChangeConnectionStringDatabase(String, String) |
Change the database name from an existing connection string.
|
| ChangeConnectionStringDatabaseToMaster(String) |
Change the database name from an existing connection string to master.
|
| CreateDatabase(String, String) |
Create a new empty SqlServer database.
|
| CreateSqlCommand(String) |
Create and return a SqlCommand with the default Connection string
|
| CreateSqlConnection()()() |
Create an Sql Server connection with the default connection string.
|
| DatabaseExists(String, String) |
Check if a database exists.
|
 | DefaultConnectionString |
Default connection string used.
|
| DefaultSqlCommandTimeout |
Default SQl command timeout used by SqlClientUtils. 30 seconds by default.
|
| DropDatabase(String, String) |
Drop an existing Sql Server database.
|
| GetDatabaseFileInformation(String, String) |
Return the Database file information (Name, FileName and FileSize).
|
| GetDataSet(SqlCommand, Boolean, String) |
Fill a dataset.
|
| GetDataSet(String, array<SqlParameter>[]()[], Boolean, String) |
Fill a dataset.
|
| GetDataSet(String, String) |
Fill a dataset.
|
| GetTableFieldNames(String, String) |
Return the field name for a specific table.
|
| GetTableNames(String) |
Return all the table names of a database.
|
| GetTableRelations(String, String) |
Return all the relations contained in a table.
|
| GetViewNames(String) |
Return all the views of a database.
|
| KillDatabaseConnections(String, String) |
Close all the connection for a database. Be carefull when using this method,
it might causes problems if an external process uses the connection.
|
| MoveDatabase(String, String, String) |
Move physically the database from a folder to an other.
|
| RestoreDatabase(String, String, String) |
Restore a backup file.
|
| RestoreDatabase(String, String, String, Int32) |
Restore a backup file.
|
Inheritance Hierarchy| Object | |
 | SqlClientUtils |
Assembly: Devolutions.Utils (Module: Devolutions.Utils)