vbfeeds.com/Post

The content of the postings is owned by the respective author. vbfeeds.com is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on vbfeeds.com, please contact us at abuse@vbfeeds.com and we will remove it. Designated trademarks and brands are the property of their respective owners. vbfeeds.com Copyright © 2005 Serge Baranovsky. All rights reserved.

Monday, March 30, 2009

Can't Update Sql Server Express Database in Visual Studio Solution?

by Mike McIntyre via Mike McIntyre on 3/30/2009 1:28:00 PM

Your problem is likely the result of the Copy to output directory property on the database.

The Copy to output directory property controls when your database is copied when debugging your application.

By default, the database is copied to the output directory every time you debug (F5) your application. This means you will never see the results of the last debug session because inserts, updates, and deletes are made to the copy in the output directory and the next time you debug, the project database is copied to the output directory, replacing the copy with your edits.

For debugging, change the Copy to output directory property to Copy if Newer

The Copy To Output Directory option can be found on the property window when the database is selected in Solution Explorer.

Mike McIntyre [MVP Visual Basic]
Source Code for .Net Programmers
www.getdotnetcode.com
Blog - Mike McIntyre's .Net Journal

Original Post: http://cs.vbcity.com/blogs/mike-mcintyre/archive/2009/03/30/can-t-update-sql-server-express-database-in-visual-studio-solution.aspx

© 2005 Serge Baranovsky. All rights reserved.
All feed content is property of original publisher. Designated trademarks and brands are the property of their respective owners.

This site is maintained by SubMain(), a division of vbCity.com, LLC