Monday, April 14, 2014

Microsoft .Net Events and Delegates




In this screencast we'll talk Microsoft .Net delegates as the basis for how events work. We'll then talk about events specifically covering raising events and subscribing to them. Then we'll finish up with simplifying our event handler creation process by utilizing the power of Lambda statements.

Download the project code here.

Friday, April 4, 2014

WCF DataServices - Exposing an EF Data Model




In this screencast we'll talk about how you can use WCF Data Services to expose an Entity Framework data model via a REST service.

Download the project code here.

Tuesday, March 25, 2014

Entity Framework - Code First




In this screencast we'll talk about the Microsoft Entity Framework and specifically use the "Code First" approach. 

We'll create a simple client application along with a class we wish to persist using the Entity Framework. We'll have it then create a data schema based on the simple POCO class we create. Finally we'll create a DBContext and run queries against it.

Download the project code here.

Wednesday, March 19, 2014

Entity Framework - Database First




In this screencast we'll talk about the Microsoft Entity Framework and specifically use the "Database First" approach. 

We'll identify what it is, then import an existing database into the Entity Framework, spend some time with the Entity Data Modeler and create a DBContext and run queries against it.  

Download the project code here.

Monday, March 17, 2014

Using LINQ to query XML





In this screencast we'll talk about the Microsoft .NET component called Language Integrated Query (LINQ)

We'll specifically discuss how LINQ can be used to query XML.


Download the project code here.

Tuesday, March 11, 2014

Introduction to Microsoft LINQ





In this screencast we'll talk about the Microsoft .NET component called Language Integrated Query (LINQ)

We'll discuss some of the features that the System.LINQ namespace makes available to the ASP.NET programmer today. We'll look specifically at Comprehension Queries and also briefly discuss Extension Methods.


Download the project code here.

Friday, March 7, 2014

Create and access an Azure SQL Database






In this screencast we'll create an Azure SQL database and connect to it via ADO.NET using a DataReader.

This main focus here is to show you how to create a database in Azure and how you can manage it much in the same way you would manage a SQL database on premise.

We'll create the database, a server to host it, configure the IP addresses allowed to connect to it, then in SQL management studio we'll run a script to create some tables and populate them with some data. Then we'll create a simple console application which uses ADO.NET DataReader to retrieve data from the database.

In subsequent screen-casts we'll access the database using in other ways, such as LINQ to SQL and the Entity Framework which will allow us to compare and contrast some of the new different data access capabilities we have available to us today.

Download the project code here.