Mapping relational data to object model has always been one of the most difficult problems in the construction of object-oriented systems. In most cases, database queries written in sql, and their result converted into objects. The developer has to work simultaneously with two different representations of data, which significantly increases the effort required to create and maintain a software product and increases likelihood of errors. The uniqueness of linq technology is the ability to write and code systems and data queries in one language. Requests at the same time become strongly-typed, which greatly increases system reliability and makes full use IntelliSense features in their writing. In addition to directly integrated query language, the new version.
Net Framework includes linq to sql - simple but powerful system of object-relational mapping (ORM). In comparison with traditional ado.net technology to use linq to sql can greatly simplify the code, reduce errors and shorten the project development. The largest gain in this will be Web developers applications for which, in the new version of asp.net has a special data source that allows queries directly in the Web page. Unfortunately, linq to sql has no built-in synchronization of database structure with object model - this time-consuming task rests with the developer. In practice, this leads to a significant increase in labor costs, and sometimes makes even renounce the use of advanced technology.
llc released a new version of the software component Database Restyle, which will help solve this problem. The product is designed to synchronize database structures. The new version, along with the schemes of the existing database object model linq to sql can be used as the initial structure of the database. You do not need to write complex code, as for the construction or upgrade of the database structure quite a few lines. Just imagine how increase productivity of programmers. The entire process, from forming database object graph to executing ddl scripts is under the complete control of the developer. Database Restyle allows need to intervene in virtually every aspect of their work, including: - override the procedure for creating various database entities - to add additional entities not covered by the object model - execute additional scripts before and after the upgrade - ignore part of the database objects in sync. It is also possible to obtain a list of differences and scripts needed to update without updating. In other words, working with the object model linq to sql is no different from working with any other database structures. According to technical director of the company Perpetuum Software: 'Automatic Updates feature of the database structure absolutely necessary if the objects are the main entities of business applications. " It is also important that the components of Database Restyle, can be integrated as a client and a server-based applications, regardless of the gui technology - asp.net, Windows Forms, wpf and distributed in their structure without any additional fees. Full source code. Details can be found by clicking Mark Berger Chicago or emailing the administrator. Use Database Restyle automates the creation and synchronization of database structures, thereby helping save time and money required for the release of new versions of databases and their deployment.