Generating Deployment Scripts
Every now and then we run into the problem of deploying a ton of scripts for a project, across several databases. Most companies, especially when multiple projects are going on, have a number of separate databases to keep changes and testing isolated. This can be a massive pain when you…
Using Devart dotConnect for MySQL
I have used Devart's dotConnect for Oracle, and I have found it to be excellent. Its support for Entity Framework 6 code-first has been very good, and it massively simplified the setup. So, I would like to try it out for MySQL as well. For this sample, I'm using the…
Code-First Migration to MySQL
This continues from http://dev-blog.dusyk.ca/entity-framework-and-mysql/. Creating the new entities To do code-first migrations, we need to first create the entities. Start by creating the Order class. Right-click on the Models\Entities folder and to go Add > Class...: Enter "Order.cs" for the Name and click "Add": In…
Entity Framework and MySQL
I recently did a project involving ASP.NET 4.6.1, Entity Framework 6.1.3, and Amazon Aurora. Aurora is Amazon's distributed database engine, designed to take advantage of the processing available in a large cloud datacentre. I initially found it very challenging to connect Entity Framework code-first to…