ADO.NET Examples and Best Practices for C# Programmers

3.4 avg rating
( 5 ratings by Goodreads )
 
9781590590126: ADO.NET Examples and Best Practices for C# Programmers
View all copies of this ISBN edition:
 
 

Best-selling author Bill Vaughn gives practical advice that VB developers can use immediately to make their data access code faster and easier to write and understand.

"synopsis" may belong to another edition of this title.

Review:

For anyone who programs with databases in the new .NET in C#, ADO.NET Examples and Best Practices for C# Programmers shows you what works and what doesn't when it comes to Microsoft's latest APIs for working with databases. Filled with practical advice and recommended "best practices," this concise and useful book offers some valuable advice for anyone working with ADO.NET.

While many C# titles cover Microsoft's .NET Framework in its entirety, the focus on the APIs and programming strategies for databases makes this one a standout. This edition of the book is actually a rewrite of William Vaughn's older title, ADO Examples and Best Practices, but it adopts the same focus in showing how to do the job right when it comes to databases. The authors are clear about relating what's new and improved with ADO.NET compared to the earlier COM-based standard (referred to here as "ADOc"). Early sections delve into connecting to ADO.NET data sources (using SQL Server and ODBC).

The focus on "best practices" for fast, correct code begins with a full tour of using Command objects in ADO.NET, with hints for getting to parameters in SQL code (including stored procedures). A winning feature here is the information on Visual Studio .NET wizards for programming with database objects. (The wizard support is surprisingly powerful, and the authors show you how to start with wizard-generated code and then customize it yourself.)

The fastest way to get to data in ADO.NET is arguably using a DataReader class. Coverage here is followed by a richer tour of the options using DataTable and DataSet, which allow you to define new table structures, including relational data and disconnected data sets. Good features in this text are the authors' benchmarks for determining how to dig into ADO.NET collections to quickly find individual column data within a record. (Certain coding conventions here can really ruin performance, and you'll learn what to avoid.)

The book rounds out with a tour of XML support available in ADO.NET, including how to pass data in and out of databases through XML. A useful example that shows a Web service exposing a bit of ADO.NET database code will let you extend your ADO.NET programs across servers. A brief introduction to the relevant standards in Web services like SOAP will help you understand what goes into Web services.

Databases are a part of most every business application, so .NET developers will need to master new APIs and programming strategies in a hurry. This title fits the bill, with a handy and fast-moving tutorial that will get you going confidently with .NET and databases. --Richard Dragan

Topics covered: COM-based ActiveX Data Objects (ADOc) and ADO.NET compared; overview of ADO.NET classes and features (including XML support, data providers, disconnected data sets); connecting to data with SQL, ODBC, and ADOc data providers; using ADO.NET command objects in detail (including stored procedures and IDE support); using the ADO.NET DataReader object for fast, read-only queries; using the DataTable and DataSet objects (including building tables on the fly); filtering, sorting, and searching techniques with ADO.NET (including the DataView object); updating data with ADO.NET (adding, editing and deleting rows, validation, update strategies, using identity fields); using .NET constraints (including unique and foreign key constraints; DataRelation objects); structured exception handling with ADO.NET; XML support in ADO.NET (including DataSet XML features, DiffGrams, XML Schema); a Web service example with XML and a data set; SOAP explained; benchmark data for best practices with ADO.NET; using the DataAdapter Configuration Wizard (DACW) and other Visual Studio .NET wizards.

About the Author:

strongPeter D. Blackburn/strong is chief executive officer of Boost Data Ltd., and chief technology officer of International Network Technologies Organization Ltd. Peter studied computer science at Cambridge University in England and has worked for the last 12 years as lead consultant developer on corporate and local government distributed database systems. He has led and trained teams working with nearly all the Microsoft data access technologies, in addition to having designed and implemented heavy-duty custom-built distributed client/server databases using open source D-ISAM on UNIX platforms.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Vaughn, William R.
Published by Apress (2018)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Apress, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 1590590120

More information about this seller | Contact this seller

Buy New
US$ 40.70
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

2.

Peter Blackburn, William R. Vaughn
Published by aPress, United States (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New First Edition Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description aPress, United States, 2002. Mixed media product. Condition: New. 1st ed.. Language: English . Brand New Book ***** Print on Demand *****. Best-selling author Bill Vaughn gives practical advice that VB developers can use immediately to make their data access code faster and easier to write and understand. Seller Inventory # APC9781590590126

More information about this seller | Contact this seller

Buy New
US$ 42.10
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Peter Blackburn
Published by Apress
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Apress. Paperback. Condition: New. 358 pages. Dimensions: 9.2in. x 7.5in. x 1.0in.Written specifically for COM-based ADO developers retooling for ADO. NET using the C language, this book brings fresh insights and tips on the ADO. NET technology. Veteran authors William Vaughn and Peter Blackburn have packed this formative guide with practical advice on how to write code that is both faster running and easier to understand. The onset of the new . NET technology is forcing developers to completely rethink their data access strategies. This book helps you to do this through working examples and numerous discussions of what works and what doesnt. Derived from years of experience working with data access developers, ADO. NET Examples and Best Practices for C Programmersincludes a set of techniques proven to drastically reduce overhead, problems, and confusionfor the devleoper, the system, and the entire team. While some are quite simple to implement, others require considerable forethought to enable. This is a developers bookfull of hints, tips and notes passed on from those whove spent significant time in the . NET and C trenches. Table of Contents Introducing ADO. NET ADO. NETGetting Connected ADO. NET Command Strategies ADO. NET DataReader Strategies Using the DataTable and DataSet Filtering, Sorting, and Finding ADO. NET Update Strategies ADO. NET Constraint Strategies ADO. NET Exception Management Strategies ADO. NET and XML This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781590590126

More information about this seller | Contact this seller

Buy New
US$ 50.78
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

4.

William R. Vaughn, Peter Blackburn
Published by Apress (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Apress, 2002. Paperback. Condition: New. Seller Inventory # DADAX1590590120

More information about this seller | Contact this seller

Buy New
US$ 50.34
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

5.

Peter Blackburn, William R. Vaughn
Published by aPress, United States (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New First Edition Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description aPress, United States, 2002. Mixed media product. Condition: New. 1st ed.. Language: English . Brand New Book ***** Print on Demand *****.Best-selling author Bill Vaughn gives practical advice that VB developers can use immediately to make their data access code faster and easier to write and understand. Seller Inventory # APC9781590590126

More information about this seller | Contact this seller

Buy New
US$ 56.07
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

William R. Vaughn; Peter Blackburn
Published by Apress (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Apress, 2002. Condition: New. book. Seller Inventory # M1590590120

More information about this seller | Contact this seller

Buy New
US$ 59.42
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

William R. Vaughn; P. Blackburn
Published by Springer (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Softcover Quantity Available: 15
Print on Demand
Seller:
Rating
[?]

Book Description Springer, 2002. Condition: New. This item is printed on demand for shipment within 3 working days. Seller Inventory # LP9781590590126

More information about this seller | Contact this seller

Buy New
US$ 58.73
Convert currency

Add to Basket

Shipping: US$ 3.20
From Germany to U.S.A.
Destination, rates & speeds

8.

Vaughn, William R.
Published by Springer (2016)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Paperback Quantity Available: 1
Print on Demand
Seller:
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Springer, 2016. Paperback. Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Seller Inventory # ria9781590590126_lsuk

More information about this seller | Contact this seller

Buy New
US$ 58.30
Convert currency

Add to Basket

Shipping: US$ 5.07
From United Kingdom to U.S.A.
Destination, rates & speeds

9.

PETER BLACKBURN
Published by Apress (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Paperback Quantity Available: 1
Seller:
Herb Tandree Philosophy Books
(Stroud, GLOS, United Kingdom)
Rating
[?]

Book Description Apress, 2002. Paperback. Condition: NEW. 9781590590126 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. For all enquiries, please contact Herb Tandree Philosophy Books directly - customer service is our primary goal. Seller Inventory # HTANDREE0307514

More information about this seller | Contact this seller

Buy New
US$ 53.30
Convert currency

Add to Basket

Shipping: US$ 10.46
From United Kingdom to U.S.A.
Destination, rates & speeds

10.

Blackburn, Peter D.
Published by APress (2002)
ISBN 10: 1590590120 ISBN 13: 9781590590126
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description APress, 2002. UNK. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # LQ-9781590590126

More information about this seller | Contact this seller

Buy New
US$ 52.17
Convert currency

Add to Basket

Shipping: US$ 11.79
From United Kingdom to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book