The Data Access Application Block is a part of the Microsoft Enterprise Library. In this block there are many classes that you can use to help simplify your data access code and make it more portable. In this course we will learn about the Data Access Application block, how to use it to do basic querying of data and even map data from our database to objects. This course also covers the entire Data Access Application block, and is designed to help you master the block.
Block Overview and Configuration Hi! This is John Sonmez from Pluralsight and in this course we're going to be talking about the data access application block as part of the enterprise library. And in this module we're going to start off by going over the block to discuss what the block is about and how you can use it and when you should use it and then we're going to take a look at configuring the block which is actually pretty simple, but we're going to go ahead and get our solution file up and working with the block so that we'll be able to use this in the rest of the modules.
Simple ADO.NET Scenarios Hi. This is John Sonmez from Pluralsight, and welcome to the second module about the Data Access Application Block. In this module we're going to be talking about some of the simple ADO. Net scenarios that are covered by the Data Access Application Block. So we're going to primarily be looking at some of the operations that you can do with this block that are going to mirror a lot of the ADO. Net type of situations, but they're going to be a little bit easier to do using the block and simplify some of the coding. So let's take a look at what we're actually going to cover. The first thing that we're going to do is we're going to look at some code examples for using the data reader. And we already seen this example in the previous module, but we're going to break this down a little bit more to make sure we have a good understanding of how this works. Then we're going to go through and we're going to see how we can execute scalar and nonquery type of operations against the database. Then we'll use DataSets. We'll see how we can fill existing DataSets, create new DataSets and use DataSets to update in our database. Then finally, we'll take a quick look at connections and how we can use the connections to create transactions which is going to work for similarly to how transactions are used in standard ADO. Net.
Advanced Topics Hi, this is John Sonmez from Pluralsight and welcome to the module on Advanced Topics for the Data Access Application Block. In this module, we're going to cover a few different topics. The first topic that we're going to cover is getting back object results from our database and we're going to use the Data Access Application Block to do a query and have the results that query maps to do some objects. This is going to be very similar to an object-relational mapper but not quite the same and we're going to discuss some of the differences there and show you how to actually do the mapping in some cases when you actually have to create your own mapping. Then we're going to look at XML results and we're going to see how we can return back XML data and then use that XML data. Finally, we're going to look at doing some of the queries we've already done so far but doing them asynchronously, which is going to come in handy whenever you have a long running query and you don't have to have the results right away. Maybe you're updating a page with some current data and you can just refresh that whenever there is new data available.