c# - Best way to update LINQ to SQL classes after database schema change

Question

I'm using LINQ to SQL classes in a project where the database design is still in a bit of flux.

Is there an easy way of synchronising the classes with the schema, or do I need to manually update the classes if a table design changes?

Answer 1

You can use SQLMetal.exe to generate your dbml and or cs/vb file. Use a pre-build script to start it and target the directory where your datacontext project belongs.

C:Program FilesMicrosoft SDKsWindowsv6.0ABinx64sqlmetal.exe 
  /server:<SERVER> 
  /database:<database> 
  /code:"pathSolutionDataContextProjectdbContext.cs" 
  /language:csharp 
  /namespace:<your namespace>