Sql Server For Xml Auto
About LINQ to SQL
Since it became available to developers using. Net is not necessary to mix code with SQL commands within application to access database objects. Now developers can access data in databases by using a programming language that is used for (C #, VB.NET). Moreover, the use of LINQ to SQL allows the developer to seamlessly manage all iterative data sources: databases, XML, various collections, etc. Also you get the verification code during compilation, full integration into Visual Studio, which offers many advantages: IntelliSense, base data model design, automatic code generation with the model and so on.
Nothing is perfect
Yet despite all the advantages of using LINQ to SQL, its use in real projects, large and complicated problems. Using LINQ to SQL in the project will make use of Visual Studio components, such as LINQ to SQL classes. The component is not easy to use as they must stay in tune with the actual structure of the database.
Alternative synchronization LINQ to SQL classes and the structure of the database in manual mode is not considered because of all the content of work and enormous potential for errors. However, it is very important to follow the LINQ to SQL Classes in sync with the database structure, such as LINQ to Classes and structure of SQL databases have changed during the software design.
Redesign of the database – Library solve the problem of transfer changes LINQ to SQL classes to the database structure.
With the to solve the first problem in the previous chapter, Perpetuum Software LLC has developed PerpetuumSoft.DataModel.LinqToSql library. This library allows the propagation of changes to LINQ to SQL database structure without having to re-create the database. This library is based on another database library redesign more functional, designed to synchronize two databases. Therefore, you have the opportunity to extend the standard capabilities of LINQ to SQL technology and avoid problems synchronization with LINQ to SQL classes to the structure of the database.
The full article is available:
http://www.perpetuumsoft.com/Product.aspx?lang=en&pid=55&tid=linqtosqlsynchronization&dbrl
Band of Coders: Senior .net Architects