在VS2010上使用sdf的相对路径访问SqlCeDB
我有一个 SqlCeDB 作为我的项目的一部分，现在连接字符串如下：
public String localDBConnectionString = @"C:\Users\Patrick\Documents\Visual Studio 2010\Projects\WpfApplication1\WpfApplication1\MapProjectDB.sdf";
显然，当我发布它并将其放在另一台机器上时，这将会失败。如果连接字符串既处于调试模式又已发布，我怎样才能使连接字符串工作？
I have a SqlCeDB as part of my project, right now the connection string is the following:
public String localDBConnectionString = @"C:\Users\Patrick\Documents\Visual Studio 2010\Projects\WpfApplication1\WpfApplication1\MapProjectDB.sdf";
Obviously this is going to fail when I publish it and put it on another machine. How can I make the connection string work if its both in Debug mode and also if it has been Published?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我遇到了同样的问题，能够通过将其放入以下形式来纠正
SqlCeConnection connection = new SqlCeConnection(@"Data Source=|DataDirectory|\database1.sdf");
i have faced the same problem , was able to rectify by putting it in the following form
SqlCeConnection connection = new SqlCeConnection(@"Data Source=|DataDirectory|\database1.sdf");