>Hi everybody,
>
>I'm learning LINQ right now and in the LINQ to SQL example I see that the generated SQL is not really optimized (I would write it myself differently).
>
>I'm wondering if you can tell me if there are advantages of using LINQ to SQL and elaborate on this topic in general.
>
>I see the simplicity of quering XML data with LINQ to XML or other type of data.
>
>Thanks in advance.

As Craig says, Microsoft is pushing the EF pretty hard as the preferred technology. Part of it is political, I'm sure, with EF coming from the data group and LINQ to SQL having been written as something of a wildcat project by the C# team.

Re the example you saw, just because it wasn't good SQL is no reason to dismiss the technology. One can write bad code in any language. I know ;-)