Backup and Restore application of table in database using C#

create Procedure Proc_name
@name nvarchar(max)
as
begin
declare @db_name as nvarchar(max);
declare @filename as nvarchar(max);
select @db_name= name from sys.databases where name =@name
set @filename='D:\'+@db_name+'.bak'
backup database @db_name to disk =@filename;
end

try
  {
     sqlConnection = new SqlConnection(dbConnectionString);
     SqlCommand command = new SqlCommand("Proc_name", sqlConnection);
     command.CommandType = CommandType.StoredProcedure;
   
     command.Parameters.Add("@Name", SqlDbType.String).Value = db_name;
     sqlConnection.Open();
     return command.ExecuteNonQuery();
     sqlConnection.Close();
  }
catch (SqlException ex)
  {
     Console.WriteLine("SQL Error" + ex.Message.ToString());
     return 0;
  }