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 
Updated on 08 November, 2015

About New Horizons Singapore

Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

See all New Horizons Singapore courses
Are you from New Horizons Singapore ? Claim your course!
Courses you can instantly connect with... Do an online course on Software Development starting now. See all courses

Is this the right course for you?

Didn't find what you were looking for ?

or