使用 Entity Framework 4.1,Ladislav 发布的解决方案将 Scope_Identity() 的 Select 添加到触发器主体的末尾,为我解决了这个问题。为了完整起见,我已在此处复制了整个触发器创建过程。通过这个触发器定义,我可以使用 context.SaveChanges() 将行添加到表中。
ALTER TRIGGER [dbo].[CalcGeoLoc]
ON [dbo].[Address]
INSTEAD OF INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT OFF;
-- Insert statements for trigger here
INSERT INTO Address (Street, Street2, City, StateProvince, PostalCode, Latitude, Longitude, GeoLoc, Name)
SELECT Street, Street2, City, StateProvince, PostalCode, Latitude, Longitude, geography::Point(Latitude, Longitude, 4326), Name
FROM Inserted;
select AddressId from [dbo].Address where @@ROWCOUNT > 0 and AddressId = scope_identity();
END
编辑以处理计算值(感谢评论中的克里斯·摩根):
如果表中有任何其他计算值,则也必须将它们包含在 SELECT 中。例如,如果您有一个CreatedDate
使用的列GETDATE()
你可以像这样进行选择:
SELECT [AddressId], [CreatedDate] from [dbo].Addresses where @@ROWCOUNT > 0 and AddressId = scope_identity();