LearnKey Training

ADO.NET For Developers Part 1
ADO.NET Part 1


ADO.NET For Developers Part 1

5 Sessions –
15 Hours of Interactive Training
ADO.NET is Microsoft’s latest technology for accessing data from various sources and is a central part of the .NET framework. The ADO.NET Part 1 course from LearnKey begins with fundamentals like the ADO.NET Object Model and proceeds sequentially to more advanced topics. Expert instructors Andy Baron, Mary Chipman, and Ken Getz show you how to use ADO.NET to connect with data sources and access and modify data. At the conclusion of this course, you will be familiar with connection objects, command objects and the other objects and classes that comprise ADO.NET.

Prerequisites: Previous programming experience recommended and familiarity with .NET, XML, database design/development, and C#.NET or VB.NET helpful.

Benefits
  • Increase your earning potential with technical mastery and proficiency.
  • Enhance employment opportunities with in-demand web development knowledge.
  • LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner.
    • About The Authors
    Andy Baron, Mary Chipman, and Ken Getz are all Senior Consultants with MCW Technologies, a Microsoft Solution Provider. All have been Microsoft MVPs since 1995. When not creating applications for clients, Baron, Chipman and Getz write articles for technical journals including MSDN, Visual Basic Programmer's Journal, asp.netPRO, Access-VB-SQL Advisor, MsOfficePro, and SQL Server Magazine. The three authors have between them written over 10 technical books on various development topics. All three speak regularly at industry conferences, including Microsoft's Tech-Ed and DevDays, and DevConnections, VBITS, and Advisor Devcon.
    Session 1

    Section A: Getting Started with ADO.NET
    · Introduction
    · Using Form Wizard
    · Create Connection
    · Select DataSet
    · DataSet Relationship
    · Set up Form
    · Run Form

    Section B: Data Form Wizard Code
    · Examine Code
    · Typed DataSet
    · XML Schema Info
    · Typed DataSet Code
    · Form Wizard Objects

    Section C: DataAdapter Configuration
    · DataAdapter Properties
    · Configuration Wizard
    · SQL Select Statement
    · Advanced Options

    Section D: Evolution & Benefits
    · ODBC & ADO
    · OLE DB & ADO
    · ADO.NET
    · Scalability
    · Interoperability

    Section E: ADO.NET Object Model
    · Connected Objects
    · Disconnected Objects
    · Data Provider Objects
    · Connected Provider Objects
    · Data-Caching Objects
    · Typed DataSet
    · DataView
    · DataAdapter Object

    Section F: Connection Strings
    · Connection String
    · Create Connection
    · SQL OleDB
    · Microsoft Jet Database
    · Connection Code

    Section G: Data Links
    · Create UDL
    · Add References
    · DataLink Code

    Section H: Jet Connections
    · Unsecured Connection
    · User-level Security
    · Database Password
    · Jet Connection Code


    Session 2

    Section A: SqlClient Provider
    · Integrated Security
    · SQL Authentication
    · SQL Connection Code · Invalid Syntax

    Section B: Connection Events
    · StateChange Handler
    · StateChange Code
    · ODBC .NET Data Provider
    · Reference ODBC DLL
    · Create DSN
    · Use DSN

    Section C: Other Connections
    · Excel Spreadsheet
    · Excel Connection Code
    · Oracle Database
    · My SQL Database

    Section D: Connection Pooling
    · Closing Connections
    · SQL Server Profiler
    · Disable Pooling
    · Perfmon Connections

    Section E: Retrieving Schema Information
    · GetOleDbSchema Table
    · Retrieval Code
    · Saving Connection Strings
    · Save Options
    · Web Connections
    · Web Conf File
    · App Settings
    · App Variables

    Section F: Command Classes
    · Command Objects
    · Create Command Object
    · Constraints Class
    · ExecuteNonQuery Method
    · Execute DML Query
    · Execute DDL Query
    · Execute Method
    · Execute Scaler Method

    Section G: DataReader
    · DataReader Efficiency
    · GetOrdinal Method
    · Type-specific Method
    · Get Values Method
    · Multiple Results Sets
    · Schema Info
    · Multiple DataReaders


    Session 3

    Section A: Calling Stored Procedures
    · Basic SP Query
    · Passing Parameters
    · Setting Up Parameters
    · Use OleDB Namespace
    · Multiple Namespaces
    · Using Interface Inheritance

    Section B: Output Parameters & ASP Binding
    · SP with Output
    · Working with Output Parameters
    · Data Binding in ASP.NET
    · Bind to DataReader
    · Fill DataGrid Controls

    Section C: DataSets & DataTables
    · Using DataSet
    · DataTable Objects
    · Retrieving Data
    · Add a DataRow

    Section D: Filling with a DataAdapter
    · Retrieve Product List
    · Create DataAdapter
    · Create Query
    · Fill Method
    · Multiple Result Sets
    · Using DataAdapter
    · Tablemapping

    Section E: Retrieving Schema Info
    · View Schema Info
    · Data Columns Schema
    · AddwithKey

    Section F: DataSets & XML
    · Using XML
    · GetXML Method
    · Write XML Method
    · ReadXML Method
    · Display IE

    Section G: Apply Constraints
    · Defining Constraints
    · Using Constraints
    · Primary Key
    · Clearing DataSet
    · Fill Method Options
    · Adding Constraints
    · Primary Key Constraints

    Section H: Merging DataSets
    · Merge Method
    · Add Primary Key
    · Merge without PK
    · Merge with PK


    Session 4

    Section A: Foreign Key Constraints
    · FK Behavior
    · Cascading Updates
    · Filling DataSet
    · Add FK Constraint

    Section B: Other Constraints
    · Column Properties
    · Working with Nulls
    · Lengths & Defaults
    · Setting Property Constraints

    Section C: Database Relations
    · Relational Database
    · Schema Info
    · Enforce Options
    · Save Database Diagram
    · DataRelation in DataSets
    · Relation Constraints
    · Relation Method
    · Enforce Constraints

    Section D: Navigation Pathways
    · Navigate by Relations
    · Fill Methods
    · Bind ListBox
    · Select Category
    · Select ParentRow
    · Expressions & Relations
    · Categories Expression
    · Products Expression

    Section E: Relations in Action
    · Write XML Application
    · Write Nested XML
    · Wizard & DataRelations

    Section F: Command Builder
    · Updating Data
    · Insert Command
    · Update Command
    · Delete Command
    · Submit Changes
    · Load DataSet
    · CommandBuilder Methods
    · Update Method

     



    ADO.NET For Developers Part 1 continued

    Section G: Creating Commands
    · Custom Commands
    · Setup DataAdapter
    · Add Parameters
    · Column Binding
    · Define Command
    · Updating with DataAdapter

    Section H: Get Changes
    · Create New DataSet
    · DataRow Version
    · RowState
    · Accept & Reject Changes

    Session 5

    Section A: Using Stored Procedures
    · Create SPs
    · Assign Command
    · Execute NonQuery
    · Create Stored Procedure
    · Perform Insert
    · Create SQLCommand Object
    · Update with DataAdapter
    · Perform Delete

    Section B: Complex Updating
    · Delete Issues
    · Performing Updates
    · Concurrency Checking
    · Update DataSet
    · Merge & Accept
    · Update Data Source

    Section C: Creating Typed DataSets
    · Using DataSets
    · Strongly Typed DataSets
    · Multiple DataAdapters
    · Using DataSets
    · Investigate Class
    · Class View
    · Use Typed DataSet
    · Using Typed DataSets

    Section D: Untyped DataSets
    · Typed DataSet
    · Find Values
    · Modify DataSets
    · Add Row to DataSets
    · Working with Null Values
    · Navigate Relations
    · Using GetProductsRows

    Section E: Typed DataSet Issues
    · DataBinding
    · DataBinding Properties
    · Efficiencies
    · Convert DataSets
    · Annotations
    · Benefits & Drawbacks