Model and Database Explorer


Since mid-March, the Modeler ships a new feature known as the Model and Database Explorer which, as the name suggests, lets you explore databases (or XMI and Enterprise Architects models) directly from Visual Studio. The tool provides built-in support for the following databases:

  • Access 2007/2010,
  • Access / Jet,
  • OLE DB,
  • Oracle,
  • SQL Server,
  • SQL Azure,
  • SQL Server CE.

It provides a centralized way to view any databases supported by CodeFluent Entities (either for import or generation purposes) so you don’t have to switch from tool to tool, and you’ll see precisely what CodeFluent Entities sees and understands from those databases (detected tables, keys, constraints, etc.)

For instance, once you generated and deployed your scripts on your online SQL Azure database, within Visual Studio you can explore the generated database, including its data. Talking about viewing data, unlike Microsoft’s SQL Azure Database Manager, Guids and Blobs can be viewed in the explorer Winking smile

To use it, right-click on your CodeFluent Entities project in the Solution Explorer, and select Model and Database Explorer:

image

By default the default connection string of your project is available. If you want to explore a new data source, either add it to your project connection strings, or make a right click on left pane and click Connect:

image

Select your database engine type, and provide the connection string to it. You’ll then be able to navigate through your database.

image

Notice the Data property in the property grid pane? If you click on its “…” button, a new window will pop-up showing all contained data of the current table. This way it provides a unified and quick way for developers to view their data from Visual Studio and on multiple platforms.

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 41 other followers