Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Are there any benefits of using LINQ to SQL?
Message
 
 
À
23/12/2009 00:05:58
Information générale
Forum:
ASP.NET
Catégorie:
LINQ
Versions des environnements
Environment:
C# 3.0
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01440083
Message ID:
01440377
Vues:
58
>>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.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform