当我运行此脚本手册时,它正在工作,但当我使用实体框架在C中运行它时,我得到一个异常
db.Database.ExecuteSqlCommand(script); //Exception
SQL脚本:
CREATE TABLE [Customers]
(
[Id] INT NOT NULL IDENTITY (1,1),
[Name] NVARCHAR(4000) NOT NULL,
[Email] NVARCHAR(4000) NOT NULL,
[Phone] NVARCHAR(4000) NOT NULL,
[Address] NVARCHAR(4000) NOT NULL,
[Suburb] NVARCHAR(4000) NOT NULL,
[Postcode] NVARCHAR(4000) NOT NULL,
[Number] INT NOT NULL
);
GO
ALTER TABLE [Customers] ADD CONSTRAINT [PK_Customers] PRIMARY KEY ([Id]);
Go
ALTER TABLE [Orders] Add [Customer_Id] INT;
GO
用“go”关键词摘录
“分析查询时出错。[令牌行号=12,令牌行偏移量=1,错误中的令牌=go]“
没有“go”关键字的异常
“分析查询时出错。[令牌行号=12,令牌行偏移量=1,错误中的令牌=更改]“