[C# Linq2SQL]

public Boolean AddPartnerName(String AccountID, String PartnerName, String PartnerAddress, String PartnerCity, String PartnerCountryCode, String PartnerCountryName, out Int32 PartnerID)
        {
            Boolean PartnerExists = false;
            PartnerID = 0;

            Int32 No = B2BDatabase.Partners.Count();   // Preštejemo koliko zapisov je že v tabeli

            // select stavek za browsanje po tabeli Company
            var GetPartnerNames = from Names in B2BDatabase.Partners
                                  select Names;

            var CheckPartnerNames = GetPartnerNames.ToList();   // Dobljena imena iz tabele Partner zapišemo v List

            // Preverjamo samo prvi zapis v tabeli, če obstaja na podlagi iskalnega pogoja. Če obstaja: RecordExists = true!
            for (Int32 i = 0; i < No; i++)
            {
                if (CheckPartnerNames.ElementAt(i).PartnerData_Name.ToString().StartsWith(PartnerName.TrimEnd()) == true)  // Preverjamo če že obstaja partner s to številko bančnega računa
                {
                    Console.WriteLine("Partner že obstaja!");
                    Console.WriteLine("Zapis je na mestu: {0}\n\n", i + 1);
                    PartnerID = i + 1;
                    PartnerExists = true;
                    break;
                }
            }

            // Če zapis tabeli ne obstaja ga dodamo
            if (PartnerExists == false)
            {
                Console.WriteLine("Partner ne obstaja in ga bom dodal!\n\n");
                NewPartner.PartnerID = No + 1;
                PartnerID = No + 1;
                NewPartner.PartnerData_AccountID = AccountID;
                NewPartner.PartnerData_Name = PartnerName;
                NewPartner.PartnerData_Adress = PartnerAddress;
                NewPartner.PartnerData_City = PartnerCity;
                NewPartner.PartnerData_CountryCode = PartnerCountryCode;
                NewPartner.PartnerData_CountryName = PartnerCountryName;

                try
                {
                    B2BDatabase.Partners.InsertOnSubmit(NewPartner);   // Izvede se transaction zapisa
                    B2BDatabase.SubmitChanges();
                    
                }
                catch (System.Exception ex)
                {
                    ex.ToString();
                }
            }

            return PartnerExists;
        }

            for (Int32 i = 0; i < AccountStatementTransactionNo; i++)
            {
                foreach(www.halcom.si.AccountStatement.xsd.AccStatement.TransactionLocalType.PartnerDataLocalType tr in XMLAccountStatement.Transaction.ElementAt(i).PartnerData)
                {
                    MyPartnerDataVar.ResetPartnerDataVariables();

                    try
                    {
                        MyPartnerDataVar.PartnerDataAccount = tr.Account.ToString();
                    }
                    catch (System.Exception ex)
                    {
                        MyPartnerDataVar.PartnerDataAccount = "";
                    }

                    try
                    {
                        MyPartnerDataVar.PartnerDataName = tr.Name.ToString();
                    }
                    catch (System.Exception ex)
                    {
                        MyPartnerDataVar.PartnerDataName= "Ime" + i.ToString();
                    }

                    try
                    {
                        MyPartnerDataVar.PartnerDataAddress = tr.Address.ToString();
                    }
                    catch (System.Exception ex)
                    {
                        MyPartnerDataVar.PartnerDataAddress = "";
                    }

                    try
                    {
                        MyPartnerDataVar.PartnerDataCity = tr.City.ToString();
                    }
                    catch (System.Exception ex)
                    {
                        MyPartnerDataVar.PartnerDataCity = "";
                    }

                    try
                    {
                        MyPartnerDataVar.PartnerDataCountryCode = tr.CountryCode.ToString();
                    }
                    catch (System.Exception ex)
                    {
                        MyPartnerDataVar.PartnerDataCountryCode = "NoDat";
                    }

                    try
                    {
                        MyPartnerDataVar.PartnerDataCountryName = tr.CountryName.ToString();
                    }
                    catch (System.Exception ex)
                    {
                        MyPartnerDataVar.PartnerDataCountryName = "";
                    }

                    Boolean AddedNewPartner = myNewCompanyRecord.AddPartnerName(MyPartnerDataVar.PartnerDataAccount.TrimEnd(),MyPartnerDataVar.PartnerDataName, MyPartnerDataVar.PartnerDataAddress, MyPartnerDataVar.PartnerDataCity, MyPartnerDataVar.PartnerDataCountryCode, MyPartnerDataVar.PartnerDataCountryName, out PartnerID);
                }
            }