A. Overview of ADO.NET, the data-access component of the Microsoft .NET Framework
B. How ADO.NET works with almost any component on nearly every platform that understands XML.

5/9/2007 Duration: 63 minutes

A. Creating Connections
B. Connection Properites
C. Methods for manipulating connections
D. Handling events raised by connections

5/16/2007 Duration: 53 minutes

A. DataReaderallows one to retrieve recordsets from databases
B. How to manipulate the data with commands (Select, Update, Delete, Insert)

5/23/2007 Duration: 65 minutes

A. How the DataAdapter facilitates the communication between the DataSet and the database. B. How the DataSet provides methods to select, insert, update, and delete data

5/30/2007 Duration: 64 minutes

A. Create a transaction
B. Create a nested transaction
C. Commit transactions
D. Rollback transactions

6/06/07 Duration: 53 minutes

A. Create DataSets
B. Add DataTables and DataRelations to DataSets
C. How to clone and copy DataSets.

6/13/2007 Duration: 57 minutes

A. Structure of DataTables
B. Properties of DataTables
C. Methods of DataTables.

6/20/2007 Duration: 58 minutes

A. How to build a TableAdapter class and a TableAdapter object, and  how to configure them.

6/27/2007 Duration: 59 minutes

A. How the DataView can help you filter and sort DataRows at design time
B. How you can add a DataView to a form

7/05/2007 Duration: 55 minutes

A. Editing and updating data using DataViews, TableAdapters, DataTables, and DataSets.

7/11/2007 Duration: 65 minutes

A. Bind data to your Windows Forms
B. How to bind controls to ADO.NET data sources.
C.BindingSource class, new in ADO.NET version 2.0, which acts as an intermediary between a data source and Windows Forms controls to simplify and extend the data-binding process.

7/18/2007 Duration: 66 minutes

A. Binding data to format it
B. Displaying bound data
C. Data-Binding events

7/25/2007 Duration: 63 minutes

A. Binding data in Microsoft ASP.NET and Web Forms with ADO.NET objects
B. Data source controls, new to the Microsoft .NET Framework version 2.0, that enable data binding with very little code.

8/1/2007 Duration: 65 minutes

A. The data-bound Web Form controls that are designed to work with the Microsoft .NET version 2.0 data source controls that also work with ADO.NET objects.

8/08/2007 Duration: 63 minutes

A. Interaction between ADO.NET and XML.
B. Structure of an XML schema and the DataSet methods that enable us to read and write data from an XML data stream.
C. The XmlDataDocument that provides an XML view of the data in a DataSet.

9/05/2007 Duration: 70 minutes

A. Some real-world uses of ADO.NET.
B. How you can work with data objects created with previous versions of ActiveX Data Objects (ADO)
C. Microsoft ActiveX Data Objects Extensions for Data Definition Language (DDL) and Security (ADOX) library.

8/22/2007 Duration: 55 minutes

A. How a .NET program executes
B. CLR (Common Language Runtime) and Framework Class Library
C. Comparison of the CLR to Java's JVM
D. In 2.0, the registry is no longer used to indicate where the assemblies reside.  Instead, a technique that is similar to the PATH verb in DOS is used.
E. The system searches in this order:
..1) the GAC,
..2) in any places indicated by the config file, and
..3) the folder where the executable for the VB program resides is searched.

02/03/2004 Duration: 2 hours and 4 minutes

A. When we create an object, we are really just creating a variable that has a reference to an object.
B. Comparison of which types in .NET are value types and which are object.
C. garbage collection

02/10/2004 Duration: 1 hour and 58 minutes

A. Classes
B. Class Libraries

02/17/2004 Duration: 1 hour and 53 minutes

A. GUI

02/26/2004 Duration: 1 hour and 21 minutes

A. Exception handling;
B. Application and class design with exceptions;
C. Assertions;
D. Debugging

03/02/2004 Duration: 1 hour and 30 minutes

A. Basic relational database design;
B. Local databases vs. database servers;
C. Structured Query Language;
D. Stored procedures

03/16/2004 Duration: 1 hour and 30 minutes

A. Architecture of ADO.NET;
B. ExecuteReader;
C. ExecuteScalar;
D. ExecuteNonquery;
E. DataSets

3/23/2004 Duration: 1 hour and 30 minutes

A. Contract-based programming and design reuse;
B. Example redesigned data access class with interfaces & factory methods;
C. Implementing interfaces sorting, serialization;
D. More examples: interfaces in the Framework Class Library;
E. Creating your own interfaces

3/31/2004 Duration: 1 hour and 30 minutes

A. Implementation and design reuse;
B. Example: custom, type-safe collection class;
C. Other examples: WinForms hierarchy, .NET CTS, data structure classes;
D. Creating your own inheritance hierarchy business objects

4/06/2004 Duration: 1 hour and 30 minutes

A. Design decisions;
B. Leave connection open vs. open/close, and the Finalization pattern;
C. Exception handling, Try-Catch-Finally pattern, custom exception class hierarchy;
D. Abstract Factory pattern;
E. Transactions;
F. Data vs. business objects;
G. Multi-tier design

4/15/2004 Duration: 1 hour and 30 minutes

A. Assemblies, namespaces, DLLs;
B. Assembly resolution;
C. Strong names, version-ing;
D. Deployment;
E. Obfuscation

4/20/2004 Duration: 1 hour and 30 minutes

A. Tracing;
B. Configuration files (read-only!);
C. User preferences via object serialization, XML file, or per user settings in .NET;
D. Application designs - Traditional single-user applications, Remote: client-server & multi-tier, Loosely-coupled event & delegate driven;
E. Deployment options: Traditional install-driven, Zero-touch deployment: via IE & App loader

4/28/2004 Duration: 1 hour and 30 minutes

A. Remote procedure calls, proxy-stub architecture;
B. Reflection: dynamic loading, instantiation & execution;
C. Remoting;
D. Web services;
E. WebForms

5/4/2004 Duration: 1 hour and 30 minutes

A. When to use concurrent programming techniques;
B. Delegates;
C. Pure multi-threading;
D. Caution - multi-threading is complicated

5/11/2004 Duration: 1 hour and 30 minutes

A. Application blocks;
B. Best practices;
C. Design patterns;
D. UML;
E. Testing, testing, testing;
F. Tools CVS, Nunit, NMake;
G. Working with Visual Studio® on a large, component-based project;
H. eXtreme Programming (XP)

5/18/2004 Duration: 1 hour and 30 minutes

This is the first webcast in the series entitled "Architecting Modern Desktop Applications in .NET", appropriate for the intermediate or advanced Microsoft Visual Studio .NET developer. This webcast discusses the concepts of smart client development, and the appropriate N-tier design for such applications.   112 minutes 8/23/05

This is the second webcast in the series on architecting desktop applications with the Microsoft .NET Framework. Joe Hummel focuses on common design patterns for sophisticated graphical user interface-based applications, including the Model-View-Controller pattern and the User Interface Process block from Microsoft.  111 minutes 9/06/2005

This is the third webcast in the series on designing desktop applications with the Microsoft .NET Framework. This webcast focuses on the architecture and design of dynamic and configurable applications. Topics include proper use of .NET configuration files, storing connection strings and user settings, the Microsoft patterns & practices Enterprise Library Configuration Application Block, and building applications whose user interface is dynamically configurable.  96 minutes 9/27/05

This is the fourth webcast in the series on architecting desktop applications with the Microsoft .NET Framework. This webcast focuses on the major issues, various solutions, and trade-offs involved in designing secure desktop applications. Topics include authentication, authorization, securing configuration and user settings, and the Microsoft patterns & practices Enterprise Library Security Application Block . 113 minutes 10/11/05

This is the fifth webcast in the series on architecting desktop applications with the Microsoft .NET Framework. This webcast focuses on designing the business tier, including discussions of tools such as Component-based, Scalable, Logical Architecture.NET, an open-source programming framework, and Object Role Modeling, which eases the burden of creating fully object-oriented business tiers.  107 minutes 10/25/05

This sixth session in the series on designing desktop applications with the Microsoft .NET Framework 2.0 discusses the design of the Data Access tier. Joe Hummel covers the Microsoft patterns & practices Data Access Application Block, and discuss new features in Microsoft ADO.NET 2.0. Joe Hummel looks at how to use Object Role Modeling tools to create data access tiers automatically.  106 minutes 11/08/05

This is the seventh webcast in the series on Microsoft .NET Framework 2.0 desktop application architecture. This webcast outlines best practices for developing N-tier applications, including exception handling, logging, instrumentation and documentation. Joe Hummel looks at the Exception Handling, Logging and Instrumentation Application Blocks from the Microsoft patterns & practices team. 111 minutes 11/22/05

In this eighth webcast in the series on Microsoft .NET Framework 2.0 desktop application architecture, Joe Hummel focuses on the design and creation of .NET components. Strong naming, versioning, and the notion of pluggable components are just a few of the topics that Joe Hummelcover in this webcast.  114 minutes 12/6/05

This is the ninth webcast in the series on designing desktop applications with the Microsoft .NET Framework 2.0. In this webcast, Joe Hummel shows you how to take advantage of the build, analysis and testing tools available in Microsoft Visual Studio 2005.   99 minutes 12/20/05

This tenth session in the series on designing desktop applications with the Microsoft .NET Framework 2.0 presents the theory behind multithreading, and demonstrates ways to use this technology safely within your applications.  118 minutes  1/11/06

The eleventh webcast in the series on Microsoft .NET Framework 2.0 desktop application architecture focuses on the use of .NET remote access to create true smart client applications. Joe Hummel covers the various ways to configure remote access, how remote access may change your class designs, marshal-by-value objects versus marshal-by-reference objects, and caching.  111 minutes 1/25/07

This is the twelfth webcast in the series on designing desktop applications using the Microsoft .NET Framework 2.0. This webcast looks at the use of Web services as an alternative to remote access in creating true smart client applications. Topics include the pros and cons of Web services, marshal-by-value objects versus marshal-by-reference objects, and the future of Web services with the Microsoft Windows Communication Foundation set of technologies for connected applications.  119 minutes  2/8/06

In this thirteenth webcast in the series on Microsoft .NET Framework 2.0 desktop application architecture, Joe Hummel considers the security issues raised by distributed applications. The discussion includes topics such as authentication, authorization and encryption. 83 minutes  2/22/06

This is the fourteenth webcast in the series on designing desktop applications with the Microsoft .NET Framework 2.0. In this webcast, Joe Hummel discusses the ins and outs of ClickOnce, the no-touch deployment model in .NET 2.0.  90 minutes 3/8/06

In this final webcast in our fifteen-part series on Microsoft .NET Framework 2.0 desktop application architecture, we present some of the principles behind the agile software development process. Whether you agree with agile development or not, you can learn from some of the key concepts involved in this approach, including customer-driven design, frequent builds, unit testing and simplicity in design. 60 minutes 3/22/06