What happens when you close an Entity Framework connection

Posted by Shiraz Bhaiji on Stack Overflow See other posts from Stack Overflow or by Shiraz Bhaiji
Published on 2010-04-14T11:13:54Z Indexed on 2010/04/14 11:43 UTC
Read the original article Hit count: 396

Filed under:

entity-framework

|

database-connection

|

connection-pooling

We are using Entity Framework 1.0.

In some cases we need to explicitly open connections, and then need to explicitly close connections. See http://msdn.microsoft.com/en-us/library/bb738582.aspx

My question is, when we call "close" does the connection actually get closed, or is it just returned to the connection pool?

© Stack Overflow or respective owner

Related posts about entity-framework

Differences Between NHibernate and Entity Framework

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction NHibernate and Entity Framework are two of the most popular O/RM frameworks on the .NET world. Although they share some functionality, there are some aspects on which they are quite different. This post will describe this differences and will hopefully help you get started with the one… >>> More
Entity Framework & Binding syncronisation

as seen on Stack Overflow - Search for 'Stack Overflow'
* EDIT * Sorry, I should make it clearer. Imagine I have an entity: public class MyObject { public string Name { get; set; } } And I have a ListBox: <ListBox x:Name="lbParts"> <ListBox.ItemTemplate> <DataTemplate> <TextBlock Text="{Binding Name}"/> … >>> More
Joins and UI Binding with the Entity Framework

as seen on Internet.com - Search for 'Internet.com'
Learn how to build queries with the Entity Framework that involve multiple tables as well as binding in the UI with the EntityDataSource. >>> More
Frederick .NET User Group April 2010 Meeting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
FredNUG is pleased to announce that we have an excellent speaker lined up for April. On April 20th, we’ll start with pizza and social networking at 6:30 PM. Then, starting at 7 PM, Dane Morgridge will present “Getting Started with Entity Framework 4” The scheduled agenda is: 6:30 PM - 7:00… >>> More
[News] NHibernate vs MS Entity Framework

as seen on Dot Net Guru - Search for 'Dot Net Guru'
Voil? une question qui se posera de plus en plus avec la sortie prochaine de .NET V4 et Entity Framework V4, l'outil de mapping objet/relationnel de Microsoft. M?me s'il est vrai que l'opinion de Ayende peut para?tre biais?e du fait qu'il est contributeur NHibernate, son point de vue et surtout ses… >>> More

Related posts about database-connection

Why are there connections open to my databases?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a program that stores user projects as databases. Naturally, the program should allow the user to create and delete the databases as they need to. When the program boots up, it looks for all the databases in a specific SQLServer instance that have the structure the program is expecting. … >>> More
slow Database connection

as seen on Stack Overflow - Search for 'Stack Overflow'
i am working with Windows Applications in c# with MySQL database using wamp server. i have very slow connection when executing the project.what is problem in it and how can i solve this? >>> More
PHP forking and mysql database connection problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I am now trying to do forking in php. I would like to do some query and update in child process.. the problem is that whenever a child process finish, it close the connection which makes the other queries fail. The following is my sample code!! #!/usr/local/bin/php <?php set_time_limit(0); # forever… >>> More
sql database connection on remote server

as seen on Stack Overflow - Search for 'Stack Overflow'
i create my web site on asp.net and i create database in sql using inbuilt it in visual studio i use step to create database 1.right click on solution explorer then add newSqldatabase then ok then if i connect it by coding then it will work on my local PC but actuall i am making website so i want… >>> More
PHP: Proper way of using a PDO database connection in a class

as seen on Stack Overflow - Search for 'Stack Overflow'
Trying to organize all my code into classes, and I can't get the database queries to work inside a class. I tested it without the class wrapper, and it worked fine. Inside the class = no dice. What about my classes is messing this up? class ac { public function dbConnect() { global $dbcon; … >>> More