Blog Stats
  • Posts - 2
  • Articles - 0
  • Comments - 1
  • Trackbacks - 0

 

Friday, February 15, 2013

MySQL GUI tool - dbForge studio for MySQL v. 6.0 Beta


Just a couple days ago, Devart, software development company, has released the 6.0 Beta Version of its MySQL GUI tool – dbForge Studio for MySQL .

The latest version is jam-packed with completely new features. Let's take a look at some of the few most significant, and explore the following:


  • Database refactoring

    Now database objects can be renamed without thinking about consequences - the application will generate an update script and you'll only have to execute it to update links to the renamed object in the whole database.

  • Query builder with support of DML statements and usability improvements

    Working with queries was improved.

  • Improved code completion

    Code Completion feature now offers completely new possibilities. Devart team has done a great job to provide a stunning ease of use and effectiveness of code completion for MySQL database, as it previously did in its tools for SQL Server and Orcale.

  • Automated data report delivery

    This improvement allows delivering generated reports to the requested destination using one of available methods - e-mail, ftp, or shared folder.

  • Code Snippets Manager

    Code Templates feature was renamed to Code Snippets. New Snippets Manager allows adding new snippets and editing existing ones.

  • New window docking system

    You can perform different tasks on several monitors at once using one application instance.

  • Application appearance improved

    Devart has followed the Microsoft tendency to change application appearance. That's why they decided to add Metropolis and VS2010 skins to give application a new look.

  • Data export to SQL statements

  • Improved database object editors

  • New features in the data comparison tool

  • Support of MySQL pluggable authentication when creating a connection to MySQL server

  • Support of Windows authentication when creating a connection to MySQL server

If you are impressed well enough download dbForge Studio for MySQL Beta and don't forget to leave your feedback.

Wednesday, January 23, 2013

Entity Developer with support for DB2 database and third-party providers for Entity Framework models


Entity Developer, ORM model designer, and the latest release includes support for third-party providers and DB2 database for Entity Framework models. Now you can use Entity Developer to design Entity Framework models for Oracle, MySQL, PostgreSQL, DB2, Firebird, and SQLite!  

The following databases and providers are now supported for Entity Framework:
Oracle DBMS –  Oracle Data Provider for .NET
MySQL DBMS –  MySQL Connector/Net
PostgreSQL DBMS –  Npgsql
SQLite DBMS –  System.Data.SQLite
DB2 DBMS –  IBM DB2 .NET Data Provider
Firebird DBMS –  Firebird ADO.NET Data Provider
If you develop software using Entity Framework and these providers, try using Devart's Entity Developer. 
For Database-First approach Entity Developer offers powerful naming rules, data type mapping customization, automatic detection of many-to-many associations, inheritances, etc. 
For Model First, Entity Developer offers powerful mapping synchronization and allows you to preserve manual mapping changes when creating or updating the database. 
Entity Developer provides many other features not available in Visual Studio Entity Data Model Designer. For example it supports model-database synchronization with possibility to select changes to apply. It supports all kinds of inheritance hierarchies,  visual storage model editing, background model validation, etc.
Moreover, new Entity Developer version offers the powerful model refactoring functionality that greatly simplifies and automates such operations as creating complex types from properties, common to several entities, or creating TPT or TPC hierarchies from several entities. 

These features allows you to greatly increase your productivity when designing Entity Framework models with Entity Developer. 
You can download Entity Developer 5.0 from the Download page on the official Devart web-site.

 

 

Copyright © Marina Nastenko