tags:

views:

26

answers:

1
+1  Q: 

how to use .mdf while developing

I use a .mdf database for my asp.net Mvc project. The project is on source control on a tfs.

When I debug the project, Visual Studio copies the database in to the debugmap. The problem is, when I debug next time, the changes (while testing the previous time) in the database are gone. The reason of this I know, Visual studio copies the original database again in to the debug map.

Can I change some settings in Visual studio to work always on the same database without copying the database after each debug session myself? So I can keep my modified records?

Or how do I have to work with my database while developing?

Greets

+2  A: 

Yes you can. On the properties of your database in Visual Studio you can set 'copy to output folder' to 'only if newer'.

And because visually always works better than read(ally?):

picture!

Snake  2010-05-26 16:20:51
Thx! It works on my notebook from home. But will it work when I checkin on the tfs with my notebook and checkout with my dekstop?
Masna  2010-05-26 22:06:29
Since this setting is stored in your project file you should be fine on your desktop :)
Snake  2010-05-27 04:58:33

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL