one database connection object in asp.net mvc model

Question

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?

womp · Accepted Answer · 2010-01-21 23:42:31Z

3

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?

answered Jan 21, 2010 at 23:42

womp

117k27 gold badges240 silver badges271 bronze badges

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

3 Comments

womp Over a year ago

Yes. You can read up on it in many places - here's one link: aspalliance.com/1099_Understanding_Connection_Pooling_in_NET

U62 Over a year ago

You shouldn't be managing transactions in your controller code. If you're doing something that requires transactions, it should be abstracted into a seperate data access layer.

ANIL MANE Over a year ago

Can you suggest any example ?

Collectives™ on Stack Overflow

one database connection object in asp.net mvc model

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related