ADO.NET Database Programming (HTML Format)

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.