I've done several posts in the past about LINQ and LINQ to SQL. Both VB and C# obviously have full support for LINQ and LINQ to SQL. I think the VB team in particular has done some nice
work to provide nice intellisense hints to help guide users when writing LINQ
statements in the editor.
For example, assuming we have a LINQ to SQL data model like
the one I built in Part 2 of my LINQ to SQL series, I could use the VB
code editor to easily work with it. Notice below how VB
automatically provides a tooltip that helps guide me through writing the LINQ
query syntax:
Figure 7
I can then start writing my query expression and the VB
intellisense will guide me through creating it:
Figure 8
Figure 9
Figure 10
Figure 12
The above expression retrieves three column
values from the database and creates a new anonymous type that I can then loop
over to retrieve and work on the data:
Figure 13