{"id":23942,"date":"2023-06-26T12:22:05","date_gmt":"2023-06-26T11:22:05","guid":{"rendered":"https:\/\/developers.primaverabss.com\/en\/forum\/controlo-de-transacoes-dentro-da-webapi\/"},"modified":"2023-06-27T12:30:26","modified_gmt":"2023-06-27T11:30:26","slug":"controlo-de-transacoes-dentro-da-webapi","status":"publish","type":"cma_thread","link":"https:\/\/developers.ila.cegid.com\/es\/forum\/controlo-de-transacoes-dentro-da-webapi\/","title":{"rendered":"Controlo de Transa\u00e7\u00f5es dentro da WebAPI"},"content":{"rendered":"<p>Pretendo garantir a cria\u00e7\u00e3o de dois Documentos dentro do mesmo pedido \u00e1 WebAPI atraves do controlo de transa\u00e7\u00f5es.<\/p>\n<p>Acontece que ao executar o primeiro Atualiza para gravar o primeiro Documento, obtenho o erro:<\/p>\n<p>\u00abSqlConnection does not support parallel transactions.\u00bb<\/p>\n<p>try<\/p>\n<p>{<\/p>\n<p>ProductContext.Plataforma.IniciaTransaccao();<\/p>\n<p>&nbsp;<\/p>\n<p>ProductContext.MotorLE.Compras.Documentos.Actualiza(&#8230;)<\/p>\n<p>&nbsp;<\/p>\n<p>ProductContext.MotorLE.Vendas.Documentos.Actualiza(&#8230;)<\/p>\n<p>&nbsp;<\/p>\n<p>ProductContext.Plataforma.TerminaTransaccao();<\/p>\n<p>}<\/p>\n<p>catch()<\/p>\n<p>{<\/p>\n<p>ProductContext.Plataforma.DesfazTransaccao();<\/p>\n<p>}<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pretendo garantir a cria\u00e7\u00e3o de dois Documentos dentro do mesmo pedido \u00e1 WebAPI atraves do controlo de transa\u00e7\u00f5es. Acontece que ao executar o primeiro Atualiza para gravar o primeiro Documento, obtenho o erro: \u00abSqlConnection does not support parallel transactions.\u00bb try { ProductContext.Plataforma.IniciaTransaccao(); &nbsp; ProductContext.MotorLE.Compras.Documentos.Actualiza(&#8230;) &nbsp; ProductContext.MotorLE.Vendas.Documentos.Actualiza(&#8230;) &nbsp; ProductContext.Plataforma.TerminaTransaccao(); } catch() { ProductContext.Plataforma.DesfazTransaccao(); }<\/p>\n","protected":false},"author":1135,"featured_media":0,"template":"","tags":[],"cma_category":[],"cma_difficulty_level":[],"forum-tag":[374],"class_list":["post-23942","cma_thread","type-cma_thread","status-publish","hentry","forum-tag-v10-en","forum-languages-pt"],"_links":{"self":[{"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/cma_thread\/23942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/cma_thread"}],"about":[{"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/types\/cma_thread"}],"author":[{"embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/users\/1135"}],"wp:attachment":[{"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/media?parent=23942"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/tags?post=23942"},{"taxonomy":"cma_category","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/cma_category?post=23942"},{"taxonomy":"cma_difficulty_level","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/cma_difficulty_level?post=23942"},{"taxonomy":"forum-tag","embeddable":true,"href":"https:\/\/developers.ila.cegid.com\/es\/wp-json\/wp\/v2\/forum-tag?post=23942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}