Mdf文件只是准备好了 [英] Mdf file is ready only

问题描述

我在C＃中有一个完全脱机运行的Windows应用程序。我使用SQL Server作为后端，并在我的应用程序中使用.mdf，.ldf文件进行数据库访问。



创建安装文件时，我们在安装文件中添加了这些文件我用vs安装程序创建了安装文件。并在客户端电脑上安装sql express。



现在问题是当我们在客户端计算机上安装安装文件时它会在

中创建一个文件夹

C：/'默认公司名称'

但每次我们必须通过windows安全选项授予这些文件的权限。我们有什么方法可以为所有人分配权限吗？



我尝试过：



i使用app.config文件夹下面的连接字符串连接数据库

I have a Windows application in C# that completely runs offline. I have used SQL Server as backend and use .mdf, .ldf files in my application for database access.

While creating setup file we have added these files in setup file.here i have created setup file using vs installer. and also install sql express in client pc.

Now the problem is when we install setup file in client computer it creates a folder in

C:/'Default Company Name'
but every time we have to give permissions to these files through windows security option. Is there any way we can assign permissions once for all?

What I have tried:

i am using below connection string from app.config folder to connect with database

<connectionStrings>
   
    <add name="conString" connectionString="Data Source=(LocalDB)\v11.0; AttachDbFilename=C:\Program Files\MYsetup\MYdatabase.mdf;Integrated Security=True;Connect Timeout=30"/>
  </connectionStrings>

推荐答案

AttachDBFileName 是邪恶的，请看这个问题：

怎么做我在visual stadio 2015中连接旧版数据库 [ ^ ]

AttachDBFileName is evil, see this question:
How do I connect to old version database in visual stadio 2015[^]

您不应该将数据文件保存在C：\Program Files中，请参阅我应该在哪里存储数据？ [ ^ ]。

You should not be saving data files in C:\Program Files, see Where should I store my data?[^].

这篇关于Mdf文件只是准备好了的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！