Category list

Chapter 6: Practical ADO .NET Programming (Part One)

Download CD Content

In This Chapter

This chapter shows the practical use of the DataSet and DataAdapter classes that are utilized to interact with the database. It is recommended that you read Chapters 2 and 3 before reading this chapter. Through the use of a simple case study, you will learn how to work with data access components , to work with XML, and to build Web Services. This chapter will demonstrate how to retrieve data from the database to a DataSet. In Chapter 7, you will learn how to update changes from a DataSet to the database.

Chapter 7 will use the Web Service we build in this chapter and continue with the case study. In this chapter, we will only look at the Web Service aspect of the case study. We will look at the clients in Chapter 7. We will also concentrate more on the data service side of things. We will not go into the details of security and maintaining user sessions, as they have little bearing on the database interaction. Instead, we will concentrate on the functions and methods that the service will expose for manipulating data from the Northwind database.

Chapter 7: Practical ADO .NET Programming (Part Two)

Download CD Content

In This Chapter

In Chapter 6 we concentrated on the data retrieval aspect of the Web Service. In this chapter, we will expand the Web Service to include data update methods .

We will look at how to set up the DataSet to avoid concurrency issues and how to update data via stored procedures instead of scripts.

Part III: Special Topics

Chapter 8: Migrating ADO Applications
Chapter 9: Manipulating Multidimensional Data

Chapter 8: Migrating ADO Applications

In This Chapter

When you have a new version of a programming language, the biggest issue is whether migration of an existing application will bring any added benefits. Generally, the main reason for migration is for improved performance or added features that the new tool brings to the development process.

In this chapter, you will learn about different issues that you need to consider before you choose to migrate any existing ADO application to ADO .NET.

Chapter 9: Manipulating Multidimensional Data

Download CD Content

In This Chapter

This chapter is a case study that covers the design and implementation of an OLAP solution in Visual Studio .NET utilizing the industry’s premier OLAP Microsoft SQL Server Analysis Services as the data store.

As an in-house systems developer, you realize that your company is bracing for an era of data revolution. This is at a time when information is the key to the success of your organization and its business processes. The marketers would like to analyze the trend of customer behavior, while the salespeople want to keep track of sales activities over a long period of time. Such information is an imperative part of plotting your company’s future marketing and production strategy. As a systems developer, you are struggling to design an effective and scalable software solution that your company’s analysts can use to assess its performance in the marketplace .

You quickly realize that implementing custom reports based on the company’s day-to-day data processing system would simply create a bottleneck as more stress is imposed on the databases. Thus, you revert to the design of an OLAP data warehouse.