Cool, thanks for the tip. I'm in VS2008/Linq/WPF training all week so hopefully I'll get a better feel for this.
Btw, you inspired me.... I hope you don't think it sucks. http://www.installsite.org/pages/en/msi/tips.htm#DTF_ICE Chris 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 --- On Mon, 2/16/09, Jason Ginchereau <jason...@microsoft.com> wrote: > From: Jason Ginchereau <jason...@microsoft.com> > Subject: RE: [WiX-users] DTF LINQ Question > To: "chr...@deploymentengineering.com" <chr...@deploymentengineering.com>, > "General discussion for Windows Installer XML toolset." > <wix-users@lists.sourceforge.net> > Date: Monday, February 16, 2009, 10:04 PM > 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
