CODEWITHSUNDEEP
sql-serverentity-framework-4linked-server
Alex
Alex

Reputation: 145

linked server update issue

I'm using entity framework 4 data model entity to connect to sql server 2008 synonym:

use WTT
CREATE SYNONYM [dbo].[Departments] FOR  PLISTI...nodalas

nodalas is linked server's table. Now i can select from this table but cannot make any update operation. I'm getting "The operation could not be performed because OLE DB provider "MSDASQL" for linked server "PLISTI" was unable to begin a distributed transaction" error. During insert operation sql server profiler shows me this query:

exec sp_executesql N'insert [dbo].[Departments]([Nodala_id])
values (@0)
',N'@0 nvarchar(max) ',@0=N'wwwwdddd'

When i'm running this query in sql server management studio it work's. But in entity framework NO. Why?

Upvotes: 0

Views: 1282

Answers (1)

Bryan
Bryan

Reputation: 17703

Configure Microsoft Distributed Transaction Coordinator for the local and linked server. Instructions for Windows Server 2003 and 2008.

Upvotes: 1

Related Questions