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.
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.
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.
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.
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.
