.NET (Core and Framework)

[Serializable]
public class SomeClass
{
    private SomeHandler<int> m_receiver;

    public SomeClass()
    {
        m_receiver = Enter<int>;
    }

    protected virtual void Enter()
    { }

    protected virtual void Enter<T>(T data)
    { }
}

public delegate void SomeHandler<T>(T data);

class Program
{
    static void Main(string[] args)
    {
        SomeClass x1 = new SomeClass();
        BinaryFormatter formatter = new BinaryFormatter();
        using (MemoryStream ms = new MemoryStream()) {
            formatter.Serialize(ms, x1);
            ms.Seek(0, SeekOrigin.Begin);
            SomeClass x2 = (SomeClass)formatter.Deserialize(ms);
        }
    }
}

isql -Q"IF EXISTS(SELECT 1 from %db_name_src%.dbo.DB_STATUS WHERE UPPER(Status) <> 'AVAILABLE' OR CONVERT(char(10),Data_as_of,101) <> CONVERT(char(10),getdate(),101)) BEGIN RAISERROR('An error has occured',16, 1) END" -b -c -S%srv_name_src% -U%login_src% -P%password_src% 

if %errorlevel% EQU 1 GOTO :data_unavailable


rem ********* starting the bulk copy for export**********************************************************************************************************************************

rem ********* Accounts table data**********************************************************************************************************************************
bcp "SELECT account_id,Accountant_Cd from %db_name_src%.dbo.ACCOUNT WHERE Control_ID NOT IN ('0412','0361','0410','0364','0441','0442','0394','0395','0396','0444','0373','0416','0392') AND Account_Status_Cd ='0'" queryout %file_path%ACCOUNT.dat -c -S%srv_name_src% -U%login_src% -P%password_src% >%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT  || goto error_handler

rem ********* Asset table data*************************************************************************************************************************************
bcp "SELECT Property_Num,CUSIP_ID,Ticker_Symbol_ID,Asset_Short_Nm,Current_Prc FROM %db_name_src%.dbo.ASSET WHERE Unique_Asset_Fl ='0'" queryout %file_path%ASSET.dat -c -S%srv_name_src% -U%login_src% -P%password_src% >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler

rem ********* Accountbalance table data**********************************************************************************************************************************
bcp "SELECT ACCOUNT_BALANCE.Account_ID,Fiscal_Year_Fed_ST_Gain_Amt,Fiscal_Year_Fed_ST_Loss_Amt,Fiscal_Year_Fed_LT_Gain_Amt,Fiscal_Year_Fed_LT_Loss_Amt FROM %db_name_src%.dbo.ACCOUNT_BALANCE as ACCOUNT_BALANCE , %db_name_src%.dbo.ACCOUNT as ACCOUNT WHERE ACCOUNT_BALANCE.Account_ID = ACCOUNT.Account_ID AND Control_ID NOT IN ('0412','0361','0410','0364','0441','0442','0394','0395','0396','0444','0373','0416','0392') AND Account_Status_Cd ='0'" queryout %file_path%ACCOUNT_BALANCE.dat -c -S%srv_name_src% -U%login_src% -P%password_src% >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler

rem ********* ACCOUNTANT table data**********************************************************************************************************************************
bcp "SELECT distinct ACCOUNTANT.Accountant_Cd,Accountant_nm FROM  %db_name_src%.dbo.ACCOUNTANT as ACCOUNTANT, %db_name_src%.dbo.ACCOUNT as ACCOUNT WHERE ACCOUNTANT.Accountant_Cd = ACCOUNT.Accountant_Cd AND Control_ID NOT IN ('0412','0361','0410','0364','0441','0442','0394','0395','0396','0444','0373','0416','0392') AND Account_Status_Cd ='0'" queryout %file_path%ACCOUNTANT.dat -c -S%srv_name_src% -U%login_src% -P%password_src% >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler

rem ********* TaxLot Details table data**********************************************************************************************************************************
bcp "SELECT ACCOUNT.Account_ID,Property_Num,Portfolio_Num,Shares_Par_Value_Qty,Federal_Tax_Acquisition_Dt,Federal_Tax_cost_Amt, 0 as Unique_Asset_fl FROM %db_name_src%.dbo.TAX_DETAIL as TAX_DETAIL,%db_name_src%.dbo.ACCOUNT as ACCOUNT WHERE Unique_Asset_fl = 0 AND TAX_DETAIL.Account_ID = ACCOUNT.Account_ID AND Control_ID NOT IN ('0412','0361','0410','0364','0441','0442','0394','0395','0396','0444','0373','0416','0392') AND Account_Status_Cd ='0'" queryout %file_path%TAX_DETAIL.dat -c -S%srv_name_src% -U%login_src% -P%password_src% >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler

rem ********* DB_STATUS table data**********************************************************************************************************************************
bcp "SELECT Last_Update,Status_Code,Application,Status,Data_As_Of FROM %db_name_src%.dbo.DB_STATUS" queryout %file_path%DB_STATUS.dat -c -S%srv_name_src% -U%login_src% -P%password_src% >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler

rem ********* starting the bulk copy for Import**********************************************************************************************************************************

rem ********* Update DB_STATUS table data**********************************************************************************************************************************

isql -U%login_dest% -d%db_name_dest% -Q"UPDATE DB_STATUS SET Application = 'BB', Status = 'UnAvailable', Status_Code = 0, Last_Update = GETDATE()" -S%srv_name_dest% -U%login_dest%  -P%password_dest% >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler


rem ********* Accounts table data**********************************************************************************************************************************

isql -U%login_dest% -d%db_name_dest% -Q"truncate table ACCOUNT" -S%srv_name_dest% -P%password_dest%

bcp %db_name_dest%.dbo.ACCOUNT in %file_path%\ACCOUNT.dat -c -S%srv_name_dest% -U%login_dest%  -P%password_dest% -b10000 >>%file_path%\PMMIR_Fetch_ODR_data_Tax_Detail_log.log -e %file_path%\Error.TXT || goto error_handler