Developing Data Access Solutions with Microsoft Visual

Apply now for our Developing Data Access Solutions with Microsoft Visual Course Training



  • Architecture and Data Access Technologies
  • Using POCO Classes with the Entity Framework
  • Querying Data by Using WCF Data Services
  • Updating Data by Using WCF Data Services
  • Customizing Entities and Building Custom Entity Classes


Course Details and Pricing


Instructor Led Learning


  Duration: 5 Days

  Registration Open Now!

Video Learning


  Duration: 5 Days

  Registration Open Now!

Call us : 0861 111 460

Computers Made Easy overview

Who should attend Developing Data Access Solutions with Microsoft Visual ?

This course is recommended for professional .NET software developers who use Microsoft Visual Studio in a team-based, medium-sized to large development environment. This course is also tailored to individuals who have some experience using Visual Studio 2010 for either Windows client or Web application development.

Developing Data Access Solutions with Microsoft Visual Training Overview

This Course focuses on database or data source connectivity within .NET applications. This includes Good Practices for structure of the application. The course goes through usage of the ADO.NET Entity Framework, LINQ, Windows Communication Foundation (WCF) Data Services, The Sync Framework and ADO.NET.

This course is most commonly run through mentored learning in the “MyChoice” environment where there are instructors available to assist you, one-on-one, while you are going through the course content.







 Developing Data Access Solutions with Microsoft Visual Training capetown south africa

About Developing Data Access Solutions with Microsoft Visual Training

What is ADO.Net? ADO.NET is a framework containing many Data Access Objects such as the “Connection” Object to connect to SQL Server Databases as well as other Data sources through OLE DB and XML. The main Objects used are the Connection, Command, DataReader, DataAdapter and it gets a DataSet Object.

Example of ADO.NET Code:

String strCon = @"Data Source=NH\SQLSERVER; Initial Catalog=Northwind; Integrated Security=SSPI"; String sqlQuery="SELECT *FROM Students"; SqlConnection con=new SqlConnection(strCon); con.Open(); SqlDataAdapter adapter=new SqlDataAdapter(); adapter.SelectCommand=new SqlCommand(strSql,con); DataSet result=new DataSet(); dadapter.Fill(result); con.Close();


Creating data Access solutions allows you to implement a database to be used in application so that information does not necessarily need to be stored locally. A database should be set up in such a way that information stored can be accessed without information becoming inaccurate or unavailable. Depending on the database, there can also be storage methods used to eliminate redundancy as far as possible.





 Developing Data Access Solutions with Microsoft Visual Training capetown south africa

3 Steps to Master Developing Data Access Solutions with Microsoft Visual Training

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Developing Data Access Solutions with Microsoft Visual Training

    • Lesson 1:Overview of the Windows 8.1 Platform and Windows Store Apps
    • Lesson 2: Single-Page Apps and the MVVM Design Pattern
    • Lesson 3: Using WinJS
    • Lesson 4: Presenting Data
    • Lesson 5: Implementing Tiles and User Notifications
    • Lesson 6: Handling Files in Windows Store Apps


    • Prerequisites: Introduction to programming »

      What course next: 10264 OR 10265 »
  • Lesson 7: Windows Store App Process Lifetime Management
  • Lesson 8: Designing and Implementing Navigation in a Windows StoreApp
  • Lesson 9:Implementing Windows 8.1 Contracts
  • Lesson 10:Designing and Implementing a Data Access Strategy
  • Lesson 11:Responding to Mouse and Touch
  • Lesson 12:Planning for Windows Store App Deployment

Full course outline
Developing Data Access Solutions with Microsoft Visual Training

Module 1: Architecture and Data Access Technologies

  • Data Access Technologies
  • Data Access Scenarios

Module 2: Building Entity Data Models

  • Introduction to Entity Data Models
  • Modifying the Entity Data Model
  • Customizing the Entity Data Model

Module 3: Querying Entity Data

  • Retrieving Data by Using LINQ to Entities
  • Retrieving Data by Using Entity SQL
  • Retrieving Data by Using EntityClient Provider
  • Retrieving Data by Using Stored Procedures
  • Unit Testing Your Data Access Code

Module 4: Creating, Updating, and Deleting Entity Data

  • Understanding Change Tracking in the Entity Framework
  • Modifying Data in an Entity Data Model

Module 5: Handling Multi-User Scenarios by Using Object Services

  • Handling Concurrency in the Entity Framework
  • Transactional Support in the Entity Framework

Module 6: Building Optimized Solutions by Using Object Services

  • The Stages of Query Execution
  • Change Tracking and Object Materialization
  • Using Compiled Queries
  • Using Design-Time Generated Entity Framework Views
  • Monitoring Performance
  • Performing Asynchronous Data Modifications

Module 7: Customizing Entities and Building Custom Entity Classes

  • Overriding Generated Classes
  • Using Templates to Customize Entities
  • Creating and Using Custom Entity Classes

Module 8: Using POCO Classes with the Entity Framework

  • Requirements for POCO Classes
  • POCO Classes and Lazy Loading
  • POCO Classes and Change Tracking
  • Extending Entity Types

Module 9: Building an N-Tier Solution by Using the Entity Framework

  • Designing an N-Tier Solution
  • Defining Operations and Implementing Data Transport Structures
  • Protecting Data and Operations

Module 10: Handling Updates in an N-Tier Solution by Using the Entity Framework

  • Tracking Entities and Persisting Changes
  • Managing Exceptions in an N-Tier Solution

Module 11: Building Occasionally Connected Solutions

  • Offline Data Caching by Using XML
  • Using the Sync Framework

Module 12: Querying Data by Using WCF Data Services

  • Introduction to WCF Data Services
  • Creating a WCF Data Service
  • Consuming a WCF Data Service
  • Protecting Data and Operations in a WCF Data Service

Module 13: Updating Data by Using WCF Data Services

  • Creating, Updating, and Deleting Data in a WCF Data Service
  • Preventing Unauthorized Updates and Improving Performance
  • Using WCF Data Services with Nonrelational Data

Module 14: Using ADO.NET

  • Retrieving and Modifying Data by Using ADO.NET Commands
  • Retrieving and Modifying Data by Using DataSets
  • Managing Transactions and Concurrency in Multiuser Scenarios

Module 15: Using LINQ to SQL

  • Implementing a Logical Data Model by Using LINQ to SQL
  • Managing Performance and Handling Concurrency

Are you ready become a Web Developer ?