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: 1506

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

Bale Net Market Size, Share | Bale Net Industry Future Growth, Market Analysis
Global Bale Net Market Report provides a detailed industry overview along with the analysis of Cost Structure, Supply Chain, Development Techniques, Retailers Analysis, Financial Support, business Strategies, Marketing Channels. Global Bale Net Market research report provides a point-by-point In-Depth analysis of global market size, regional and country-level market size, segmentation market growth, market share, competitive Landscape, sales analysis, the impact of domestic and global market players, value chain optimization, trade
Bale Net Market Size, Share | Bale Net Industry Future Growth, Market Analysis
Global Bale Net Market Report provides a detailed industry overview along with the analysis of Cost Structure, Supply Chain, Development Techniques, Retailers Analysis, Financial Support, business Strategies, Marketing Channels. Global Bale Net Market research report provides a point-by-pointIn-Depth analysis of global market size, regional and country-level market size, segmentation market growth, market share, competitive Landscape, sales analysis, the impact of domestic and global market players, value chain optimization, trade regulations,
.NET Standard 2.0 Support & Enhanced Working with Project Export to PDF using .N …
What's New in this Release? Aspose team is pleased to announce the new release of Aspose.Tasks for .NET 18.12. This release has also implemented various features for Style Customization for Custom Task Fields along with several other bug fixes reported that further enhance the stability of the API. It has added the support of .NET Standard 2.0. In this release, Style Customization features are implemented for Custom Task Fields,
.NET Standard 2.0 Support & Control File Compression while Saving FBX using .NET …
What’s new in this release? Aspose team is pleased to announce the release of Aspose.3D for .NET & Java 18.10. This release includes long awaited feature of Support for .NET Standard 2.0 (.NET Core) Framework. Several other performance related enhancements have also been incorporated in this release. Aspose.3D API provides users even better control over their applications. This release has added EnableCompression property to FBXSaveOptions class, which allows users to decide
Aspose.XPS for .NET is Released: Create/Manipulate New & Existing XPS Documents …
What's New in this Release? Aspose is proud to expand its .NET APIs family with the addition of a new product known as Aspose.XPS for .NET. First version of the API is now available and can be downloaded from NuGet Gallery. Aspose.XPS for .NET is a .NET library which is built to allow developers to create, edit and save new as well as existing XPS documents. Various features regarding creating objects
.NET Core Support, Setting Precision of Data in Chart Data Labels using .NET
What's New in this Release? Aspose team is happy to share the announcement of Aspose.Slides for .NET 18.6. In this release we have improved the chart support by adding new features along with resolution of other issues. There are some important new features part of this release, such as .NET Standard/.NET Core support, Setting Precision of Data in chart Data Labels, Support for setting date format for Category Axis Value, Support