title: LINQ to SQL: Alter Table or Add New Table to Existing Database
body: <p>Does LINQ to SQL allow tables to be altered similar to the way tables can be created <a href="http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.createdatabase.aspx" rel="nofollow noreferrer"><code>DataContext.CreateDatabase()</code></a>?</p>
  
  <p>I know its bad practice to modify the database, however, new information may need to be added to our data structure. I wondered if LINQ to SQL allowed for a push system to alter existing tables?</p>
  
  <p>If there is no built in LINQ to SQL class for this functionality, what isthe best way to approach this?</p>
  
  <p><strong>Update:</strong></p>
  
  <p>It appears as if this is not possible. I have requested a new feature to be added to the .NET Framework. Vote for it if you are also interested: connect.microsoft.com <a href="https://connect.microsoft.com/VisualStudio/feedback/details/635612/linq-to-sql-alter-or-add-new-tables" rel="nofollow noreferrer"><strong>Feature Request</strong></a>.</p>
  
  <p>Also see the question <a href="https://stackoverflow.com/questions/1337652/is-it-possible-to-use-linq-to-alter-a-database-table">Is it possible to use Linq to ALTER a database table?</a>.</p>