hippout
hippout

Reputation: 970

one database connection object in asp.net mvc model

I have asp.net mvc site, my action generate the page, using master page. on master page included widgets by RenderAction helper. How can i use one database connection in page controller and in widget controller?

Upvotes: 0

Views: 1272

Answers (1)

womp
womp

Reputation: 116977

Generally you shouldn't need to worry about this, because connection pooling will take care of it automatically. Just make sure to close your connections when you're done with them (best is to use the using {} block in your code, which will automatically close and dispose your connection).

If you really need to work off the same connection object for some reason, why not have all your controllers inherit from a base controller that exposes your connection object as a property?

Upvotes: 3

Related Questions