C# Programming

Weeks 7 - 8 In A Nutshell

As you may have noticed, we are not going to cover Chapter 18 in the text. Chapter 18 does cover

Databases and there is nothing wrong with you learning the content there. We are going to take the

programmatic approach to Databases, rather than Drag and Drop or LINQ.

The reading for Weeks 7 - 8 is a Database chapter from another well respected textbook. It was very

difficult to have copied, but we did our best. This reading is Chapter 15, so I will refer to it as Chapter

15.

You need to read the first four sections of Chapter 15, up through and including Section 15.4 Database

Information And Aggregate Functions. As you read Chapter 15, you will soon realize that it uses

Microsoft Access for the examples. For our class, we are going to use Microsoft SQL Server 2012

Express.

If you do not already have MS SQL Server 2012 Express installed, there is an Appendix under Week 7 - 8

Reading For The Week. This appendix has been verified to work. Be sure to follow all of the

instructions.

We will be using C# programming to create and manipulate our database. Under Support Materials, you

will find two zipped file, CreateDB.zip and ConsoleSalesDB.zip. These two files are working C# programs

that use MS SQL to create and manipulate the database. You should study these two programs

carefully. Remember, they are C# applications. When you unzip them, they will create all of the files

and directories normally found in a C# application.

CreateDB.zip is the MS SQL version of Example 15.2 Create.cs. In the reading, Example 15.2 Create.cs

uses Microsoft Access SQL. The CreateDB.zip file has been converted to use MS SQL Server 2012

Express. ConsoleSalesDB.zip is a modified and converted version of Example 15.3 ExtractInfo.cs.

The point of this is for you to be able to create and manipulate SQL databases using C#. Study Chapter

15 and the two example programs. You will need a good understanding of this material in order to do

the assignment for this week.