Entity framework and COM+

I have a problem using Entity Framework and COM+. The architecture is this:

• A windows service calls four methods of a COM, every n minutes.

• COM+ then calls the corresponding methods on a Business Layer.

• Business Layer calls DAL. DAL then returns a list to Business Layer. This is done by calling a .ToList()

When I try running the service, the DAL methods return a timeout inner exception. When I try to view the table from Enterprise Manager, it returns a timeout as well! From what I 've seen, the SELECT statements block the other connection instances.

Has anyone else experienced similar problems?

P.S. I cannot post any code yet because I am开发者_Python百科 not at my work... Will do so tomorrow.

---

Well, as it seems, Entity Framework didn't have to do with any of the above. As it turns out, the problem was within COM+. I should have ended each method of COM+ with ContextUtil.SetComplete(). Apparently, I didn't do that so the transaction stayed active and after the first few calls, it locked my db.

e.g.

Using MyEntity As New EntityObject
  MyEntity.Connection.Open()
   Dim rows = From tbl In MyEntity.MyTable _
              Select tbl
   list = rows.ToList
End Using

ContextUtil.SetComplete()

Please note that if an exception occurs, you should place a ContextUtil.SetAbort(). I should also like to note that the above code is mixed. It's part of my DAL layer and part of my COM+. I just put it like that to make the example more clear...