ADO.NET Database Programming (HTML Format)

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: 

1. 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
2. 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.
3. Using the Data Source Configuration Wizard to configure sources of data and to create data sets.
4.  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.
5.  Use the DataSet Designer to visually program a dataset schema and to preview data to be displayed by a query.
6.  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.
7.  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.
8.  How to work with object data sources to provide you complete control over the way that your program's data access code works.
9.  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. 
10.  An introduction to LINQ and how to use LINQ to Dataset.
11.  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.