restore and backup db in csharp

main.cs
string connectionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
string backupPath = @"C:\Backup\MyDatabase.bak";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    string backupQuery = "BACKUP DATABASE [" + connection.Database + "] TO DISK='" + backupPath + "'";

    using (SqlCommand command = new SqlCommand(backupQuery, connection))
    {
        command.ExecuteNonQuery();
    }
}
489 chars
15 lines

main.cs
string connectionString = "Data Source=ServerName;Initial Catalog=master;User ID=UserName;Password=Password";
string backupPath = @"C:\Backup\MyDatabase.bak";

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    // Kill all processes on the target database
    string killConnectionsQuery = "USE [master]; " +
                                  "DECLARE @kill varchar(8000) = ''; " +
                                  "SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';' " +
                                  "FROM sys.dm_exec_sessions WHERE database_id = DB_ID('" + connection.Database + "') " +
                                  "EXEC(@kill);";

    using (SqlCommand command = new SqlCommand(killConnectionsQuery, connection))
    {
        command.ExecuteNonQuery();
    }

    // Restore database
    string restoreQuery = "USE [master]; " +
                          "ALTER DATABASE [" + connection.Database + "] SET SINGLE_USER WITH ROLLBACK IMMEDIATE; " +
                          "RESTORE DATABASE [" + connection.Database + "] " +
                          "FROM DISK='" + backupPath + "' " +
                          "WITH REPLACE, " +
                          "MOVE '" + connection.Database + "' TO 'C:\\Data\\" + connection.Database + ".mdf', " +
                          "MOVE '" + connection.Database + "_log' TO 'C:\\Data\\" + connection.Database + "_log.ldf'; " +
                          "ALTER DATABASE [" + connection.Database + "] SET MULTI_USER;";

    using (SqlCommand command = new SqlCommand(restoreQuery, connection))
    {
        command.ExecuteNonQuery();
    }
}
1666 chars
35 lines