string query = @" 

        select 
          ED101_Id = PLP_R_Unload_RKC_ED101_CashID,
          EDNo, EDDate, EDAuthor, PaytKind, [Sum], TransKind,
          Priority, ChargeOffDate, ReceiptDate, SystemCode, Purpose
        from PLP_R_Unload_RKC_ED101_Cash

        select AccDocNo, AccDocDate, ED101_Id = ED101.PLP_R_Unload_RKC_ED101_CashID
        from PLP_R_Unload_RKC_ED101_Cash ED101
          inner join PLP_R_Unload_RKC_AccDoc_Cash AccDoc on ED101.PLP_R_Unload_RKC_ED101_CashID = AccDoc.PLP_R_Unload_RKC_ED101_CashID

        select Payer_Id = PLP_R_Unload_RKC_Payer_CashID, INN, PersonalAcc, KPP, [Name], ED101_Id = ED101.PLP_R_Unload_RKC_ED101_CashID
        from PLP_R_Unload_RKC_ED101_Cash ED101
          inner join PLP_R_Unload_RKC_Payer_Cash Payer on ED101.PLP_R_Unload_RKC_ED101_CashID = Payer.PLP_R_Unload_RKC_ED101_CashID

        select Payee_Id = PLP_R_Unload_RKC_Payee_CashID, INN, PersonalAcc, KPP, [Name], ED101_Id = ED101.PLP_R_Unload_RKC_ED101_CashID
        from PLP_R_Unload_RKC_ED101_Cash ED101
          inner join PLP_R_Unload_RKC_Payee_Cash Payee on ED101.PLP_R_Unload_RKC_ED101_CashID = Payee.PLP_R_Unload_RKC_ED101_CashID

        select BIC, CorrespAcc, Payer_Id = PLP_R_Unload_RKC_Payer_CashID, Payee_Id = null
        from PLP_R_Unload_RKC_ED101_Cash ED101
          inner join PLP_R_Unload_RKC_Bank_Payer_Cash Bank_Payer on ED101.PLP_R_Unload_RKC_ED101_CashID = Bank_Payer.PLP_R_Unload_RKC_ED101_CashID
          inner join PLP_R_Unload_RKC_Payer_Cash Payer on ED101.PLP_R_Unload_RKC_ED101_CashID = Payer.PLP_R_Unload_RKC_ED101_CashID
        union all
        select BIC, CorrespAcc, Payer_Id = null, Payee_Id = PLP_R_Unload_RKC_Payee_CashID 
        from PLP_R_Unload_RKC_ED101_Cash ED101
          inner join PLP_R_Unload_RKC_Bank_Payee_Cash Bank_Payee on ED101.PLP_R_Unload_RKC_ED101_CashID = Bank_Payee.PLP_R_Unload_RKC_ED101_CashID
          inner join PLP_R_Unload_RKC_Payee_Cash Payee on ED101.PLP_R_Unload_RKC_ED101_CashID = Payee.PLP_R_Unload_RKC_ED101_CashID

        select DrawerStatus, CBC, OKATO, PaytReason, TaxPeriod, DocNo, DocDate, TaxPaytKind, ED101_Id = ED101.PLP_R_Unload_RKC_ED101_CashID
        from PLP_R_Unload_RKC_ED101_Cash ED101
          inner join PLP_R_Unload_RKC_DepartmentalInfo_Cash DepartmentalInfo on ED101.PLP_R_Unload_RKC_ED101_CashID = DepartmentalInfo.PLP_R_Unload_RKC_ED101_CashID

";

      using (SqlConnection cn = new SqlConnection("server=(local);Database=Test;Integrated Security=SSPI;"))
      {
        SqlCommand cmd = cn.CreateCommand();
        cmd.CommandText = query;
        cmd.CommandType = CommandType.Text;

        cn.Open();

        SqlDataReader rdr = cmd.ExecuteReader();

        DataSet ds = new DataSet();

        ds.ReadXmlSchema(@"cbr_ed_v1.1.2.xsd");

        ds.Load(rdr, LoadOption.Upsert, new string[] { "ED101", "AccDoc", "Payer", "Payee", "Bank", "DepartmentalInfo" });

        ds.WriteXml(@"e:\work\qq.xml");

        ds.Dispose();

      }


    }