linq to sql change column size RSS

• • Reply
  

  wendy elizab...

  Member

  323 Points

  391 Posts

  linq to sql change column size

  Aug 03, 2012 08:22 PM|LINK

  In a linq to sql data context object that points to a sql server 2008 r2 database in a C#  2010 web form application, I want to change the size of a column from varchar(500) to varchar(900). To acoomplish this task, can you tell me what I need to do so the data context object picks up the expanded size?

• • Reply
  

  BoogleC

  Contributor

  2212 Points

  447 Posts

  Re: linq to sql change column size

  Aug 03, 2012 08:28 PM|LINK

  Hi,

  These steps will work for you. Follow these after you've made the change to the table (so do this using SQL Manager, etc)

  1. Open the data context
  2. Delete the table in question
  3. **Important** - Save the datacontext (ctrl + s) - this recognizes the table's gone and deletes all the mappings
  4. Re-drop the table onto the context and save it.

  That will work.

  HTH's

  Regards,
  BoogleC
  
  Please mark the right solution as the answer. This helps others find what they're looking for.
  • Marked as answer by wendy elizabeth on Aug 04, 2012 08:16 PM