It's a bug in the LINQ to MSI implementation. There's an easy workaround: include a WHERE clause before the SELECT. Any where clause will do, for example: where files.FileName != null
-----Original Message----- From: Christopher Painter [mailto:chr...@deploymentengineering.com] Sent: Monday, February 02, 2009 11:14 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] DTF LINQ Question I'm not sure if this is a function of my limited understanding of LINQ or an example of DTF's LINQ still being experimental but here is a problem I'm having trying to do an inner join between the component and file tables. The below code results in an ArgumentOutOfRangeException instead of bringing back a result set of components and their files ( which the database has. ) using (var database = new QDatabase( PATH_TO_DATABASE, DatabaseOpenMode.ReadOnly)) { var records = from components in database.Components join files in database.Files on components.Component equals files.Component_ select new { component = components.Component, fileName = files.FileName }; foreach( var record in records) { // do something useful with the data } } Christopher Painter, Author of Deployment Engineering Blog Have a hot tip, know a secret or read a really good thread that deserves attention? E-Mail Me ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
