Helper class to performe task on a SQL server.

Namespace:  TestFu.Data.SqlClient
Assembly:  TestFu (in TestFu.dll) Version: 2.4.2.1515 (2.4.2.1515)

Syntax

C#
public class SqlAdministrator : DbAdministratorBase
Visual Basic (Declaration)
Public Class SqlAdministrator _
	Inherits DbAdministratorBase

Examples

This example shows some usage of the DbAdministratorBase class. This class can be used to easily backup, restore, create or drop databases on a server. SqlAdministrator is the implementation for the MSSQL server:

CopyC#
[C#]
using System;
using TestFu.Data;

public class Demo
{
    public static void Main(string[] args)
    {
        DbAdministrator admin = new SqlAdministrator("...");    

        // backup Northwind
        admin.Backup("Northwind",SqlBackupDevice.Disk,@"c:\Backups\Northwind.bkp");

        // drop Northwind
        admin.Drop("Northwind");

        // restore Northwind
        admin.Restore("Northwind",SqlBackupDevice.Disk,@"c:\Backups\Northwind.bkp");
    }
}

Inheritance Hierarchy

System..::.Object
  TestFu.Data..::.DbAdministratorBase
    TestFu.Data.SqlClient..::.SqlAdministrator

See Also