|
Automatic synchronization of database structure with LINQ to SQL model.
At last, event that was awaited for a long time by the whole developers community and that is expected to make developers work much easier happened final release of .Net Framework 3.5 featuring LINQ technology is published. This very technology, as Microsoft specialists designed it, should dramatically optimize programming in general.
Mapping of relational data into object model has always been one of the most complicated problems developers face with when they design object-oriented systems. In most cases data queries are written in SQL, and their result is converted into objects. Developers have to work with absolutely different data representations. This increases effort required for the creation and support of such software application and makes appearance of errors more possible.
LINQ technology is unique for the ability to write system code and data queries using single programming language. Queries become strongly typed and as a result system reliability is increased and IntelliSense features can be used to the full extent in order to write such queries.
Except Language Integrated Query itself, new version of .Net Framework includes LINQ to SQL, which is a simple, but very powerful system of object relational mapping (ORM).
In comparison with traditional ADO.NET technology, using LINQ to SQL significantly simplifies code, reduces errors and design time of the project. Web developers will get most advantages of this, as new version of ASP.NET features special data source that allows queries directly in the Web page.
Unfortunately, LINQ to SQL doesnt provide built-in tools to synchronize database structure with the object model; this tiresome task is entrusted to the developer. In practice, this results in increased manhours and even makes developers refuse using this promising technology.
Perpetuum Software LLC released a new version of Database Restyle, a software component that will help developers solve this problem. The product is designed to synchronize database structures. In a new version, LINQ to SQL object model as well as any other existing database schema can be used as a source database structure. And there is no need to write sophisticated code, as only few lines of code are required to create or update database structure. Just imagine to what extent developers performance will increase.
Besides that, the whole process starting from forming database object graph to executing DLL scripts is under the developers total control.
If necessary, it is possible to force any aspect of Database Restyle work, including:
- Re-definition of procedures of creating various database entities;
- Addition of extra entities that are not covered by the object model;
- Executing additional scripts before and after database update;
- Skip of some database objects when database is synchronized.
It is also possible to get list of differences and scripts required for update without executing database update. In other words, working with LINQ to SQL object model doesnt differ from working with any other database structures.
Tools for automatic database structure synchronization are absolutely needed if objects are first class entities of the application, says Eugene Akinshin, Chief Technical Officer for Perpetuum Software.
Not the least of the factors is the fact that Database Restyle components can be integrated into both client and server applications regardless of the GUI technology used: ASP.NET, Windows Forms, or WPF and distributed inside your application without any additional fees. Full source code is available.
Using Database Restyle automates creation and synchronization of databases, helps developers save time and money required to release new versions of databases and to deploy them.
More information on Database Restyle can be found on the vendor web site:
http://www.perpetuumsoft.com/Product.aspx?lang=en&pid=55&pr=dbr11
About company:
Perpetuum Software LLC specializes in development of high-quality .NET and ASP.NET software components compatible with MS Visual Studio .NET, C# Builder, Delphi .NET and other IDEs supporting .NET Framework. Such use-proven components as Report Sharp-Shooter, Instrumentation ModelKit, OLAP ModelKit, Chart ModelKit, the .Net Dashboard Suite, OLAP + CHART ModelKit and other .NET components by Perpetuum Software LLC are already well known on the software development market and are used by developers in more than 60 countries.
Company: Perpetuum Software LLC
|
| Related press releases |
Automatic synchronization of database structure with LINQ to SQL model. [2007-12-18 09:53:53]
At last, event that was awaited for a long time by the whole developers community and that is expected to make developers work much easier happened final release of .Net Framework 3.5 featuring LIN...
|
|
LINQ to MySQL and LINQ to Oracle Support Available in Beta! [2008-09-16 07:12:35]
Devart, a leading provider in solutions based on ADO.NET technology for the most popular database servers, announced today the first Beta of a new feature for our MyDirect .NET and OraDirect .NET - LI...
|
|
Extending Entity Framework and LINQ to SQL Support in ADO.NET Data Providers fo... [2009-05-29 07:27:14]
Devart has recently announced the release of dotConnect products for Oracle, MySQL, PostgreSQL, and SQLite, ADO.NET providers that offer Entity Framework support, LINQ to SQL support, and contain an O...
|
|
Save your time and efforts on database synchronization. Use Database Restyle. [2007-06-19 17:00:54]
Perpetuum Software LLC announces the release of a beta version of a new product which facilitates work with databases. Database Restyle generates script to synchronize database structure from your app...
|
|
Navicat MySQL GUI for Mac OS X version 7.1.6 is released. [2008-10-13 01:51:51]
The latest version is compatible with Mac OS X Leopard!
Navicat MySQL GUI is a graphical tool for managing, monitoring, and developing your MySQL database. This new version supports Excel Import, V...
|
|
Synchronize databases without a single click! [2007-11-20 15:28:52]
Database synchronization is a headache for your developers? It takes too much time, as it is performed manually and inevitably involves errors? You are afraid that implementation of the third party so...
|
|
DatAdmin 3.2.2, new database management tool, is released [2009-08-12 14:23:58]
Prague, Czech Republic, August 12, 2009
JenaSoft today announced release 3.2 of new generation cross-platform database administration tool, DatAdmin. DatAdmin offers easy and quick to use database ...
|
|
Devart Releases dbForge Studio for MySQL v 3.50 with State-of-the-Art Database D... [2009-05-14 00:16:20]
dbForge Studio for MySQL is the latest software to deliver a combination of proven schema and data comparison and synchronization tools, an extra-visual database design tool, and many more to dramatic...
|
|
Speed, Simplicity, and Safety of Database Comparison and Synchronization with db... [2009-07-21 00:22:25]
Devart released the first version of dbForge Schema Compare for MySQL, a special tool for comparison and synchronization of MySQL databases. dbForge Schema Compare for MySQL 1.00 meets the needs of bo...
|
|
DBSync for Firebird and MS SQL v. 1.0.0 release! [2009-09-21 06:40:01]
We are glad to announce DBSync for Firebird and MSSQL v. 1.0.0 release!
DBSync for Firebird and MSSQL is a powerful synchronization tool designed for bi-directional conversion between Firebird/Int...
|
|
|
|
| WhatDisk |
 WhatDisk is an easy-to-use program with an Explorer-like user interface that helps you categorize your disks (CD's, DVD's, ZIP disks, external hard drives, USB sticks, MP3 player, iPod etc.) into a single, searchable database. |
|
| Fox Movie Manager |
 With automatic info downloads, loan tracking, and several other features, the Fox Movie Manager will give you everything you need to get your movie collection under control. Innovative features allow you instantly know the status of your collection. |
|
| MP3 EZlib Music Library/Playlist Manager |
 EZlib is a Free MP3 Music Library/Playlist Manager featuring custom-query on 14 ID3v2 tag fields and file dates; single and mass ID3v2 Tag updating; 4 user-defined custom ID3v2 fields; add/delete pictures; runtime playlist tweaking; automatic lyrics |
|
| Aloaha PDF Saver |
 The Aloaha PDF Saver allows you to fill in PDF Forms and save them to disk.
A OCX Version inclusive sample source code of the PDF Saver is also included.
You can also retrieve the Form Data as an XML File to archive it in your database. |
|
| Wondershare QuizCreator X'mas Offer |
 Wondershare QuizCreator is a robust solution designed for making highly customized flash quizzes without programming. Users can publish their quizzes to LMS (AICC/SCORM), and pass test results to Web database for learning evaluation. |
|
| Super Flexible File Synchronizer |
 Easy but powerful backup and synchronization of laptops, PCs, servers, and backup storage. Multiple profiles, FTP (with SSL), SSH, WebDAV, Amazon S3, http, partial file updating, ZIP and encryption support, as well as a scheduler & Real Time Sync. |
|
| DBEXform |
 Make database application development and use as easy as using word processor or spreadsheet with DBEXform. It builds application logic in background and frees developer to just on building interfaces. Support for Microsoft Sql and Access databases. |
|
|
Latest press releases
