Expert's Voice

By: Carsten Thomsen, Manohar Kamath (Foreword by)

Write A Review

Paperback | 10 April 2002

At a Glance

Paperback
688 Pages

Dimensions(cm)
22.86 x 18.42 x 3.81

Paperback

RRP $84.99

$84.75

or 4 interest-free payments of $21.19 with

Ships in 5 to 10 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)

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $0.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Computer Programming & Software Development Object-Oriented Programming or OOP Programming & Scripting Languages Software Engineering Microsoft Programming

Foreword	p. ix
About the Author	p. xi
About the Technical Reviewer	p. xiii
Acknowledgments	p. xv
Introduction	p. xvii
Getting Started	p. 1
A Lightning-Quick Introduction to C#	p. 3
Reviewing Programming Concepts	p. 4
Getting Cozy with the VS .NET Integrated Development Environment	p. 14
Summary	p. 28
Database Programming	p. 29
Using Databases	p. 31
What Is a Database?	p. 31
Why Use a Database?	p. 32
Relational vs. Hierarchical	p. 33
What C# Programmers Need to Know About Relational Databases	p. 35
UserMan Database Schema	p. 51
Summary	p. 53
Presenting ADO.NET: The Connected Layer	p. 55
Data-Related Namespaces	p. 58
Data Providers and Drivers	p. 59
Using Command Objects	p. 123
Using the DataReader Class	p. 146
The DataAdapter Explained	p. 170
Using the CommandBuilder Class	p. 188
Summary	p. 191
Presenting ADO.NET: The Disconnected Layer	p. 193
Using the DataSet Class	p. 193
Using the DataTable Class	p. 218
Using the DataView Class	p. 238
Using the DataRow Class	p. 245
Using the DataColumn Class	p. 249
Using the DataRelation Class	p. 252
Looking at Cursors	p. 261
Examining Data Source Locking	p. 265
Using ""Classic"" ADO and COM Interop	p. 276
Summary	p. 279
Presenting the IDE from a Database Viewpoint	p. 281
Using the Server Explorer	p. 281
Looking at Database Projects	p. 296
Designing Databases with Visio for Enterprise Architect	p. 305
Designing Databases with the Database Designer	p. 306
Using the Table Designer	p. 314
Designing Queries with the Query Designer	p. 321
Script Editing Using the SQL Editor	p. 334
Creating Typed Data Sets	p. 337
Summary	p. 341
Exception Handling	p. 343
Enabling Exception Handling	p. 345
Using Two or More Exception Handlers in One Procedure	p. 345
Examining the Exception Class	p. 346
Handling Exceptions in the Exception Handler	p. 348
Filtering Exceptions	p. 354
Creating Your Own Exception	p. 356
Throwing an Exception	p. 356
Handling Data-Related Exceptions	p. 357
CLR Handling of Exceptions	p. 359
Using the Debug Class	p. 359
Summary	p. 366
Using Stored Procedures, Views, and Triggers	p. 367
Optimization Issues	p. 368
Using Stored Procedures	p. 373
Using Views	p. 397
Using Triggers	p. 405
Summary	p. 412
Hierarchical Databases	p. 413
Looking at LDAP	p. 413
Accessing Active Directory Programmatically	p. 415
Accessing Active Directory Using the OLE DB .NET Data Provider	p. 429
Accessing Microsoft Exchange Server	p. 436
Summary	p. 448
Message Queues	p. 449
Connectionless Programming	p. 450
Taking a Quick Look at the MessageQueue Class	p. 450
When to Use a Message Queue	p. 451
How to Use a Message Queue	p. 453
Making Message Queues Transactional	p. 480
Looking at System-Generated Queues	p. 485
Securing Your Message Queuing	p. 490
Summary	p. 504
Data Wrappers	p. 505
Why Use Data Wrappers?	p. 505
Looking at Object Oriented Programming	p. 506
Wrapping a Database	p. 513
Summary	p. 524
Data-Bound Controls	p. 525
Data-Bound Controls vs. Manual Data Hooking	p. 525
Different Controls for Different Uls	p. 526
Summary	p. 561
Example Applications	p. 563
UserMan	p. 565
Identifying the UserMan Information	p. 565
Discovering the Objects	p. 566
Creating the Client	p. 582
Tips and Ideas	p. 583
Summary	p. 586
Using XML with SQL Server 2000	p. 587
Using SQLXML 2.0	p. 591
Summary	p. 635
Index	p. 637
Table of Contents provided by Publisher. All Rights Reserved.

Expert's Voice

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Software Engineering

Observability Engineering

Achieving Production Excellence

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

Scenarios Engineering for Services Science

Towards Trustworthy and Reliable Services Systems with New AI

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

The Essence of Software Engineering

Design Patterns

Elements of Reusable Object-Oriented Software

Building Microservices

Designing Fine-Grained Systems 2nd Edition

The Manager`s Path

A Guide for Tech Leaders Navigating Growth and Change

Refactoring 2ed

Improving the Design of Existing Code

Arduino for Dummies

Blackwell Philosophy Anthologies

Git : Pocket Guide

A Working Introduction

Architecture Patterns with Python

Enabling Test-Driven Development, Domain-Driven Design, and Event-Driven Microservices

Swim Training Patterns

1st Edition - Plan your Training Sessions with the Power of Mathematics

Hacking For Dummies

For Dummies (Computer/Tech)

Coding All-in-One For Dummies

2nd Edition

The Psychology of Software Teams

Architectural Approach to Level Design

Second edition

User Story Mapping

Discover the Whote Story, Build the Right Product

Site Reliability Engineering

How Google Runs Production Systems

Fundamentals of Software Architecture

A Modern Engineering Approach

The Engineering Leader

Strategies for Scaling Teams and Yourself

C# 12 in a Nutshell

The Definitive Reference

Learning Modern C++ for Finance

Foundations for Quantitative Programming

Web Application Security

2nd Eidtion - Exploitation and Countermeasures for Modern Web Applications

This product is categorised by