I empathize with your problems with LINQ. And they don't make it any easier in that VB is slightly different from C# in what you can and cannot and should and should not do.
I would suggest:
Don't waste time with Linq to SQL. It is a dead end Learn EF.
Linq to Objects and Linq to Entities can be very useful.
Pluralsight is a great source of wisdom on all this stuff.
Consider using a lot of stored procedures for data-fetching/updating tasks. TSQL can do some amazing stuff. You may find the only time you need LINQ is when it can be useful in manipulating in-memory data with Linq to Objects. I've written a lot of .NET code that doesn't use linq.
>>But the SQL examples you give can't be used against DataTables anyway.
>
>I do use it against datatables and it seems to work for me. I guess the IEnumerable is somehow implicit.
>
>> Without linq all you would have is DataTable.Select to get a subset of rows or DataTable.Compute to sum things.
>
>And you also have datable.copy().sort I have found.
>
>All in all it's about the same functionality we used to have in DAO/ADO recordset, together with move and other.
>
>>
>>Admittedly Linq to DataSet is one of the more complicated usages of Linq - but general linq usage is the same whether for this, objects, xml etc. And don't forget that a query expression can be built up over several statements for clarity.
>
>Well good to know that not everybody runs when they see a LINQ statement. As I said earlier, when I grow up I wanna be a LINQ programmer.
>
>Thanks and take care.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.