>>>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.
>>
>>I LOVE it! And they are making several updates to it in the .Net 4 framework, which have been documented on several blogs. This proves that they have not left it out of the next era of .Net. They were not major enhancements, but MANY stabilizing and efficiency things.
>>
>>I would strongly recommend that you consider a wrapper class by Rick Strahl that makes using L2S super easy. Here is a link to an article he wrote about itL http://www.west-wind.com/WebLog/posts/160237.aspx
>>
>>He has since made the LinqToSql Business Object Wrapper a part of his West Wind Web Toolkit for Asp.Net. http://www.west-wind.com/WestwindWebToolkit (Even though the name says "Asp.Net", the L2S classes work for any UI since they create a base DAL component).
>>
>>I have used this class library to write my first Asp.Net CRUD app, and I'm telling you it totally gave me a DAL in no time. Writing a method to pull data in is basically regular LinqToSql, but I wrote zero code the save changes back to the data base, and it has hooks for validation (if needed).
>
>Matt,
>
>Thanks a lot. I plan to finish watching the videos and then I look at the article.

How does L2S do relationships?