Chapter 13. Databases

IN THIS CHAPTER

• Create a New Database in Visual Studio

• Connect and Retrieve Data

• Insert Data into a Database Table

• Delete Data from a Table

• Run a Stored Procedure

• Use Transactions

• Bind Data to a Control Using a DataSet

• Detect if Database Connection Is Available

• Automatically Map Data to Objects with the Entity Framework

Most applications deal with data in some manner. Often, such data resides in a relational database such as SQL Server, Oracle, or MySQL (among many others).

This chapter covers some of the basics of database access from .NET. If you do not have a database to play around with, I recommend either SQL Server Express Edition or MySql Community Edition, either of which can be found via your ...

Get C# 4.0 How-To now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial