Join Percona’s, Architect, Manjot Singh as he presents Database Backup and Recovery Best Practices (with a Focus on MySQL) on Thursday, July 27, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7). In the case of a failure, do you know how long it will take to restore your database?
Course Of The Month
8 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
DB Server Connection Management with ADO.NET Connected Data Access
Posted on 2013-12-27
I am rewriting a 2006-era ASP.net application. To maintain high platform migrate-ability, one option that I am looking at is ADO.NET connected data access as described here:
http://msdn.microsoft.com/en-us/data/ff707264.aspx#_Toc261428884
Given that starting assumption, I am looking for additional information on how to manage server resources and connections in this approach.
Any guidance on this would be appreciated.
Thanks!
http://msdn.microsoft.com/en-us/data/ff707264.aspx#_Toc261428884
Given that starting assumption, I am looking for additional information on how to manage server resources and connections in this approach.
Any guidance on this would be appreciated.
Thanks!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
- +1
11 Comments
A few inputs here...
1) if you re-writing your application, then please consider the below
a) put all the database retrival stuff into a WCF and let it give the results, instead of actual ADO.NET
b) Ensure that the access is done through stored procedures or functions but not by direct select statemets.
By doing so, you will website will have an API for further improvement.
And also I would suggest you to take a look at the entity framework, which has more capability than just ADO.NET.
Hope this helps.
1) if you re-writing your application, then please consider the below
a) put all the database retrival stuff into a WCF and let it give the results, instead of actual ADO.NET
b) Ensure that the access is done through stored procedures or functions but not by direct select statemets.
By doing so, you will website will have an API for further improvement.
And also I would suggest you to take a look at the entity framework, which has more capability than just ADO.NET.
Hope this helps.
Thanks for the input. Those are worth consideration. Right now though, I'm looking for something more specifically related to my question, with the assumptions given.
Active 5 days ago
What version of Visual Studio .NET do you have?
What type of web site are you planning (MVC, Web Forms, OWIN/Katana, ...)?
Do you know about Entity Framework?
Hi,the article talks about two options, linq to SQL and entity framework. Which option you have opted for?
To manage resources in both above options, invoke dispose method on datacontext object to release the resources.
To manage resources in both above options, invoke dispose method on datacontext object to release the resources.
Thanks for the inputs. I'm using VS2013, MVC, and I know about EF.
The option I need to work out is "ADO.NET connected data access", the first option in the article.
The reason I'm going to work through this option first is that I want to maintain the lowest level of abstraction for both performance and migrate-ability.
While I appreciate the tip on the "dispose" method, I need to look at some contextual material on this to understand things like how many connections I'm going to have open, the cost of leaving connections open, the cost of opening and closing connections, etc.
I appreciate that EF resolves many of these questions, however, that's a different path that I won't pursue until I've more completely understood what it takes to manage ADO.NET connected data access.
The option I need to work out is "ADO.NET connected data access", the first option in the article.
The reason I'm going to work through this option first is that I want to maintain the lowest level of abstraction for both performance and migrate-ability.
While I appreciate the tip on the "dispose" method, I need to look at some contextual material on this to understand things like how many connections I'm going to have open, the cost of leaving connections open, the cost of opening and closing connections, etc.
I appreciate that EF resolves many of these questions, however, that's a different path that I won't pursue until I've more completely understood what it takes to manage ADO.NET connected data access.
http://forums.asp.net/t/932515.aspx
Apparently best practice for ASP net SQL connections is to open and close them frequently, and the rule is open late close early.
That's kind of what I was looking for; in essence you don't manage connections you just open them use them and close them.
Unless someone disagrees I'm going to go with that answer thanks.
Apparently best practice for ASP net SQL connections is to open and close them frequently, and the rule is open late close early.
That's kind of what I was looking for; in essence you don't manage connections you just open them use them and close them.
Unless someone disagrees I'm going to go with that answer thanks.
I've requested that this question be closed as follows:
Accepted answer: 0 points for codequest's comment #a39811181
for the following reason:
most accurate
Accepted answer: 0 points for codequest's comment #a39811181
for the following reason:
most accurate
I guess that is what I have also stating.
"To manage resources in both above options, invoke dispose method on datacontext object to release the resources."
"To manage resources in both above options, invoke dispose method on datacontext object to release the resources."
Featured Post
Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I have a large data set and a SSIS package. How can I load this file in multi threading?
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 17 hours left to enroll
615 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.