linq vb.net "CREATE FILE encountered operating system error 123" 错误

Question

>我有一个带有链接"dtschool.dbml"的数据库，我想在SQL Server中创建这个数据库 运行此代码时

Dim dt As New SchoolData.linqSchoolsDataContext
Dim sd As New SqlClient.SqlConnectionStringBuilder
sd.DataSource = "LAPTOP-AJM33RB1TESTSERVER"
sd.IntegratedSecurity = True
dt.Connection.ConnectionString = sd.ConnectionString
dt.Connection.Open()
dt.CreateDatabase()

我看到此错误

System.Data.SqlClient.SqlException: 'CREATE FILE encountered operating system error 123(The filename, directory name, or volume label syntax is incorrect.) while attempting to open or create the physical file 'C:Program FilesMicrosoft SQL ServerMSSQL13.TESTSERVERMSSQLDATA|DataDirectory|_Database_Schools_dtSchools.mdf.mdf'.

创建数据库失败。无法创建列出的某些文件名。检查相关错误。

错误

Answer 1

使用此方法

Sub CreatesqldatabaseMSQL()
Try
Using connect As New DataSchool(Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True)
connect.CreateDatabase()
End Using
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub