ADO.NET Database Programming (HTML Format) Course Description and tutorial

COURSE DESCRIPTION:

The Visual Basic programming language is used to teach business computer programming using a visual programming approach; includes fundamental programming principles for event-driven programming.

REQUIRED TEXTBOOK:

Murach's ADO.NET 3.5 LINQ and the Entity Framework with VB 2008, by Anne Boehm, Mike Murach & Associates, Inc. (2009), ISBN-13: 978-1-890774-52-3.

COURSE OBJECTIVES:

§ Background concepts and terminology for the ADO.NET class objects used to develop a database application, and a review of relational database principles such as how to query an individual table and multiple tables, how to create views, and how to create stored procedures.

§ ADO.NET 3.5 including the data providers used to connect to a database, how a dataset that stores data on a client computer is organized, and how applications including typical business class objects are structured.

§ Using the Data Source Configuration Wizard to configure sources of data and to create datasets.

§ How to create data bound controls and display data to these controls through the use of parameter queries. For example, you will learn to display book information based on a book ISBN key value where the key value is specified at runtime.

§ Use the DataSet Designer to visually program a dataset schema and to preview data to be displayed by a query.

§ How to build a three-layer Windows forms application that includes the presentation, business, and database layers and associated class objects for each layer. How to make applications easier to test, debug, and maintain with a three-layer approach.

§ Managing transactions – imagine processing a customer book order – halfway through the processing the customer changes his/her mind and cancels the order – you'll learn how to manage this type of transaction to ensure that data integrity is maintained.

§ How to work with object data sources to provide you complete control over the way that your program's data access code works.

§ How a complete Vendor Data Entry system works. This includes working with the following common business tables and objects: Vendor, Payable, Invoice, Product (line item), and General Ledger Account.

§ An introduction to LINQ and how to use LINQ to Dataset.

§ Creating a deployable install program

COURSE SCHEDULE AND COMPUTER PROJECT ASSIGNMENTS

Class notes and PowerPoint slides are provided through hyperlinks. You may wish to print a copy of the notes/slides prior to class for reference during class.

Week 1 (week of May 26)

• How to obtain your personal copy of Visual Studio, or Visual Basic Express, or Visual Web Developer Express.
• Obtain the files that are downloadable for the textbook from Murach Publishing by copying the file named dvb8_allfiles.exe from the drive Y: server.
• Module 0: Object Oriented Programming

Week 2 (week of June 2)

• Chapter 1: An introduction to database programming
• Attaching Sql Server Database Files with Sql Server Management Studio (PowerPoint Slides)
• How to Configure SQL Server 2005 to Allow Remote Connections
• Chapter 2: An introduction to ADO.NET (PowerPoint Slides)
• Chapter 3: How to work with data sources and datasets
• Project 1-Oop due. Project 1 Grading Form.

Week 3 (week of June 9)

• Chapter 4: How to work with bound controls and parameterized queries
• Projects Document – a description of Projects for this term.
• CMIS6 Server Connection Strings
• Begin Project 2AB. This project requires you to read the introductory material in the Projects Document link. You will complete and submit Project 2-A and 2-B listed in the Projects document. Name your project Project2AB-LastName-FirstName where you replace LastName-FirstName with your own LastName and FirstName.

Week 4 (week of June 16)

• Chapter 5: How to use the Dataset Designer
• Submit Project 2AB. Project 2AB Grading Form.
• Begin Project 2C. This project requires you to complete and submit Project 2-C listed in the Projects document. Name your projectProject2C-LastName-FirstName where you replace LastName-FirstName with your own LastName and FirstName.

Week 5 (week of June 23)

• Chapter 6: How to work with connections, commands, and data readers
• Submit Project 2C. Project 2C Grading Form.
• Begin Project 3AB. This project requires you to complete Project 3-A and 3-B listed in the Projects document. Name your projectProject3AB-LastName-FirstName where you replace LastName-FirstName with your own LastName and FirstName.

Week 6 (week of June 30)

• Chapter 7: How to work with parameters and stored procedures

Week 7 (week of July 7)

• Chapter 8: How to work with transactions
• Submit Project 3AB. Project 3AB Grading Form.

Week 8 (week of July 14)

• Chapter 9: How to work with object data sources
• Chapter 10: A complete Payable Entry application – study this chapter on your own – we will not work through the chapter in class.
• Begin Project 3CD. This project requires you to complete Project 3-D listed in the Projects document. Graduate student requirement: Graduate students must also complete Project 3-C listed in the Projects document. All students (regardless of undergraduate or graduate) shall name the project Project3CD-LastName-FirstName where you replace LastName-FirstName with your own LastName and FirstName.

Week 9 (week of July 21)

• Chapter 11: An introduction to LINQ
• Chapter 12: How to use LINQ to DataSet

• Begin Project 4AB. This project requires you to complete Project 4-A and 4-B listed in the Projects document. Name your projectProject4AB-LastName-FirstName where you replace LastName-FirstName with your own LastName and FirstName.
• Submit Project 3CD. Project 3CD Grading Form.

Week 10 (week of July 28)

Module 1: Deploying a Windows Forms Application – this module is presented so that you will have a basic understanding of the creation of a deployment project.