On 25 Sep, 12:06, hrishy <[EMAIL PROTECTED]> wrote: > [code] > var stoogeGuys = > Beginning with the XML source > from xmlGuys in xmlSource.Descendants("Stooge") > Join to the array on the common element "stoogeName" > join arrayGuys in familyFacts > on xmlGuys.Element("stoogeName").Value equals arrayGuys.stoogeName > Join to the database on the common element "stoogeName" > join dbGuys in stoogeContext.stoogeTables > on xmlGuys.Element("stoogeName").Value equals dbGuys.stoogeName > select new > { > firstName = dbGuys.stoogeName, > familyName = arrayGuys.familyName, > birthDate = xmlGuys.Element("birthDate").Value, > deathDate = xmlGuys.Element("deathDate").Value, > hairCutStyle = dbGuys.stoogeHaircut, > }; > [/code]
It could e.g. look like this in Python: stoogeGuys = [] for xmlGuys in xmlSource.Descendants["Stooge"]: arrayGuys = familyFacts[xmlGuys.stoogeName] dbGuys = stoogeContext.stoogeTables[xmlGuys.stoogeName] stoogeGuys += \ [{'firstName': dbGuys.stoogeName, 'familyName': arrayGuys.familyName, 'birthDate': xmlGuys.birthDate, 'deathDate': dbGuys.deathDate, 'hairCutStyle': dbGuys.stoogeHaircut}] -- http://mail.python.org/mailman/listinfo/python-list