RSS

Entity Framework for making structural DB changes.

28 Dec

We have all had to do it at some point… but it can get really tricky when you have a project that is constantly changing, especially when data is involved. We have a project where all the data needs to be remain intact, unfortunately these changes were not easy to script.

To migrate the live data into the new structure we used the Entity Framework to generate our old domain from the old database and the new domain from the new database structure. They were imported on different namespaces to determine which model was being dealt with. It was a doddle because it meant mapping the old domain object against the new domain object, then inserting the live data into the new structure.

Saved a lot of time and we weren’t writing SQL queries. What I also liked about this, is the project uses Fluent Nhibernate!

About these ads
 
1 Comment

Posted by on December 28, 2009 in SQL Server

 

Tags: , , , , , , , , , , ,

One response to “Entity Framework for making structural DB changes.

  1. Paper Airplane Design

    January 8, 2010 at 9:46 am

    This is one of the pleasant surprises of browsing/surfing or whatever you want to call it. You can easily find something that matters or at least entertains.
    I want you to know that I appreciate this.

     

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.

%d bloggers like this: