ASP.NET和Winform中内嵌mdf数据库访问的方法

数据库在App_Data文件夹下

在配置文件中：

  <connectionStrings>

     <add name="connstr" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

.cs类中：

private static string dbConnectionString       

{

           get

            {

               string dataDir = AppDomain.CurrentDomain.BaseDirectory;

                if (!dataDir.EndsWith(@"App_Data"))

                {

                        AppDomain.CurrentDomain.SetData("DataDirectory", dataDir+"App_Data\\");

                }

                return ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;

            }

}

winform 类中：

private static string dbConnectionString
        {
            get
            {
                string dataDir = AppDomain.CurrentDomain.BaseDirectory;
                if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
                {
                    dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
                    AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
                }
                return ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
            }
        }