+612 9045 4394
Database Programming with C# : Expert's Voice - Carsten Thomsen

Database Programming with C#

Expert's Voice

Paperback Published: 10th April 2002
ISBN: 9781590590102
Number Of Pages: 504

Share This Book:
Ships in 5 to 9 business days

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.

Industry Reviews

From the reviews:

"Database programming in Microsoft's .Net approach is accomplished via ADO.Net. ... So in this book we might expect to find a detailed description of ADO.Net with C# examples. The author delivers on the expectation, covering ADO.Net in two of the 11 chapters. ... it can be used as a reference text. ... absolute beginners will find an abundance of useful information. ... most of the content will more than satisfy beginners." (Daniel Moth, The Computer Bulletin, November, 2002)

"Database Programming with C# by Carsten Thomsen, is for people who have already done database programming in Visual Basic or Java and also know the basics of C# programming. ... The appendix, showing connectivity to SQL Server 2000 using XML, is particularly useful. The coverage of unusual topics such as message queues and hierarchical databases demonstrates Thomsen's mastery over .NET, making this book a must read, particularly for database programmers with basic knowledge of C#." (Alokesh Bhattacharyya, Computer Today, July, 2002)

Forewordp. ix
About the Authorp. xi
About the Technical Reviewerp. xiii
Acknowledgmentsp. xv
Introductionp. xvii
Getting Startedp. 1
A Lightning-Quick Introduction to C#p. 3
Reviewing Programming Conceptsp. 4
Getting Cozy with the VS .NET Integrated Development Environmentp. 14
Summaryp. 28
Database Programmingp. 29
Using Databasesp. 31
What Is a Database?p. 31
Why Use a Database?p. 32
Relational vs. Hierarchicalp. 33
What C# Programmers Need to Know About Relational Databasesp. 35
UserMan Database Schemap. 51
Summaryp. 53
Presenting ADO.NET: The Connected Layerp. 55
Data-Related Namespacesp. 58
Data Providers and Driversp. 59
Using Command Objectsp. 123
Using the DataReader Classp. 146
The DataAdapter Explainedp. 170
Using the CommandBuilder Classp. 188
Summaryp. 191
Presenting ADO.NET: The Disconnected Layerp. 193
Using the DataSet Classp. 193
Using the DataTable Classp. 218
Using the DataView Classp. 238
Using the DataRow Classp. 245
Using the DataColumn Classp. 249
Using the DataRelation Classp. 252
Looking at Cursorsp. 261
Examining Data Source Lockingp. 265
Using ""Classic"" ADO and COM Interopp. 276
Summaryp. 279
Presenting the IDE from a Database Viewpointp. 281
Using the Server Explorerp. 281
Looking at Database Projectsp. 296
Designing Databases with Visio for Enterprise Architectp. 305
Designing Databases with the Database Designerp. 306
Using the Table Designerp. 314
Designing Queries with the Query Designerp. 321
Script Editing Using the SQL Editorp. 334
Creating Typed Data Setsp. 337
Summaryp. 341
Exception Handlingp. 343
Enabling Exception Handlingp. 345
Using Two or More Exception Handlers in One Procedurep. 345
Examining the Exception Classp. 346
Handling Exceptions in the Exception Handlerp. 348
Filtering Exceptionsp. 354
Creating Your Own Exceptionp. 356
Throwing an Exceptionp. 356
Handling Data-Related Exceptionsp. 357
CLR Handling of Exceptionsp. 359
Using the Debug Classp. 359
Summaryp. 366
Using Stored Procedures, Views, and Triggersp. 367
Optimization Issuesp. 368
Using Stored Proceduresp. 373
Using Viewsp. 397
Using Triggersp. 405
Summaryp. 412
Hierarchical Databasesp. 413
Looking at LDAPp. 413
Accessing Active Directory Programmaticallyp. 415
Accessing Active Directory Using the OLE DB .NET Data Providerp. 429
Accessing Microsoft Exchange Serverp. 436
Summaryp. 448
Message Queuesp. 449
Connectionless Programmingp. 450
Taking a Quick Look at the MessageQueue Classp. 450
When to Use a Message Queuep. 451
How to Use a Message Queuep. 453
Making Message Queues Transactionalp. 480
Looking at System-Generated Queuesp. 485
Securing Your Message Queuingp. 490
Summaryp. 504
Data Wrappersp. 505
Why Use Data Wrappers?p. 505
Looking at Object Oriented Programmingp. 506
Wrapping a Databasep. 513
Summaryp. 524
Data-Bound Controlsp. 525
Data-Bound Controls vs. Manual Data Hookingp. 525
Different Controls for Different Ulsp. 526
Summaryp. 561
Example Applicationsp. 563
UserManp. 565
Identifying the UserMan Informationp. 565
Discovering the Objectsp. 566
Creating the Clientp. 582
Tips and Ideasp. 583
Summaryp. 586
Using XML with SQL Server 2000p. 587
Using SQLXML 2.0p. 591
Summaryp. 635
Indexp. 637
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9781590590102
ISBN-10: 1590590104
Series: Expert's Voice
Audience: General
Format: Paperback
Language: English
Number Of Pages: 504
Published: 10th April 2002
Publisher: Apress
Country of Publication: US
Dimensions (cm): 23.6 x 18.82  x 3.81
Weight (kg): 1.16