This course will provide the student with practical knowledge of developing and implementing business related applications using the latest Microsoft coding innovations. Topics will include DDL, DML, host-based processing, designing complex queries, triggers, and extensive coverage of ADO.NET. Along with the coverage of database access using Relational and Non-relational database(s), these topics will be covered: XML and XML integration with ADO.NET. The course will use Visual Studio .NET to build Advanced Windows Applications.
Note: For CSIS programs, students can receive credit for one of: CISY 3540/CSIS 3540 or CSIS 4050.
1. Design Pattern
- MVC, MVVM, and/or a more current pattern used in the industry
2. Object-oriented programming using Visual C#
- Using Visual Studio
- Basic syntax and control flow
- Classes, Polymorphism and Inheritance
- Arrays and Lists
- Building GUI with
- Windows Form, Windows Platform Foundation, or any currently used UI approached
- Event Handling
- Database Programming and ADO.NET
- Performing CRUD to different data sources such as
- Entity Framework
Means of Assessment
Evaluation will be carried out in accordance with the Douglas College Evaluation Policy.
Means of Assessment
Labs/Assignments 10% - 15%
Project 15% - 25%
Midterm Examination* 30% - 35%
Final Examination* 30% - 40%
*In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).
The successful student will be able to:
- Construct complex queries, set operators, and user-defined stored procedures
- Demonstrate the use of a Visual Studio .NET and a design pattern to build applications
- Demonstrate the use of ADO.NET within the application
- Describe ADO data providers, datasets, data adapters, connections
- Explain the basic concepts of reading/writing XML/XAML
- Explain how XML is incorporated in the .NET environment
- Demonstrate the use of Relational database and NoSQL incorporated with Visual Studio .NET
Instructor will prepare course reference material
other textbook(s) as approved by the department