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 data sets.
- 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.
