Automatic synchronization of database schema with Linq to Sql model.

Michael66

Member
Joined
Sep 26, 2005
Messages
8
Programming Experience
Beginner
If you stay current with latest news in the development field, you can’t but hear about LINQ – language integrated query that is a constituent part of .Net Framework 3.5.

This technology is unique for its ability to design system code and data queries in one programming language. Queries are strongly typed; and this dramatically increases system reliability and allows developers to use IntelliSense features to write them.

Except the language integrated query itself, new version of .Net Framework includes Linq to Sql, a simple, but powerful system of object relational mapping (ORM).

In comparison with traditional ADO.NET technology, the use of Linq to Sql helps significantly simplify code, decrease errors and design time of the project.

Unfortunately, Linq to Sql doesn’t feature built-in tools to synchronize database structure and object model; this tedious job is usually entrusted to developers. In practice this results in dramatic increase of effort, and sometimes makes you refuse the use of advanced and promising technology.

In order to solve this problem, Perpetuum Software LLC releases a new version of Database Restyle, a set of components for database synchronization. Now it is possible to use Linq to Sql model as well as any other existing database schemas as initial database structure. A couple of lines of code are enough to create or update database. And the whole process from forming database object graph to executing DLL scripts is under the developer’s total control.

At the same time Database Restyle makes it possible to force in virtually any aspect of its work including:
  • Re-define procedures of creating various database entities (for example, to change some Table objects to View);
  • Add extra entities that are not covered by the object model (for example, CheckConstraint);
  • Execute additional scripts before and after database update (for example, to carry over data when model is refactored);
  • Skip some database objects when database is synchronized (for example, to update only objects of a definite schema).
It is also possible to get list of differences and scripts required to update without executing database update.

The use of Database Restyle reduces time required for database releases, eliminates errors and loss of data and will help you save your time and money.

Moreover, Database Restyle is a software component, so it is possible to integrate it directly into your application and distribute it without any additional fees. There is also no need to install additional software on the client side.

Not the least of advantages is that Database Restyle components can be integrated into both client and server application regardless of the GUI technology used – ASP.NET, Windows Forms, WPF.

More information on Database Restyle can be found on the vendor web site:
http://www.perpetuumsoft.com/Product.aspx?lang=en&pid=55&dbr=11
 
Back
Top