|
Free ebooks
 Free programing ebooks C# Beginning C# 2005 Databases - programmer to programmer
|
||||||||
 Chapters 1 and 2 cover the fundamentals — everything you need to be aware of before you start. In Chapter 1 you learn exactly what the definition of a database is, the types of database that are available, and the features that databases provide. Finally, you see how to access databases using the SQL language, and take a look at how XML fits into the picture.In Chapter 2 you move on to learn about ADO.NET, and how it can used to access databases from C# applications. You’ll also see the Express tools that you’ll be using in this book, and try out a few basic examples to prepare you for what is to come. This chapter also introduces the sample database used in this book, FolktaleDB. Chapters 3–5 provide a look at data-binding techniques you can use to present and modify data in Windows and Web applications. Using data binding, you can get excellent results while writing little or no additional code — instead, you use visual tools and declarative techniques to get the behavior you want. Chapter 5 takes what you have learned about database access with ADO.NET and applies it to Web applications. You’ll see that the details are a little different — particularly with the user interface of Web applications — but that much of what you’ve learned is, with minor modifications, just as applicable to Web applications. In Chapters 6–8, you start to look at things in a little more depth. You will already know that data binding is fantastic, but that it doesn’t necessarily cater to everything you might want to do. Sometimes the only option you have is to write database access code with ADO.NET by hand. In Chapter 6 you see how to do this, learn about what is possible, and discover how to prevent common problems. In Chapter 7 you explore views and stored procedures in databases and see how you can use them to simplify the code you need to write in client applications. By performing some of your data manipulation in SQL Server, you won’t have to do it in C# code. However, there are additional things to consider when you’re working with views and stored procedures, and some tasks require a little more care to implement correctly. You are provided with plenty of hands-on examples, as well as information about avoiding trouble. Chapter 8 looks at writing code to fit into n-tier design principles, particularly how you can abstract data into custom object families. That gives you greater flexibility in dealing with data, and you will see that even when you do this, you can still make use of data binding to create database applications quickly and easily. Chapters 9–11 look at some advanced topics to help you streamline your applications and perform more complex tasks. You also see how to elude some pitfalls. Chapter 9 examines transactions and concurrency, which are critical in multi-user applications because difficulties can arise when more than one person accesses your data simultaneously. In Chapter 10 you look at the more advanced world of distributed application design, focusing on remote database access across the Internet. You see how to provide Web Services to give you access to remote data, and how database data can be cached to avoid having too much traffic between Web servers and database servers. Finally, in Chapter 11 you’ll look at a topic that’s new to .NET 2.0 and SQL Server 2005: writing managed code in C# that you can load into and execute inside SQL Server. This enables you to create functions, stored procedures, and more without resorting to SQL code. You’ll learn how this can give you great benefits both in ease of development and advanced functionality. Download free ebooks on C#: Beginning C# 2005 Databases - programmer to programmer
|
| More free ebooks | |