title: Inserting into DB2 database from SQL Server stored procedure succeeds, but wrapping the same procedure using Entity Framework fails
body: <p>I need to be able to insert rows into a set of tables in a DB2 database from a Microsoft SQL Server database. I created stored procedures that can insert rows into the DB2 database using a linked server, referencing the target tables by their 4 part names. These procedures work and I am able to insert records by calling them in SQL Server Management Studio.</p>
  <p>The schemas are different between the two databases, so I am using a C# program and Entity Framework wrap these stored procedures to help me perform the mapping. When running my program an exception is thrown with the message</p>
  <blockquote>
  <p>The operation could not be performed because OLE DB provider &quot;IBMDASQL&quot; for linked server &quot;LinkedServer&quot; was unable to begin a distributed transaction</p>
  </blockquote>
  <p>Running a SQL trace and replaying the commands created by Entity Framework in SQL Server Management Studio creates the desired records in DB2.</p>
  <p>What am I missing here to get these stored procedure calls working from Entity Framework?</p>