Developing Data Access Solutions with Microsoft Visual Studio 2010 Central

Course details

Experienced developers who know the basics of data access (CRUD) in Windows client and Web application environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET Entity Framework, and ADO.NET.

Course Outline

• Lesson 1: Architecture and Data Access Technologies 
• Lesson 2: Building Entity Data Models 
• Lesson 3: Querying Entity Data 
• Lesson 4: Creating, Updating, and Deleting Entity Data
• Lesson 5: Handling Multi-User Scenarios by Using Object Services
• Lesson 6: Building Optimized Solutions by Using Object Services 
• Lesson 7: Customizing Entities and Building Custom Entity Classes 
• Lesson 8: Using POCO Classes with the Entity Framework
• Lesson 9: Building an N-Tier Solution by Using the Entity Framework 
• Lesson 10: Handling Updates in an NTier Solution by Using the Entity Framework 
• Lesson 11: Building Occasionally Connected Solutions 
• Lesson 12: Querying Data by Using WCF Data Services 
• Lesson 13: Updating Data by Using WCF Data Services
• Lesson 14: Using ADO.NET 
• Lesson 15: Using LINQ to SQL 

Prerequisites

Before attending this course, students must have:

• Accessing and managing data from a data source
• Experience in object oriented design and development as follows:
• Creating and accessing classes and class properties
• Creating and accessing methods and overloaded methods
• Implementing inheritance, base classes, and abstract classes
• Declaring, raising, and handling events
• Responding to and throwing exceptions
• Implementing interfaces and polymorphism
• Implementing shared and static members
• Implementing generics
• Creating components and class libraries
• Experience in N-Tier application design and development as follows:
• Managing a software development process
• Controlling input at the user interface level in Windows client and Web applications
• Debugging, tracing, and profiling .NET applications
• Monitoring and logging .NET applications
• Implementing basic testing best practices
• Performing basic data access tasks with LINQ
• Basics of LINQ to XML
• Basics of LINQ to Entities
• Basics of LINQ to SQL
• Implementing basic security best practices in .NET Applications
• Basics of Code Access Security
• Basics of Role-Based Security
• Basics of Cryptography Services
• Implementing basic service calls
• Basics of creating and consuming XML Web Services
• Basics of creating and consuming WCF Services
• Using .NET Configuration Files
• Deploying .NET Framework Applications using ClickOnce and the