如何使用网页将数据库附加到sqlserver

本文介绍了如何使用网页将数据库附加到sqlserver的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我必须从DataContext（dbml）创建一个新数据库并将其附加到sqlserver 我创建了新数据库但是附加方法不起作用 我的尝试：

I have to create a new database from DataContext (dbml) and attach it to sqlserver I have created the new database but the attach method doesn't work What I have tried:

MyDataContext db = new MyDataContext (connstr); db.CreateDatabase(); System.Diagnostics.Process process = new System.Diagnostics.Process(); System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo(); startInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden; startInfo.FileName = "cmd.exe"; startInfo.Arguments = "sqlcmd -S localhost\\SQLexpress"+ Environment.NewLine + "USE [master]"+ Environment.NewLine + "GO"+ Environment.NewLine + "CREATE DATABASE MyNewDb ON "+ Environment.NewLine + "( FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\MyNewDb.mdf' ),"+ Environment.NewLine + "( FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\MyNewDb.ldf' )"+ Environment.NewLine + " FOR ATTACH ;"+ Environment.NewLine + "GO"; process.StartInfo = startInfo; process.Start(); process.WaitForExit();

推荐答案

（FILENAME = N'C：\\Program Files \\\ \\ _Microsoft SQL Server \\MSSQL10_50.SQLEXPRESS \\MSSQL \\DATA \\ MyNewDb.ldf'） 查看两者的扩展名第一项是mdf而另一项是ldf ( FILENAME = N'C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.SQLEXPRESS\\MSSQL\\DATA\\MyNewDb.ldf' ) Check Extensions of both items one is mdf and other is ldf