openPR Logo
Press release

Automatic synchronization of database structure with LINQ to SQL model

12-18-2007 04:57 PM CET | IT, New Media & Software

Press release from: Perpetuum Software LLC

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 doesn’t 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 developer’s 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 doesn’t 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

Perpetuum Software LLC
http://www.perpetuumsoft.com
15 Prospekt Kalinina, 238
Barnaul,
Altay 656002
Telephone: +7 (3852) 346-538

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.

This release was published on openPR.

Permanent link to this press release:

Copy
Please set a link in the press area of your homepage to this press release on openPR. openPR disclaims liability for any content contained in this release.

You can edit or delete your press release Automatic synchronization of database structure with LINQ to SQL model here

News-ID: 34142 • Views: 1433

More Releases from Perpetuum Software LLC

MobiDB Grand Update – OneDrive Synchronization, Multi-Column Filtering and Sor …
Perpetuum Software, a premier vendor of professional and reliable software for reporting, data visualization and database design and management, announces a new version of MobiDB Database Designer, a professional relational database application for Android and Windows 10 and Windows 8.1, which now offers the ability to have the app for both platforms under a single account, select cloud storage for synchronization and set up complex fintering and sorting in tables. New
MobiDB Grand Update – OneDrive Synchronization, Multi-Column Filtering and Sor …
Perpetuum Software announces a new version of MobiDB Database Designer, a professional relational database application for Android and Windows 10, which now offers the ability to have the app for both platforms under a single account. New User Accounts Now MobiDB offers the ability have the app for all supported platforms under a single account. Now when you purchase the app you will need to pay once to get access to the
Reliable multi-platform reporting component addresses the most complicated repor …
Development of professional and stable business software is a real challenge for developers. It’s also time and resource consuming. To save time and money developers prefer to use universal development frameworks and packages including grids, charts, calendars, tree views, textboxes, menus and other tools including reporting components. Such packages cover most development tasks. But when it comes to more complicated and specific issues they seem to be not flexible enough
Chart design becomes brighter with Chart ModelKit 3.7.
Charts and diagrams are convenient tools for the data visual representation and information perception facilitation. Perpetuum Software LLC announces the release of a new version of the component, intended for charts and diagrams creation, Chart ModelKit 3.7. In a new version, a special attention is devoted to the charts and diagrams design. Imitation of 3D effects on chart series elements is added to PieSeriesView, PointSeriesView and BarSeriesView. Thus, your charts

All 5 Releases


More Releases for NET

ASP .net training in chennai
Introducing Asp by Microsoft Corporation is one of its biggest achievements. With Asp dot net, you can create reliable and reusable applications. The Asp.Net framework is a highly popular one and is the best server-side scripting technology. In the early days of the Web i.e. before the release of Internet Information Services (IIS) in 1997, the contents of web pages were largely static. These web pages needed to be constantly
High Net Worth Home Insurance 2016
Summary Wealthy individuals require specialist mid net worth (MNW) and high net worth (HNW) insurance policies that offer wider coverage, higher limits, and better service compared to standard products. This is due to the higher value of their assets, which may include multiple homes, luxury cars, yachts, antiques, jewelry, wine, and fine art. Home insurance is generally provided on a global all-risk cover basis, often with an element of legal protection
EVS Announces O2 Mobile Warehouse .NET
Boulder, CO-- Escape Velocity Systems (EVS), a Boulder, Colorado based ERP software innovation group announced today they will release a .NET version of O2 Mobile Warehouse distribution and inventory management software for Sage 500 ERP software in August 2012. “The O2 Mobile Warehouse has become the de facto standard WMS for Sage 500 ERP,” states Evan Garber, president of EVS. “The new version of O2 Mobile Warehouse will allow our
PetFace: Net for Every Pet
Internet became ritcher with a new social network – PetFace, a place for all the pets, their owners and animal-lovers. There is a world that is connected by a common feeling – love for animals and nature, on our web page. Listening to the needs and desires of the customers, PetFace provides each member of this social network a free access, an easy way to open their own, or a profile
dtmMANAGER supports .NET
With its latest version the M&M development toolkit dtmMANAGER supports .NET and thus enables a flexible development and efficient design of user interfaces. With the scalable Tools dtmMANAGER, dtmDEVPACK, basicDTM or the direct DTM generation with the dtmGENERATOR, together with a comprehensive service package, M&M Software offers an all-in package for the DTM development. In addition to this and starting in 2010, all M&M customers, who purchase a DTM development
Millennial Net Announces Wireless Solutions for Enterprise
New hardware and software are designed to make a significant impact on energy conservation, energy use management and policy driven by enterprise-wide Energy and Green strategies. Burlington, MA – Millennial Net introduces revolutionary wireless energy management solutions at Sensor-2007 EXPO*. The initial release includes several new wireless devices and web-based software in an integrated architecture ideal for commercial, industrial, educational and governmental organizations with single or multi-site applications.