My Wish Lists Login / Join

Database Programming with C#

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 10 to 15 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 $79.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.

Database Programming with C#

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Programming & Scripting Languages

Python Crash Course

3rd Edition - A Hands-On, Project-Based Introduction to Programming

The C Programming Language

Prentice Hall Software

Python All-in-One For Dummies

3rd Edition

Game Development with Godot 4 and C#

Develop a dynamic 3D game while exploring a robust node system, level design, and animations

Unleashing User Innovation

Multidisciplinary Perspectives on End-User Development and Generative AI

Python Workout, Second Edition

200 ten-minute exercises

Effective Modern C++

42 Specific Ways to Improve Your Use of C++11 And C++14

Introduction to Programming Languages

Typesetting Mathematics With Latex

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Artificial Intelligence Programming with Python

From Zero to Hero

Coding For Dummies, All New Edition

For Dummies (Computer/Tech)

PHP, MySQL, & JavaScript All-In-One For Dummies

For Dummies

C# 12 in a Nutshell

The Definitive Reference

Learning Go

An Idiomatic Approach to Real-World Go Programming

Code

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

Python Automation For Dummies

For Dummies (Computer/Tech)

Introduction to Machine Learning with Python

A Guide for Data Scientists

Digital Technologies for the Australian Curriculum 9 &10 Workbook

Programming Rust

Fast, Safe Systems Development 2nd Edition

Fluent Python

Clear, Concise, and Effective Programming 2nd Edition

Modern Data Analytics in Excel

Using Power Query, Power Pivot and More for Enhanced Data Analytics

Laravel: Up & Running

3rd Edition - A Framework for Building Modern PHP Apps

This product is categorised by