Intermediate C# Programming

• Review of basic exception handling (try .. catch .. finally)
• The Exception Class
• Catching the Exception instance
• The Exception Message
• Derived Exception Classes
• FormatException
• OverflowException
• IndexOutOfRangeException
• DivideByZeroException
• Catching Multiple Exceptions
• Exception Nesting
• Throwing an Exception
• Passing a message to the Exception class
• Throwing an exception, passing part of a message as an argument
• Custom Exceptions
• Defining Custom Exceptions
• Throwing custom Exceptions

• Creating an abstract class
• Members of an abstract class
• Concrete and abstract properties
• Concrete and abstract methods

• What is an interface?
• Interface rules
• Inheriting from an interface
• Creating an interface
• Properties of an interface
• Methods in an interface
• Basing a class on an interface
• Basing an interface on an interface
• Multiple inheritance
• Interfaces as variable or parameter data types
• The IComparable Interface

• LINQ (Language INtegrated Query)
• Example LINQ query
• How LINQ works
• LINQ query syntax
• The query variable
• The from clause
• The select clause
• Returning a customised data type
• The where clause
• The orderbyclause
• The group clause
• The Single method
• Aggregate functions
• Aggregate functions where no arguments are required
• Lambda Expressions
• Example: Lambda Expressions requiring only one line of code

• XML and .NET
• The System.Xmlnamespace
• Using XmlReader to read XML
• Using XmlWriter to create XML
• Using the DOM
• Using XmlDocument
• Using XmlDocument to create a new document
• Using XmlDocument to create a document from a file
• The GetElementsByTagNamemethod
• The SelectNodes method
• Modifying an XML document
• Serialising objects into XML
• Default XML layout
• Customising the default XML layout
• Modifying XML output without access to the class code
• Deserialising XML to an object
• LINQ and XML
• Example: creating XML with Linq

• What is reflection?
• The Type type
• Getting the Type of a class or object
• Using reflection to find out if a class is abstract or sealed
• Viewing a type’s properties and methods
• Other uses of reflection
• Custom attributes
• Uses of custom attributes
• Creating custom attributes
• Adding custom attributes to a class
• Viewing the custom attributes of a class
• Adding attribute properties
• Adding attribute constructors
• Viewing more details about the attributes

• What are Indexers?
• Syntax: Declaring an Indexer
• Example: Class with an indexer
• Using indexers
• Overloaded Indexers
• Example: class with overloaded indexers

• What is ADO.NET?
• ADO.NET namespaces
• High level data access process
• Creating a connection object
• Storing connection strings in config files
• Command objects
• CommandType and CommandText
• Command object methods
• Disposing of resources
• The using statement
• ExecuteNonQuery
• ExecuteScalar
• ExecuteReader
• Data readers
• Command parameters
• Adding parameters to commands

• The DataTable Object
• The DataColumn object
• The DataRow object
• Manually creating and filling a datatable
• The Rows collection
• The Columns collection
• The DataSet object
• Data adapters
• Data adapter properties
• Working with data locally
• Filling a DataTable with a data adapter

• Generics
• Collections
• Delegates
• Lambda expressions

Please note this will be at the discretion of the instructor, it is not guaranteed that you will cover these final subjects