Quantcast

Too Geek To Be True

Everything About Geeky Stuff

Subscribe to Too Geek To Be True

Is there a better way to refresh dbml when database schema changes ?

Posted by Chris Prakoso On January - 20 - 2009

I’ve been doing a lot of LINQ works at the moment, and naturally database schema changes quite regularly.  Table fields added, deleted or changed, etc. So far the only way I know to refresh my dbml file is by deleting the table from the designer and drag a new one back from the server explorer.  Obviously after a few of this excercise, I got really annoyed, and started thinking to myself “I can’t believe that Microsoft didn’t think about how to make this operation easier”.  But looking around for this ‘Refresh’ button on Visual Studio was proven to be a waste of time, it just simply doesn’t exist !

Still with curiosity and determination to find a better way, I scoured the Internet to look for a definitive answer, just in case I missed something.

To short answer to the above question is a resounding NO. Cor Blimey !

There is an alternative though, but only if you want to pay for it :)  On some of the forums where this question was asked, there always this guy who keep promoting his add-in for Visual Studio 2008 which apparently does exactly what we need.

I still can’t believe that Microsoft would missed such an important thing.  Oh .. well … it is Microsoft after all.

No related posts.

One Response to “Is there a better way to refresh dbml when database schema changes ?”

  1. t moore says:

    using sqlmetal or sqlmetalbuilder does the trick

Leave a Reply

About Us

Chris Prakoso is a Software Programmer and Web Developer, Mac Convert and Social Media Geek.

Flickr

08042010630080420106290804201062808042010627080420106260804201062508042010624080420106230804201062208042010621