Introducing the Entity Framework Power Tools

Posted by Jonathan Allen on May 23, 2011

Sections

Operations & Infrastructure,

Architecture & Design,

Development

Topics

ADO.NET Entity Framework ,

ADO.NET ,

.NET ,

Data Access ,

Programming ,

Database ,

ORM

Share |

RELATED Research

The introduction of a Code First option in Entity Framework has received quite a bit of praise. While it still has a long way to go before it unseats the reigning ORM, nHibernate, the progress Microsoft is making is quite astounding. In order to keep the momentum up Microsoft is releasing a set of power tools that will take an existing database and create a Code First representation.

At first glance it seems rather odd to offer way to reverse engineer a database into a code-first model. But there really is a few useful ideas behind this. The first one is merely educational. Unlike the designer-driven workflows from previous versions of Entity Framework, Code First leaves you with a blank slate and no real clues on how to start. Developers can create part of their database first, or even just toy projects, and then use this tool to see what the matching Entity Framework classes should look like. From there they can build out the rest of the classes and then have it generate the full database schema.

Another interesting idea comes into play when you combine this with third-party databases and providers. You could, for example, use this to reverse engineer a SQL Server database and the recreate it in Oracle, MySQL, PostgreSQL or SQLite using Devart’s dotConnect libraries.

Currently the reverse engineering tool is available in EF Power Tools CTP1. Being just a preview, it only supports SQL Server and C#. To install, download it from the Visual Studio Gallery. You will also need to install EF 4.1 using NuGet.

RelatedVendorContent

Tutorial: Integrating SQLFire with tc Server and Spring Data

Introducing SQLFire: a memory-optimized, high performance SQL database

Banking Case Study: Scaling with Low Latency using NewSQL

Want to know how software releases can be stress-free and happen with one click? Try Go free!

Improving Software Delivery Cycles: Pre-requisites and Inhibitors

Related Sponsor

Go: Agile Release Management Solutions. Go enables predictable, defect-free and timely software releases.

1. Back to top

   Sample Code

   by Jonathan Allen

   If you take a look at the "LeadTracker" project you can see some database schema (LeadTracker Database) and the code generated by the tool (LeadTracker.EFCodeFirst).
   
   granite.codeplex.com/SourceControl/list/changesets

   Reply

2. Back to top

   preview

   by Stefan Wenig

   "Being just a preview, it only supports SQL Server and C#."
   
   That sounds as is if would support Oracle etc. past preview. Of course it won't, Devart might.

   Reply

3. Back to top

   Re: preview

   by Jonathan Allen

   If you want that to happen make sure you let the ADO.NET team know. Developer feedback is heavily driving their design decisions.

   Reply

4. Back to top

   Comments

   by Devart Team

   “Being just a preview, it only supports SQL Server and C#.”
   Actually, EF Power Tools allow working with Oracle, MySQP, PostgreSQL, and SQLite. The CTP1 has a problem connected with config-file stored connecting string processing. However, there are some workarounds to overcome these difficulties. You can find more information about it at: www.devart.com/blogs/dotconnect/index.php/using...

   Reply