Shulou(Shulou.com)06/02 Report--

This article mainly explains "what are the advantages of Linq To Sql". The explanation in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian and go deep into it slowly to study and learn "what are the advantages of Linq To Sql" together!

Linq To Sql Advantages

Before Linq To Sql was introduced, we just formed sql statements into a string, and then passed them to sql server through ado.net, returning the result set. The flaw here is that if you have a problem with sql statements, you only know it at runtime. Not everyone understands databases. Linq To SQl can be used within any data-centric project. Especially in the absence of sql server experts in the project, Linq To SQl powerful features can help us quickly complete the project. Linq To SQL launch, is to let everyone free from cumbersome technical details, pay more attention to the logic of the project.Linq To Sql appearance, greatly reduced the database application development of the door kai, it is essentially for you to frame the data access layer in advance, is bound to speed up the database application development progress. Linq To Sql frees programmers to focus more on business logic and code than on databases. For beginners, Linq To Sql allows them to quickly enter the field of database application development, saving training costs.

Linq To SQl is based on ado.net and c#2.0. It automatically translates sql statements and creates the result set as an object and returns it. Here we can see that sql statements sent to Sql Server are automatically generated by Linq To Sql. For those who do not know SQL, this is undoubtedly a gospel. Second, Linq To Sql statements are checked during compilation. rather than run-time checks. That way, if something goes wrong there, it can be changed in time, rather than being discovered at runtime. Third, Linq To Sql is for object operations, more in line with today's oo voice.

Before Linq To SQl, there was Hibernate in the Java domain and NHibernate technology in the net domain to implement object/relational persistence and query services. What advantages does it have over NHibernate? ***, The mapping code is automatically generated. VS2008 provides SqlMetal and OR Designer tools to accomplish this. In NHibernate, you have to write by hand. NHibernate can only configure database information in an xml, while Linq To Sql has two ways, one is to put it in xml, we call it Externl Mapping, and the other is to exist in each property in the form of Attribute.

Thank you for reading, the above is "Linq To Sql advantages are what" the content, after the study of this article, I believe that we have a deeper understanding of what the advantages of Linq To Sql are, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.