On Nov 20, 2007 11:13 AM, Alan Bourke <[EMAIL PROTECTED]> wrote: > David Crooks wrote: > > you also get linq. > > > > > Linq is the biggie. Finally I can write inline select statements in > something other than VFP!
Like this? select e.firstname, e.lastname, e.email, e.id from (select firstname, lastname, email, id from Usersystem..[user] where companyid = 'FD461AF5-CFE1-4E8C-B191-26108FD4F464') e Been doing that for a long time in SQL Server 2000. I think that linq will be better in non data request type of operations. Say you have your Container of Containers, SalesOrderItems for SO#123 You can now plow through the bunch of objects/containers easier instead of iterating through them one at a time. Now you can find the Item="Widget" easier. Think of plodding through arrays for each line item in a SO. You could now do a select statement instead. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
