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)
Week 2 (week of June 2)
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)

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)
  • 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. 

No comments: