• Technical IT

    Solutions delivered throughout the UK
  • Business Applications

    Solutions delivered throughout the UK
  • Professional Best Practice

    Solutions delivered throughout the UK
  • Professional Development

    Solutions delivered throughout the UK

Developing Data Access Solutions with Microsoft Visual Studio 2010 Aberdeen

  • Price £1,825.00
  • Duration 5 day(s)
All major credit cards accepted

Description

In this course, 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, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.

Prerequisites

This course is for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. You will have experience implementing data access and data binding within their Web and/or Windows Client applications and are interested in learning to optimize data access (CRUD) within their applications using the Entity Framework, LINQ, and ADO.NET. You will be an experienced user of Microsoft Visual Studio 2008 SP1 or newer releases of the Visual Studio product. The will have some experience using Visual Studio 2010 for either Windows Client or Web application development

Typically, you will have the following knowledge/experience:

•Experience developing n-tier applications that access various data sources
•Experience implementing data binding within their applications
•Some experience using LINQ and ADO.NET
•A conceptual understanding of the Entity Framework
In addition to their professional experience related to Data Access, students who attend this training should have the following technical knowledge:
•An understanding of the problem-solving techniques that apply to software development, including the following principles of software development: modern software development models, typical phases of a software development lifecycle, concepts of event-driven programming, concepts of object-oriented programming, creating use-case diagrams, designing and building a user interface, developing a structured application
•A basic understanding of the following scripting techniques and some hands-on experience writing scripts: Web scripting techniques; Macro scripting techniques; Windows scripting techniques
•A general understanding of the purpose, function, and features of following .NET Framework topics: Common Language Runtime, .NET Framework class library, Common Type System, Component interoperation, Cross-Language Interoperability, Assemblies in the Common Language Runtime, Application Domains, Runtime hosts supported by the .NET Framework
•Experience using Visual Studio 2008 in the following task areas:
•Declaring and initializing typed variables using the Camel case naming convention
•Using arithmetic, relational, and logical operators in code statements
•Using branching statements to control code execution
•Using looping statements to iterate through collections or repeat steps until a specified condition is met
•Creating classes and methods to establish the basic structure of an application
•Using methods and events to implement the programming logic of an application
•Identifying syntax and logic errors
•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 MS Installer
•Data Access experience in Windows Client application development as follows:
•Connect to a data source
•Implement data binding
•Implement data validation at the UI layer
•Data Access experience in Web application development as follows: Connect to a data source, Implement dynamic data, Implement data validation at the UI layer

Skills

See Course Content

Course Content

Module 1 – Architecture and Data Access Technologies
Module Goal: The goal of this module is to enable students to evaluate a variety of business cases, and then select an appropriate combination of data access technologies and tools most appropriate to each case. Students will learn about the roles of Entity Framework, Data Services, and ADO.NET for building and maintaining applications. They will also learn about the use of LINQ on top of these technologies to improve their productivity and the quality of their applications.

Module 2 – Building Entity Data Models
Module Goal: The goal of this module is to enable students to use the tools provided with the Entity Framework to map the conceptual model used by the business logic of an application to the logical data model provided by a database.

Module 3 – Querying Entity Data
Module Goal: The goal of this module is to enable students to query an entity data model by using common methods such as LINQ to Entities, Entity SQL, and the classes in the EntityClient namespace.

Module 4 – Creating, Updating, and Deleting Entity Data
Module Goal: The goal of this module is to enable students to perform data modification (CUD) tasks through an entity data model by using LINQ to Entities, Entity SQL, and the classes in the EntityClient namespace.

Module 5 – Handling Multi-User Scenarios by Using Object Services
Module Goal: The goal of this module is to provide students with a deeper understanding of the object model implemented by EF, and the support provided by the Object Services API for addressing the issues faced by enterprise applications that have handle multiple concurrent users accessing the same data simultaneously.

Module 6 – Building Optimized Solutions by Using Object Services
Module Goal: The goal of this module is to describe best practices for designing and building a scalable, optimized data access layer by using Object Services.

Module 7 – Customizing Entities and Building Custom Entity Classes
Module Goal: The goal of this module is to enable students to customize and extend entities with their own business logic, and to use advanced mappings and other techniques in the Designer and XML to shape the data model to their business and application requirements (rather than an EDM that closely reflects the database).

Module 8 – Using Persistence-Ignorant Classes with the Entity Framework
Module Goal: The goal of this module is to enable students to reuse existing POCO business classes in a data access layer built by using the Entity Framework.

Module 9 – Building an N-Tier Solution by Using the Entity Framework
Module Goal: The goal of this module is to enable students to address the architectural issues that can arise when building an N-Tier enterprise application by using the Entity Framework.

Module 10 – Handling Updates in an N-Tier Solution by Using the Entity Framework
Module Goal: The goal of this module is to enable students to build extensible solutions that can update data in an N-Tier enterprise application by using the Entity Framework.

Module 11 – Building Occasionally-Connected Solutions
Module Goal: The goal of this module is to enable students to access offline data, or data that that has limited availability in client applications.

Module 12 – Querying Data by Using WCF Data Services
Module Goal: The goal of this module is to enable students to design, develop, and consume a simple data service.

Module 13 – Updating Data by Using WCF Data Services
Module Goal: The goal of this module is to enable students to use WCF Data Services to update and delete data and handle multi-user concerns.

Module 14 – Using ADO.NET
Module Goal: The goal of this module is to enable students to develop high performance, scalable ADO.NET applications that can query and update data.

Module 15 – Using LINQ to SQL
Module Goal: The goal of this module is to show students how LINQ to SQL enables them to develop against a logical model which abstracts the low-level details of querying ADO.NET tables and result sets.

Make Enquiry

Course Enquiry
  •  
  •  

Book Now

Course Enquiry
  •  
  •  

Find your local training centre

AddressRiverside House
Riverside Drive
Aberdeen
AB11 7LH
Phone01423 790107