用于创建数据库的 Linq to Sql 执行命令

发布于 2024-10-06 12:17:27 字数 942 浏览 3 评论 0原文

我有一个 ASP.NET MVC 应用程序，并且使用 LinqToSql 进行数据库访问。

我想从 SQL 脚本创建一个数据库到我的 DBMS (SQL Server Express) 中。

当我运行我的脚本时，没有 SQL Server Management Studio，它可以使用相同的用户连接，但是，当我使用 ExecuteCommand 从 LinqToSql 运行它时，它确实会给出有关我无法使用 GO 语句的错误。如果我删除 GO 语句并重试，它会显示 CREATE SCHEMA 应该是批处理的第一行。

因此，我很困惑，是否有任何其他（更好）的方式从 asp.net mvc 运行包含 CREATE DATABASE 和 CREATE SCHEMA 语句的 sql 脚本而没有这些问题。

谢谢， cas sakal

这是脚本的内容；

USE [master]
GO
CREATE DATABASE [TESTDB]
CREATE SCHEMA [base] AUTHORIZATION [dbo]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [base].[TestTable](
[Id] [uniqueidentifier] NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,     ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

原文

I have a ASP.NET MVC application and I am using LinqToSql for database access.

I want to create a database from a SQL script into my DBMS (SQL Server Express).

When I run my script no SQL Server Management Studio it works with same user connection, however, when I run it from LinqToSql with ExecuteCommand it does give errors about I cannot use GO statements. If I remove GO statements and try again, it says CREATE SCHEMA should be the first line of the batch.

Therefore, I am confused, is there any other(better) way of running the sql script, which contains CREATE DATABASE and CREATE SCHEMA statements, from asp.net mvc without these issues.

Thanks,
cas sakal

Here is the content of the script;

USE [master]
GO
CREATE DATABASE [TESTDB]
CREATE SCHEMA [base] AUTHORIZATION [dbo]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [base].[TestTable](
[Id] [uniqueidentifier] NOT NULL,
[Name] [nvarchar](100) NOT NULL,
[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,     ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

看海 2024-10-13 12:17:27

这对我有用：

 using (var db = CreateContext()) {
    if (db.DatabaseExists())
      db.DeleteDatabase();
    db.CreateDatabase();
    using (var sr = new StreamReader("prepareDatabase.sql")) {
      var commands = sr.ReadToEnd().Split(new string[] {"GO\r"}, System.StringSplitOptions.RemoveEmptyEntries);
      foreach (var cmd in commands) {
        db.ExecuteCommand(cmd);
      }
    }
  }

This works for me:

 using (var db = CreateContext()) {
    if (db.DatabaseExists())
      db.DeleteDatabase();
    db.CreateDatabase();
    using (var sr = new StreamReader("prepareDatabase.sql")) {
      var commands = sr.ReadToEnd().Split(new string[] {"GO\r"}, System.StringSplitOptions.RemoveEmptyEntries);
      foreach (var cmd in commands) {
        db.ExecuteCommand(cmd);
      }
    }
  }

回复收藏 0 原文