Školení ADO.NET 3.5

Kurz ADO.NET 3.5 osnova:

Module 1: Getting Started with ADO.NET 3.5

• Introduction to ADO.NET 3.5
• Connecting to a Database and Retrieving Data
• Connecting to a Database
• Executing a Simple Query
• Executing a Query That Returns a Result Set
• Executing a Query That Requires a Parameter
• Best Practices for Managing Connections and Performing Queries

Module 2: Modifying Data by Using ADO.NET Commands

• Inserting, Updating, and Deleting Data
• Implementing Transactional Updates
• Managing Data Integrity and Concurrency
• Executing Commands Asynchronously

Module 3: Querying and Maintaining Data by Using DataSets

• Creating a Typed DataSet
• Retrieving Data into a DataSet
• Modifying Data in a DataSet
• Saving a DataSet and Resolving Conflicts

Module 4: Querying and Maintaining Data by Using LINQ

• Querying In-Memory Data by Using LINQ Query Expressions
• Retrieving Data by Using LINQ to SQL
• Modifying Data by Using LINQ to SQL

Module 5: Implementing an Entity Model by Using the ADO.NET Entity Framework

• Creating an Entity Data Model by Using the ADO.NET Entity Framework
• Querying Entities in an Entity Data Model
• Modifying Entities in an Entity Data Model

Module 6: Building Occasionally Connected Solutions by Using Synchronization Services

• Understanding Microsoft Synchronization Services
• Downloading Data by Using Synchronization Services
• Uploading Data by Using Synchronization Services