|
|
Title |
Duration |
|
|
|
Introduction to Accessing Data with .NET 4
The opening video will give insight to what data access technologies are available in the .NET 4 Framework and a brief overview of each one. You'll get familiar with the 70-516 exam requirements and where they fit in with the nuggets in this series.
|
00:24:12 |
|
|
|
Overview of ADO.NET
This nugget starts with a tour of ADO.NET's architecture and the components that make up ADO.NET. From there you'll learn how to work with the most common classes in ADO.NET, the DataTable and DataSet. These classes allow us to store and work with data whether our application is available online or offline.
|
00:46:50 |
|
|
|
Working with ADO.NET - Disconnected Data
This nugget is all about working with data while being disconnected from the database. You'll begin with learning how to store data in a disconnected environment using serialization and how to handle custom data types within datasets and datatables. You'll also learn how to databind using ASP.NET, WinForms and WPF.
|
00:29:40 |
|
|
|
Working with ADO.NET - Connected Data
Here you'll learn how to work in a connected environment. You'll start with connections and how to configure, store and even encrypt database connections. You'll then learn how to work with live data stored in the database using various techniques and classes in ADO.NET. This nugget will also explain how to create and work with transactions from inside and outside of ADO.NET.
|
00:39:29 |
|
|
|
Introduction to LINQ
LINQ is a powerful new way to work with data in our applications. In this LINQ introduction, you'll see what all the hype behind the Language Integrated Query is about. You'll start with the basics of what LINQ is and the language enhancements .NET has undergone in order to support it. This nugget will close with some LINQ examples against our applications in-memory data.
|
00:32:04 |
|
|
|
Writing LINQ Queries
This nugget will get your fingers itching to write LINQ queries. You'll learn the different styles of syntax LINQ supports and when best to use Query or Method based syntax. You'll then get familiar with LINQ to Objects and learn how to filter, sort, group, aggregate, join and page on the data stored within our application.
|
00:32:23 |
|
|
|
LINQ to SQL Introduction
Wouldn't it be great if we didn't have to write our data access layer by hand? LINQ to SQL is here to save the day! You'll learn how to map a physical database into the conceptual layer of your application using LINQ to SQL's data modeling tools and how to work with data models within our projects. You'll then learn how to write LINQ to SQL queries to retrieve data from those models so we can work with those live objects and their data in our applications.
|
00:31:46 |
|
|
|
Working with LINQ to SQL
We'll dig deeper inside LINQ to SQL in this nugget by examining the DataContext to get a better understanding of how it manages objects and their data internally. You'll learn how to insert, update and delete data stored in LINQ to SQL objects and how to save those changes back to the database. You'll also see how to hook up a logger and work with transactions through the DataContext.
|
00:33:42 |
|
|
|
LINQ to XML Introduction
This nugget will introduce you to various XML technologies for reading and writing XML data. You'll learn where we came from with the XML Document Object Model (DOM) and related XML technologies before seeing where the future is headed with LINQ to XML.
|
00:24:33 |
|
|
|
Working with LINQ to XML
You'll learn how to write LINQ queries to read, write, manipulate, sort and filter XML data in this nugget. You'll also learn how to transform XML data by leveraging the power of LINQ and get familiar with the all of the classes available in the LINQ to XML framework.
|
00:26:03 |
|
|
|
Introduction to the ADO.NET Entity Framework
The Entity Framework is the next generation of data access in the .NET framework. This introductory nugget will familiarize you with the EF architecture before jumping right in and learning how to build an entity data model using both database first and the new code first modeling techniques. You'll also learn how to hook up stored procedures and work with complex types inside our entity data models.
|
00:38:27 |
|
|
|
Working with the ADO.NET Entity Framework
This nugget will dig deeper in the entity framework by looking at the various ways we can query our entities to get the data we want using LINQ to Entities and Entity SQL. We'll learn how to implement inheritance within our data models and the loading strategies available for filling our related entities with data. This nugget will end with a look at self tracking entities and how to hook up POCO's to our entities.
|
00:46:42 |
|
|
|
Introduction to WCF Data Services
WCF Data Services allow us to expose our data as services over the internet. We'll begin with a look at the architecture of WCF and the technology's we can use to build WCF services. We'll then learn how to build and configure a WCF Data Service and expose our entities as resources over the internet. We'll also look at how to build a traditional WCF SOAP Service.
|
00:23:41 |
|
|
|
Consuming WCF Data Services
Building on the introductory WCF Data Services nugget, you'll see how to work with a WCF Data Service from the client side by creating a client application to consume it. You'll also see how to use interceptors to add filters and validation at the service level. We'll wrap this nugget up with a look at how consume a WCF SOAP Service from a client application.
|
00:22:59 |
|
|
|
Developing Reliable Applications - Troubleshooting Data
Troubleshooting issues in a data driven application can be a nerve racking task, especially in a production environment. Information is key when troubleshooting and this nugget will teach you how to implement logging in your applications, handle database generated errors, and make your own custom performance counters to give you more information for tracking down those pesky problems.
|
00:25:46 |
|
|
|
Developing Reliable Applications - Protecting Data
Protecting sensitive information is always a top priority and this nugget will give you the skills needed to do so. You'll start with hashing and salting, a great way to create a digital fingerprint of data. You'll then learn about the various forms of encryption and how to use them in .NET, from symmetric and asymmetric encryption to signing and verifying data with digital signatures.
|
00:42:42 |
|
|
|
Developing Reliable Applications - Synchronizing Data
Building offline applications that require data synchronization can add another layer of complexity to your programming requirements. This nugget will teach you how easy it is to use the Microsoft Sync Framework to build occasionally connected applications (OCA's) that work on a local data cache while staying synchronized with a source database.
|
00:26:08 |
|
|
|
Deploying Applications & Components
The final nugget in this series will show you the various ways to deploy applications in the .NET 4 framework. You'll learn how to publish web sites, web applications, WCF services and windows applications. You'll also learn how to create deployment packages for local installations.
|
00:25:32 |
