ORM Designer for Entity Framework

Today, I will describe Devart, an Entity Developer tool from Software Factory. Microsoft announced some weeks ago that they will no longer support designer-driven development using the EDMX Designer. Therefore, I decided to consider some third-party tools.

I will guide you through an example application by creating a small example. The free version of Entity Developer, the Express Edition, will be considered. The only restriction that really "limits" us is the limited number of 10 entities per model.

Why do we even need something like an ORM Designer for entity framework? This is a tough question and of course we don't need it. We need it as much as we need a designer for a Windows Forms Project, but there are also some advantages. One of the most exciting features is that we define our business logic, one within the Entity Developer in there way and then we generate our code from the logic. Entity Developer uses T4 Templates to transform the model to code (that's what they mean by Custom Templates). If you own a version other than the Express one, you can create your own template to generate your code, but there are many predefined templates that will fit most of your needs.

I will create a small application in C# with the Entity Developer to manage some bills for us. After installing the Express version, we will start it and create a new Model. The new model will be called Accounting Model. As we are able to work with multiple database providers we can choose from the following.

We will choose LINQ Over SQL.

Next we need to decide what model creation strategy we want to use. Here we will choose Model First to implementing the above mentioned idea.

Enable automatic synchronization. If it is enabled, we can allow the designer to update our model automatically from the database and return it. We can disable it to gain more control over the Creation of the Entities.

In the next screen we can define some basic options, such as the namespace of the generated models. This is typically equal to the project that contains the database access layer. Also helpful is the storage of the connection string inside our App.config file.

Then we come to the code relevant and developer dependent part. With the code generation strategy comes the Developer to its part. The Express version of Entity Developer defines 9 Templates for generating code from your Model. Depending on your selected Model type in the first dialog window, the corresponding template is predefined, in our case it's the "LINQ to SQL". But you can select more templates in addition that will be used to translate you code. You can add them by pushing the Red marked button in the upper left corner.

This will invoke a dialog in which you can select multiple other templates. For example, if you need to support Windows Phone for our LINQ to SQL classes we also need to create models for that case, then we could create them in addition to our "Non" portable classes. Also helpful is the MVC support. It creates Views for ASP.Net by using a Model as the base and can event include Bootstrap for the Form creation. Check out the list of all templates at Devart. For our sample project we will keep the preselected one and continue to the next dialog.

As T4 Templates define several parameters, you got some kind of control over the code generation process. We will define that every Entry in the model should be translated into its own file and that the restrictions (such as Max length) should be validated on the client side by a framework. Also we will define an alternating Output path. That will be necessary since we keep the domain knowledge in the form of this Model Designer away from the code and View.

Then we are done with the setting up of a Model. Now fill it with our business logic.

After the creation of your basic model, we need to include the data structure. For this we will go through the Designer and DataContext. Since we chose the CodeFirst approach, we got no immigration from an existing source. This is still possible; we could just open the connection to a database and pull all the interesting information from it. But for this case we need to do it all from scratch. We will start with a simple table structure to store our bookings. It is simple to add a new table. We will use the Context Menu inside the editor and can navigate to:

Add -> New Class

Or we can use the Shortcut:

Alt + C

Or we can use the direct way to select the DataContext node called Classes and use the Context Menu to add a class. We can also use the Toolbar icon. This is very similar to the well-known Entity Framework designer.

The next procedure is pretty straight forward. We need to define several properties and members of the model we need to create. For our Bookings Table I will create some columns and modify the class.

At this moment this will fit our need perfectly. After we press the OK button, the Bookings Entity will appear in our diagram. In addition, I created an Iban Table and dropped the plain text Iban property from the Bookings table. In the next step we will add a relation.