If you aren't new to .NET development you will be aware that there are several different ways to access and manipulate database data. New developers always use the build in Visual Studio features such as SqlDataSource or EntityDataSource. These are very helpful features coming from .NET Framework allowing you to access your database with just a few clicks and let's be honest, they do work fine. Other developers prefer to use LINQ in the way we have seen in previous posts. All these techniques for sure let you access your data, writing less code and making less mistakes, since they use strongly data types. What you might aren't aware of, is that all these features have a drawback: most of their actions/commands are converted sometime in native ADO.NET code before they are actually executed. In other words, what you gain in simplifying code writing, you loose in performance since all commands have to be translated in lower lever code before executed. You might haven't seen this drawback in simple transactions with just a few data in your database but giving a try your code in a great amount of data trust me, you 'll get the filling. This post, as it's title says is a brief introduction to ADO.NET Framework. If you need to boost your application's performance while accessing great amount of data, ADO.NET is what you need to use. I personally believe that using ADO.NET is so important that I created a separate category for this feature in my blog. There will be a lot of other posts relating to ADO.NET so stay in touch if you want to get the most of that.


I guess you came to this post by searching similar kind of issues in any of the search engine and hope that this resolved your problem. If you find this tips useful, just drop a line below and share the link to others and who knows they might find it useful too.

Stay tuned to my blog, twitter or facebook to read more articles, tutorials, news, tips & tricks on various technology fields. Also Subscribe to our Newsletter with your Email ID to keep you updated on latest posts. We will send newsletter to your registered email address. We will not share your email address to anybody as we respect privacy.

This article is related to

</ span>C#,.NET,Architect,Intermediate,VS2010,.Net,Articles,Computer Tutorials,ADO.NET