O'Reilly logo

.NET Framework 4.5 Expert Programming Cookbook by A.P. Rajshekhar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. ADO.NET Recipes

In this chapter we will cover:

  • Saving large files (BLOB) in MS SQL Server using ADO.NET
  • Retrieving large files (BLOB) from MS SQL Server using ADO.NET
  • Using transactions to maintain database consistency when saving multiple files
  • Using DataSet to modify custom XML configuration files

Introduction

This chapter will focus on recipes that deal with ADO.NET, which is the basis for all database-based operations in .NET. We will start with saving files of large size in SQL Server. The next recipe will tell you how to retrieve the saved file. The third recipe will focus on implementing transactions. The last recipe will be about using DataSet to operate upon XML data.

Please keep in mind that the recipes in this chapter use MS SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required