views:

110

answers:

1

Hi,

anybody have any easy way of doing this in Visual Studio, without having to use the Server Explorer ?

I tried also looking at macro's but recording only produce

  Sub TemporaryMacro()
  End Sub

So no luck there.

Any way to script this?

+2  A: 

There is one good utility out there which helps you update your existing DBML files from the database: Huagati DBML/EDMX tools.

It's not free, but worth the investment for any serious Linq-to-SQL development.

The only alternative would be to write it yourself - read the database structure and compare that to the XML representation in the DBML, and update the DBML as needed.

marc_s
Hmm, yes.. unfortunate, they must plan to add this to next release of SqlMetal... But seems like a nice tool, but I don't have budget for nice to have issues.Been trying to figure out how to script it in VStudio Macro's but no luck yet.
Exception Duck
@Exception Duck: I doubt it - Microsoft has said it won't be putting much effort into Linq-to-SQL and its tooling anymore.
marc_s
Found this. http://sqlmetalinclude.codeplex.com/Looking at it now, will post it as an answer if it works well.
Exception Duck