Disposing Database context with using statement in MVC

Question

I'm using entity framework in my MVC website and I'm disposing my database context using using-statement. Now my question is if I close using statement after return, would the database context disposed properly or not. Ex:

 public ActionResult SomeAction(){

      using (var DB = new DatabaseContext()){

       ....           

       return View();                
      }
 }

Do I have to close the using statement before return? Or it would be disposed properly in the way I'm using it.

This should help you : stackoverflow.com/questions/5381747/… — user2339071
– user2339071, Commented Sep 1, 2013 at 9:12
What you have is good. stackoverflow.com/questions/6356307/… and stackoverflow.com/questions/7254815/… — Ed Chapel
– Ed Chapel, Commented Sep 1, 2013 at 9:15

Community · Accepted Answer · 2017-05-23 12:20:25Z

1

Do I have to close the using statement before return? Or it would be disposed properly in the way I'm using it?

It will be automagically disposed for you. You can refer to this answer for more information .The Dispose method is called however the using statement is executed, unless it was an abrupt whole-process termination. The most common cases are:

A return within the block
An exception being thrown (and not caught) within the block
Reaching the end of the block naturally

Basically a using statement is mostly syntactic sugar for a try/finally block - and finally has all the same properties.

From section 8.13 of the C# 4 specification:

A using statement is stranslated into three parts: acquisition, usage, and disposal. Usage of the resource is implicitly enclosed in a try statement that includes a finally clause. This finally clause disposes of the resource.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Sep 1, 2013 at 9:25

Bhushan Firake

9,4825 gold badges47 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Over a year ago

Based on your common cases if we have return within using statement it won't be disposed?

Collectives™ on Stack Overflow

Disposing Database context with using statement in MVC

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related