It changes some things on purpose. For example,
SELECT FROM table/object fields. Notice that it revserses things. We're used to having fields first, then tables. The VB team tried to do it like we're used to, but it caused some real problems for Intelisense, so they switched it to the other form, which BTW, is the way the C# team implemented it all along.
>I'd love to be able to do just that, and that was what I hoped to see in LINQ.
>
>SQL kind of like ..
>
>Select field1, field2, field3 from ds.tables['mytable'] into tableds.tables['thistable'].
>
>LINQ doesn't work the way T-SQL does. It does seem to start with SELECT. the similarity ends quickly after that.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer