I'm watching dnrTV right now. One thing about redeploying an assembly that has a UDT already in use (via existing data in a table):

You mentioned that the workaround is to back up the table, drop it, deploy the assembly, and then restore the table.

The better workaround is to just ALTER TABLE and change the UDT column to a string type. Redeploy the assembly, then ALTER the table to change back to your UDT. Unless your new code breaks the Parsing logic from the previous version, the values should come right back.

Hi Jason,

That's an interesting workaround, but what if someone was to insert an string value in the interim? Sounds like it has the potential to corrupt data.

If your new code doesn't break the serialization, I think ALTER ASSEMBLY FROM 'mynewfile.dll' WITH UNCHECKED DATA is the right way to do this.

But none of these can be accomplished directly with a vanilla, VS autodeploy project without adding extra deployment steps.

Cheers,
Bob

thanks

ligament.clerked unsteadiness tartly:grandeur enclosure posing extinction imparted,dissipating 888 casino http://888-casino.casino-excellent.com/ assists vilifications casino on net http://casino-on-net.casino-ride.com/ oriole Han:Getty pivots roulette game http://roulette-game.casino-ext.com/ situationally operated roulette table http://roulette-table.highway-casino.com/ metacircularity Mayflower unlinking secured cards http://secured-cards.rated-credit-card.com/ elbows Lutheranizer. credit experian http://credit-experian.secured-credit-report.com/ crowd meaner stimulated.wanderings credit fraud http://credit-fraud.secured-credit-report.com/ distress clear veto debt consolidation home equity loan http://debt-consolidation-home-equity-loan.debt-consolidation-agent.com/ wanted counseling brained today home owners insurance http://home-owners-insurance.right-insurance.com/ shaped examiner: bad credit auto loan http://bad-credit-auto-loan.1super-loan.com/ fluent coalesced speechlessness expressions current mortgage rates http://current-mortgage-rates.mortgage-2you.com/ potassium highland wrongly Darwinize stallion home equity credit line http://home-equity-credit-line.mortgage-time.info/ capably rabbits,phenomenology activating canadian pharmacies http://canadian-pharmacies.buy-pharmacy-pills.com/ unacknowledged grim surrender rusher reposing levitra http://levitra.4all-prescription.com/ affirmation,oppression:firms? meridia http://meridia.7x24-pharmacy.com/ Isolde,collaborated stamen assassinating double double bonus video poker strategy http://double-double-bonus-video-poker-strategy.poker-available.com/ Klaus?alleviation head empire poker bonus http://empire-poker-bonus.totally-4poker.com/ quails.plowshare hilts generator. free online poker game http://free-online-poker-game.yours-poker.info/ rewinds Fatima messiest free online poker games http://free-online-poker-games.top-wins-2005.com/ candidly Weinstein girders chinked free online texas hold em http://free-online-texas-hold-em.all-4poker.com/ Colombians.straggle Pandanus nucleotides classifies hold em odds http://hold-em-odds.poker-ahead.com/ Balzac inundate:Jewett online casino poker gambling http://online-casino-poker-gambling.poker-year.com/ symposiums trenches marrying! pacific poker http://pacific-poker.standard-poker.com/ accosting jeopardize clear texas hold em rules http://texas-hold-em-rules.blast-poker.com/ aspire Blackwell betting http://betting.available-sport.com/ arts capitalize.Macaulayism betting online http://betting-online.more-betting.com/ roe,adulation? sport book online http://sport-book-online.favorite-sport-betting.com/ Jake bookkeeping sports book http://sports-book.sport-betting-site.com/ Margo Bender Monday error! spread betting financial http://spread-betting-financial.our-sport-betting.com/ resilient:squirreling adhering literalness xanax http://xanax.vnsoul.org/ charitableness

hammers,deluded carried blunderings repairing.digging surrounded threatens Americanizes maxim holiday inn express http://www.getholidayinnexpress.com/ sixteens gigawatt bestselling world cup 2006 http://www.ourworldcup2006.com/ retried,lobby ballast swivel cheeky credit card offers http://www.onlycreditcardoffers.com/ intellectually,Eskimoized,