How to export database and import it locally by C# code?

I use a stored procedure i created, but first you need to create a linked server:

IF EXISTS(SELECT name FROM sys.servers WHERE name = 'SERVER')
            BEGIN-- 
                EXEC sp_dropserver 'SERVER', 'droplogins'
            END

/****** Object:  LinkedServer [SERVER]  create  LinkedServer ******/
            EXEC master.dbo.sp_addlinkedserver 
            @server = N'SERVER', 
            @srvproduct=N'SQLNCLI', 
            @provider=N'SQLNCLI', 
            @datasrc=N'192.168.1.1' -- IP address of a server   

             /* Add login data*/
            EXEC sp_addlinkedsrvlogin
            @useself='FALSE',
            @rmtsrvname='SERVER',
            @rmtuser='User',
            @rmtpassword='Pass'

Then you can create stored procedure on local server or execute the query directly from application, also for safety I am using a transaction in this example:

USE [DB]
GO
/****** Object:  StoredProcedure [dbo].[backupdatabase] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[backupdatabase]  
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
    BEGIN TRY
        BEGIN TRANSACTION           
            TRUNCATE TABLE [dbo].[table_1]
            INSERT INTO [dbo].[table_1]
            SELECT * FROM [SERVER].[DB].[dbo].[table_1] 


            TRUNCATE TABLE [dbo].[table_2]
            INSERT INTO [dbo].[table_2]
            SELECT * FROM [SERVER].[DB].[dbo].[table_2] 


            TRUNCATE TABLE [dbo].[table_3]
            INSERT INTO [dbo].[table_3]
            SELECT * FROM [SERVER].[DB].[dbo].[table_3]             
        COMMIT      
    END TRY
    BEGIN CATCH
        IF @@TRANCOUNT > 0
        BEGIN
            ROLLBACK TRANSACTION
            DECLARE @ErrMsg nvarchar(4000), @ErrSeverity int
            SELECT @ErrMsg = ERROR_MESSAGE(),
            @ErrSeverity = ERROR_SEVERITY()
            RAISERROR(@ErrMsg, @ErrSeverity, 1)
        END         
    END CATCH
END