Tips when using ADO.NET to access data in a SQL Server database
Alberto Poblacion
C# MVP
Alberto has been working for the computer industry for more than 27 years, most of them as a software developer. He has held just about every possible position in software development up to and including being the CSA for a small ISV. Currently he works as a freelance developer and consultant, as well as providing training as a Microsoft Certified Trainer, mostly on the field of software development under the .NET platform.
Here are collection of articles from campusMVP.Net for those developers that are quite familiar with ADO.NET. Basic techniques such as using typed or untyped DataSets, filling them by means of DataAdapters, or reading data by means of a DataReader are continually used in the data layer of business applications.
Of course, there are plenty of developers who never get to see the internals of the data layer. There is someone else in the team who develops the code in this layer, and other developers merely make calls into its public methods without ever having to know how the data is physically accessed. However, someone has to write the data access code so that the rest of the team can use it.
This collection is devoted to developers who write data access code. We provide a few tips were we present some techniques that, in our experience, are not always well known by the developers who use ADO.NET in their day-to-day coding activity.
Issues using multiple active record sets
-
ADO.NET: issues using multiple active record sets
ADO.NET: issues using multiple active record sets, Mars solution
Importing Large Amounts of Data
-
Importing Large Amounts of Data: introduction
Importing Large Amounts of Data: the problem
Importing Large Amounts of Data: solution
Importing Large Amounts of Data: further improvement
Importing Large Amounts of Data: mapping columns
Using Asynchronous Server Calls
-
Using Asynchronous Server Calls: introduction
Using Asynchronous Server Calls: the problem
Using Asynchronous Server Calls: launching a thread
Using Asynchronous Server Calls: using the ThreadPool
Using Asynchronous Server Calls: asynchronous delegates
Using Asynchronous Server Calls: asynchronous ADO.NET methods
Using Asynchronous Server Calls: backgroundWorker
Using Asynchronous Server Calls: the task class
SQL Injection Attacks
Efficiently accessing large objects in the database
-
Efficiently accessing large objects in the database: introduction
Efficiently accessing large objects in the database: reading LOBs from a database
Efficiently accessing large objects in the database: writing LOBs to a database
