我退出应用程序时，.mdf文件中的数据丢失 [英] Data lost from .mdf file as I exit application

问题描述

最近，我正在处理SQL Server 2008 R2数据库.我创建数据库并在应用程序中附加同一数据库的.mdf文件，并在其中添加一些默认数据.运行正确的应用程序默认数据.现在，我在应用程序中插入，更新一些数据，并且它可以正常工作.但是，当我退出应用程序并再次运行应用程序时，最后添加和更新的数据会丢失，但是默认数据会像之前那样正确.请帮忙.为什么要新

Recently I work on SQL Server 2008 R2 database. I create database and attach .mdf file of same database in my application with some default data in it . Run application default data coming properly. Now I insert, update some data in my application and its works fine. But as I exit application and again run application lastly added and updated data get lost but default data coming proper as earlier. Please help. Why new

推荐答案

如@Henk，@Microtechie所述，我扫描了我的项目文件夹，发现那里有3个.mdf文件副本，其中第1个位于代码所在的项目文件夹中project([ProjectFolder])位于[ProjectFolder]/bin/debug文件夹中的第二名，位于[ProjectFolder]/bin/release文件夹中的第三名，在我脑海中突然解决了我的问题触发器.问题不在项目文件夹中的多个.mdf文件中，因为我每次清理"和构建"我的解决方案时，[ProjectFolder]中的.mdf文件的新副本都被复制到[ProjectFolder]/bin/debug文件夹中，导致覆盖同一文件夹中的最后一个.mdf文件.因此，每次我构建和运行应用程序时，只有默认数据即将到来，最后添加和更新的数据会丢失.感谢所有您的答复和准确的答案..！

As mention by @Henk , @Microtechie , I scan my project folder and found there are 3 copies of .mdf file are there, 1st in project folder where code project([ProjectFolder ]) resides 2nd in [ProjectFolder]/bin/debug folder and 3rd in [ProjectFolder]/bin/release folder and suddenly solution to my que trigger in my mind. Problem not in multiple .mdf files in project folder, as I every time ‘Clean’ and ‘Build’ my solution new copy of .mdf file from [ProjectFolder] get copied into [ProjectFolder]/bin/debug folder, result in override of last .mdf file in same folder. Hence every time I build and run application only default data coming and last added and updated data get lost. Thanku all for your replies and precise answer..!

这篇关于我退出应用程序时，.mdf文件中的数据丢失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！