Database Programming with C# / Edition 1
by Carsten Thomsen, Manohar KamathISBN-10: 1590590104
ISBN-13: 9781590590102
Pub. Date: 04/09/2002
Publisher: Apress
Database Programming with C# can be used as a reference book - thanks to its many listings and tables. It's really intended to be a book that any serious C# programmer who needs to do database programming should read cover-to-cover. It will take you through all the data access aspects of Visual Studio .NET with example code in C#. This includes how to create the
Overview
Database Programming with C# can be used as a reference book - thanks to its many listings and tables. It's really intended to be a book that any serious C# programmer who needs to do database programming should read cover-to-cover. It will take you through all the data access aspects of Visual Studio .NET with example code in C#. This includes how to create the various database items, such as databases, tables, constraints, database projects, stored procedures, views, triggers, and more from within the Visual Studio .NET IDE, but also programmatically. Readers will learn to build on the same example code from the beginning of the book until you wrap it up in the very last chapter. The example application is a complete user management system that includes SQL Server, Active Directory, and Message Queuing.
Product Details
- ISBN-13:
- 9781590590102
- Publisher:
- Apress
- Publication date:
- 04/09/2002
- Edition description:
- 2002
- Pages:
- 696
- Product dimensions:
- 7.52(w) x 9.25(h) x 0.30(d)
Table of Contents
Chapter 1 A Lightning Quick Introduction to C#.This chapter takes you through most of the terms and concepts in C# and indeed Visual Studio .NET, like the Common Language Runtime (CLR), .NET Framework, Just-In-Time compilation (JIT), Assemblies and Namespaces, and so on. The chapter is meant as a refresher, if there are some concepts and terms you are unsure of.
Chapter 2 Talking To Databases
This chapter is an introduction to general database terms and concepts. I look at how to design a relational database and what keys, relationships, normalization, and denormalization do for you.
Chapter 3 Presenting ADO.NET
Chapter 3, which is split into two twin chapters, 3A & 3B, is a walk-through covering how to use the various data classes in ADO.NET. Most classes are explained in detail and there is plenty of example code, tips and ideas.
Chapter 4 Presenting The IDE from a Database View Point
This chapter is a presentation of the various designers and projects that are related to databases. I look at how to create database projects, relational databases, including tables, relationships, keys, stored procedures, views, triggers and son. I also give the Server Explorer a very detailed inspection and explain how to use the data related resources in this window and finally I look at how to create a typed data set.
Chapter 5 Exception Handling
Chapter 5 shows you how exception handling in C# is built around a structured exception handling model, and how you can use exception handling with databases. I look at specific database related errors and how to handle these in code.
Chapter 6 Using Stored Procedures, Views And Triggers
This chapter is all about using server side objects for faster processing. You will see how to set up your code to accommodate the use of Stored Procedures, Triggers and Views.
Chapter 7 Hierarchical Databases
Chapter 7 is all about how you access and manipulate data in the Active Directory using LDAP and other protocols.
Chapter 8 Message Queuing
Chapter 8 is all about using message queues for truly making your application connectionless. You will see some of the advantages and disadvantages of using queues and how you can combine them with your "normal" data access approach.
Chapter 9 Data Wrappers
Chapter 9 shows you how to create classes (wrappers) for your data access. I will teach you why and how to wrap/encapsulate your data access in classes and thus prevent direct access to your data.
Chapter 10 Data Bound Controls
This chapter explores how to use the various data bound controls that come with C# and Visual Studio .NET. You will also see how you can create your own data bound controls.
Chapter 11 UserMan
Finishing the example Application... In this chapter, you will be "finishing" off the example application that you have been working on throughout this book and you will get some ideas on how to customize it to your own needs and take it that one ste
Customer Reviews
Average Review:
Most Helpful Customer Reviews
Database Programming with C#
5 out of 5
based on
0 ratings.
7 reviews.
 |
I work with VB .NET and C# and I found myself in need of a good DB book. I went through a number of books at the local bookstore, but never came across this one. I saw the reviews and decided to buy it. I don´t regret it as it is possibly the best ADO.NET reference book. I enjoyed reading the Exchange Server chapter although this has nothing o do with my primary work.
|
|
It's incredible that you can find a book with so detialed coverage of so many subjects; ADO.NET, Exchange Server, MSMQ, SQLXML... This is one book I can use as a reference book, but I also thoroughly enjoyed reading it.
|
|
Overall this book is of very high quality. I love the way most of the chapters starts at near beginner level and then gradually adds more information to the pile. That's how a book should be written, and in a competent manner. I could do with more examples and pictures, but that doesn't detract enough from my 5 star rating. This is a must have book for any C# developer not yet comfortable with ADO.NET or any other database work for that matter.
|
|
I wasn't all that sure about this book before I bought it. Well, a friend of mine from the IT business suggested it to me and I think she did me a favor. This really is a good book and I enjoyed reading it from cover to cover. Sure there were a few pages I skipped, because I already knew it, but otherwise I really learned a lot and I now use it as a reference book on ADO.NET and msmq which I use regularly. I can highly recommend this book and in particular chapter six which is awesome.
|
|
I feel this is one of the best database books I have read over the years, especially for new technology, and I really enjoy the detailed coverage and yet so many topics are covered. I like chapters 3a and 3b, but chapter 6 is by far the best with its Oracle and SQL server coverage.
|
|
I think the author has an excellent writing style and the book covers what I need, and a lot more. Okay there were a few things i dislike, but overall the book is well worth the money. I really like chapter 6 and 8 and the event coverage.
|
|
A very enjoyable book, because of the authors writing style. These chapters are simply excellent: 5. Exception handling, 6. Server side processing, 7. Hierarchical databases (the Exchange Server bit), 9. Data wrappers, A. Using XML with SQL Server 2000 Chapter 1 isn't worth anything to me, but maybe to .NET beginners; I don't know.
|