﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-舊歡銣儚-最新评论</title><link>http://www.cnblogs.com/hgamezoom/CommentsRSS.aspx</link><description /><language>zh-cn</language><pubDate>Wed, 14 Jul 2010 08:29:50 GMT</pubDate><lastBuildDate>Wed, 14 Jul 2010 08:29:50 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871829</link><dc:creator>小白.net</dc:creator><author>小白.net</author><pubDate>Thu, 15 Jul 2010 03:26:16 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871829</guid><description><![CDATA[@锦瑟无端五十弦

谢谢
顺便请教下楼主条用存储过程如果返回多个结果集
EF4的复杂类型只能判断出第一个返回的表
这个如何处理

我用的EF4
<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">小白.net</a> 2010-07-15 11:26 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871829#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871824</link><dc:creator>锦瑟无端五十弦</dc:creator><author>锦瑟无端五十弦</author><pubDate>Thu, 15 Jul 2010 03:22:45 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871824</guid><description><![CDATA[@韦恩卑鄙 v-zhewg @waynebaby


有一个问题，在开启TransactionScope之后，如果接下来的代码中没有显式的open connection的代码，而是直接进行数据操作（即使是同一个Context），就会抛出需要开启MSDTC的异常，而如果加了open connection，则运行正常。你知不知这是什么道理？

<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">锦瑟无端五十弦</a> 2010-07-15 11:22 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871824#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871817</link><dc:creator>锦瑟无端五十弦</dc:creator><author>锦瑟无端五十弦</author><pubDate>Thu, 15 Jul 2010 03:19:50 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871817</guid><description><![CDATA[@小白.net

你需要下载EF Extension并添加引用,可以google一把。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">锦瑟无端五十弦</a> 2010-07-15 11:19 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/15/1777227.html#1871817#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871551</link><dc:creator>小白.net</dc:creator><author>小白.net</author><pubDate>Wed, 14 Jul 2010 15:53:31 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871551</guid><description><![CDATA[    using (t.Connection.CreateConnectionScope())// EF Extension中的扩展方法，作用是open connection并在dispose里释放它


这个方法我怎么没有<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">小白.net</a> 2010-07-14 23:53 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871551#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871317</link><dc:creator>张磊_larry.zhang</dc:creator><author>张磊_larry.zhang</author><pubDate>Wed, 14 Jul 2010 09:09:21 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871317</guid><description><![CDATA[用4.0吧,完全支持T-SQL,反正EF是在服务端的<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">张磊_larry.zhang</a> 2010-07-14 17:09 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871317#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871310</link><dc:creator>Assion Yang</dc:creator><author>Assion Yang</author><pubDate>Wed, 14 Jul 2010 09:03:34 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871310</guid><description><![CDATA[@韦恩卑鄙 v-zhewg @waynebaby
不敢不敢，我也是个人感觉。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">Assion Yang</a> 2010-07-14 17:03 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871310#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871304</link><dc:creator>韦恩卑鄙 v-zhewg @waynebaby</dc:creator><author>韦恩卑鄙 v-zhewg @waynebaby</author><pubDate>Wed, 14 Jul 2010 09:01:51 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871304</guid><description><![CDATA[@Assion Yang
[quote]Assion Yang：
@韦恩卑鄙 v-zhewg @waynebaby
人个感觉不敢保证是同一connection[/quote]
我看了下源代码 
在EF 4.0里面
一次savechange 
一次exec sp
和一次execfunction  
都会从连接池里面拿出一个连接来  

感谢指出问题  长知识了




<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">韦恩卑鄙 v-zhewg @waynebaby</a> 2010-07-14 17:01 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871304#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871289</link><dc:creator>Assion Yang</dc:creator><author>Assion Yang</author><pubDate>Wed, 14 Jul 2010 08:48:48 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871289</guid><description><![CDATA[@韦恩卑鄙 v-zhewg @waynebaby
人个感觉不敢保证是同一connection<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">Assion Yang</a> 2010-07-14 16:48 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871289#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871286</link><dc:creator>金色海洋（jyk）</dc:creator><author>金色海洋（jyk）</author><pubDate>Wed, 14 Jul 2010 08:44:47 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871286</guid><description><![CDATA[自己写，舒心。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">金色海洋（jyk）</a> 2010-07-14 16:44 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871286#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Entity Framework中的事务问题</title><link>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871282</link><dc:creator>韦恩卑鄙 v-zhewg @waynebaby</dc:creator><author>韦恩卑鄙 v-zhewg @waynebaby</author><pubDate>Wed, 14 Jul 2010 08:42:37 GMT</pubDate><guid>http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871282</guid><description><![CDATA[[quote]温景良(Jason)：
[quote]韦恩卑鄙 v-zhewg @waynebaby：
不需要 如果是同一个sqlconnection的话  自动调用sql 连接层的trans
不需要任何外部支持

如果是跨数据库的或者跨连接的，甚至跨服务的  
TS会自动调用msdtc
你只要保证你的msdtc 服务开着 一般就可以了
万一中的万一 ，出错了可以再找资料 我帮你找呵呵[/quote]
有个问题啊,如果在里面执行多条语句,数据层的连接是采用dispose(),这样会判断是同一个连接吗[/quote]

只要context 不dispose  连接就还是同一个。

补充 看来是错的

只要是一次execute 就是同一个。。。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/hgamezoom/" target="_blank">韦恩卑鄙 v-zhewg @waynebaby</a> 2010-07-14 16:42 <a href="http://www.cnblogs.com/hgamezoom/archive/2010/07/14/1777227.html#1871282#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
