Leading Christian Resource for Avid Readers, Support New Schools with Every Purchase.

ADO.NET Examples and Best Practices for C# Programmers

Paperback |English |1590590120 | 9781590590126

ADO.NET Examples and Best Practices for C# Programmers

Paperback |English |1590590120 | 9781590590126
Overview
For anyone who programs with databases in the new .NET in C#,ADO.NET Examples and Best Practices for C# Programmersshows 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 usingCommandobjects 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 aDataReaderclass. Coverage here is followed by a richer tour of the options usingDataTableandDataSet, 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 DraganTopics 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.NETDataReaderobject for fast, read-only queries; using theDataTableandDataSetobjects (including building tables on the fly); filtering, sorting, and searching techniques with ADO.NET (including theDataViewobject); 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;DataRelationobjects); structured exception handling with ADO.NET; XML support in ADO.NET (includingDataSetXML 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.
ISBN: 1590590120
ISBN13: 9781590590126
Author: William R. Vaughn, Peter Blackburn
Publisher: Apress
Format: Paperback
PublicationDate: 2002-04-01
Language: English
PageCount: 358
Dimensions: 7.5 x 0.88 x 9.2 inches
Weight: 25.76 ounces
For anyone who programs with databases in the new .NET in C#,ADO.NET Examples and Best Practices for C# Programmersshows 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 usingCommandobjects 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 aDataReaderclass. Coverage here is followed by a richer tour of the options usingDataTableandDataSet, 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 DraganTopics 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.NETDataReaderobject for fast, read-only queries; using theDataTableandDataSetobjects (including building tables on the fly); filtering, sorting, and searching techniques with ADO.NET (including theDataViewobject); 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;DataRelationobjects); structured exception handling with ADO.NET; XML support in ADO.NET (includingDataSetXML 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.

Books - New and Used

The following guidelines apply to books:

  • New: A brand-new copy with cover and original protective wrapping intact. Books with markings of any kind on the cover or pages, books marked as "Bargain" or "Remainder," or with any other labels attached, may not be listed as New condition.
  • Used - Good: All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. May include "From the library of" labels. Shrink wrap, dust covers, or boxed set case may be missing. Item may be missing bundled media.
  • Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may but the dust cover may be missing. Pages may include limited notes and highlighting, but the text cannot be obscured or unreadable.

Note: Some electronic material access codes are valid only for one user. For this reason, used books, including books listed in the Used – Like New condition, may not come with functional electronic material access codes.

Shipping Fees

  • Stevens Books offers FREE SHIPPING everywhere in the United States for ALL non-book orders, and $3.99 for each book.
  • Packages are shipped from Monday to Friday.
  • No additional fees and charges.

Delivery Times

The usual time for processing an order is 24 hours (1 business day), but may vary depending on the availability of products ordered. This period excludes delivery times, which depend on your geographic location.

Estimated delivery times:

  • Standard Shipping: 5-8 business days
  • Expedited Shipping: 3-5 business days

Shipping method varies depending on what is being shipped.  

Tracking
All orders are shipped with a tracking number. Once your order has left our warehouse, a confirmation e-mail with a tracking number will be sent to you. You will be able to track your package at all times. 

Damaged Parcel
If your package has been delivered in a PO Box, please note that we are not responsible for any damage that may result (consequences of extreme temperatures, theft, etc.). 

If you have any questions regarding shipping or want to know about the status of an order, please contact us or email to support@stevensbooks.com.

You may return most items within 30 days of delivery for a full refund.

To be eligible for a return, your item must be unused and in the same condition that you received it. It must also be in the original packaging.

Several types of goods are exempt from being returned. Perishable goods such as food, flowers, newspapers or magazines cannot be returned. We also do not accept products that are intimate or sanitary goods, hazardous materials, or flammable liquids or gases.

Additional non-returnable items:

  • Gift cards
  • Downloadable software products
  • Some health and personal care items

To complete your return, we require a tracking number, which shows the items which you already returned to us.
There are certain situations where only partial refunds are granted (if applicable)

  • Book with obvious signs of use
  • CD, DVD, VHS tape, software, video game, cassette tape, or vinyl record that has been opened
  • Any item not in its original condition, is damaged or missing parts for reasons not due to our error
  • Any item that is returned more than 30 days after delivery

Items returned to us as a result of our error will receive a full refund,some returns may be subject to a restocking fee of 7% of the total item price, please contact a customer care team member to see if your return is subject. Returns that arrived on time and were as described are subject to a restocking fee.

Items returned to us that were not the result of our error, including items returned to us due to an invalid or incomplete address, will be refunded the original item price less our standard restocking fees.

If the item is returned to us for any of the following reasons, a 15% restocking fee will be applied to your refund total and you will be asked to pay for return shipping:

  • Item(s) no longer needed or wanted.
  • Item(s) returned to us due to an invalid or incomplete address.
  • Item(s) returned to us that were not a result of our error.

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, please Contact Us with your order number and details about the product you would like to return. We will respond quickly with instructions for how to return items from your order.


Shipping Cost


We'll pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.). In other cases, you will be responsible for paying for your own shipping costs for returning your item. Shipping costs are non-refundable. If you receive a refund, the cost of return shipping will be deducted from your refund.

Depending on where you live, the time it may take for your exchanged product to reach you, may vary.

If you are shipping an item over $75, you should consider using a trackable shipping service or purchasing shipping insurance. We don’t guarantee that we will receive your returned item.

$16.12

    Condition

Arrives: -
In Stock

Overview
For anyone who programs with databases in the new .NET in C#,ADO.NET Examples and Best Practices for C# Programmersshows 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 usingCommandobjects 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 aDataReaderclass. Coverage here is followed by a richer tour of the options usingDataTableandDataSet, 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 DraganTopics 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.NETDataReaderobject for fast, read-only queries; using theDataTableandDataSetobjects (including building tables on the fly); filtering, sorting, and searching techniques with ADO.NET (including theDataViewobject); 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;DataRelationobjects); structured exception handling with ADO.NET; XML support in ADO.NET (includingDataSetXML 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.
ISBN: 1590590120
ISBN13: 9781590590126
Author: William R. Vaughn, Peter Blackburn
Publisher: Apress
Format: Paperback
PublicationDate: 2002-04-01
Language: English
PageCount: 358
Dimensions: 7.5 x 0.88 x 9.2 inches
Weight: 25.76 ounces
For anyone who programs with databases in the new .NET in C#,ADO.NET Examples and Best Practices for C# Programmersshows 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 usingCommandobjects 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 aDataReaderclass. Coverage here is followed by a richer tour of the options usingDataTableandDataSet, 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 DraganTopics 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.NETDataReaderobject for fast, read-only queries; using theDataTableandDataSetobjects (including building tables on the fly); filtering, sorting, and searching techniques with ADO.NET (including theDataViewobject); 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;DataRelationobjects); structured exception handling with ADO.NET; XML support in ADO.NET (includingDataSetXML 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.

Books - New and Used

The following guidelines apply to books:

  • New: A brand-new copy with cover and original protective wrapping intact. Books with markings of any kind on the cover or pages, books marked as "Bargain" or "Remainder," or with any other labels attached, may not be listed as New condition.
  • Used - Good: All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. May include "From the library of" labels. Shrink wrap, dust covers, or boxed set case may be missing. Item may be missing bundled media.
  • Used - Acceptable: All pages and the cover are intact, but shrink wrap, dust covers, or boxed set case may be missing. Pages may include limited notes, highlighting, or minor water damage but the text is readable. Item may but the dust cover may be missing. Pages may include limited notes and highlighting, but the text cannot be obscured or unreadable.

Note: Some electronic material access codes are valid only for one user. For this reason, used books, including books listed in the Used – Like New condition, may not come with functional electronic material access codes.

Shipping Fees

  • Stevens Books offers FREE SHIPPING everywhere in the United States for ALL non-book orders, and $3.99 for each book.
  • Packages are shipped from Monday to Friday.
  • No additional fees and charges.

Delivery Times

The usual time for processing an order is 24 hours (1 business day), but may vary depending on the availability of products ordered. This period excludes delivery times, which depend on your geographic location.

Estimated delivery times:

  • Standard Shipping: 5-8 business days
  • Expedited Shipping: 3-5 business days

Shipping method varies depending on what is being shipped.  

Tracking
All orders are shipped with a tracking number. Once your order has left our warehouse, a confirmation e-mail with a tracking number will be sent to you. You will be able to track your package at all times. 

Damaged Parcel
If your package has been delivered in a PO Box, please note that we are not responsible for any damage that may result (consequences of extreme temperatures, theft, etc.). 

If you have any questions regarding shipping or want to know about the status of an order, please contact us or email to support@stevensbooks.com.

You may return most items within 30 days of delivery for a full refund.

To be eligible for a return, your item must be unused and in the same condition that you received it. It must also be in the original packaging.

Several types of goods are exempt from being returned. Perishable goods such as food, flowers, newspapers or magazines cannot be returned. We also do not accept products that are intimate or sanitary goods, hazardous materials, or flammable liquids or gases.

Additional non-returnable items:

  • Gift cards
  • Downloadable software products
  • Some health and personal care items

To complete your return, we require a tracking number, which shows the items which you already returned to us.
There are certain situations where only partial refunds are granted (if applicable)

  • Book with obvious signs of use
  • CD, DVD, VHS tape, software, video game, cassette tape, or vinyl record that has been opened
  • Any item not in its original condition, is damaged or missing parts for reasons not due to our error
  • Any item that is returned more than 30 days after delivery

Items returned to us as a result of our error will receive a full refund,some returns may be subject to a restocking fee of 7% of the total item price, please contact a customer care team member to see if your return is subject. Returns that arrived on time and were as described are subject to a restocking fee.

Items returned to us that were not the result of our error, including items returned to us due to an invalid or incomplete address, will be refunded the original item price less our standard restocking fees.

If the item is returned to us for any of the following reasons, a 15% restocking fee will be applied to your refund total and you will be asked to pay for return shipping:

  • Item(s) no longer needed or wanted.
  • Item(s) returned to us due to an invalid or incomplete address.
  • Item(s) returned to us that were not a result of our error.

You should expect to receive your refund within four weeks of giving your package to the return shipper, however, in many cases you will receive a refund more quickly. This time period includes the transit time for us to receive your return from the shipper (5 to 10 business days), the time it takes us to process your return once we receive it (3 to 5 business days), and the time it takes your bank to process our refund request (5 to 10 business days).

If you need to return an item, please Contact Us with your order number and details about the product you would like to return. We will respond quickly with instructions for how to return items from your order.


Shipping Cost


We'll pay the return shipping costs if the return is a result of our error (you received an incorrect or defective item, etc.). In other cases, you will be responsible for paying for your own shipping costs for returning your item. Shipping costs are non-refundable. If you receive a refund, the cost of return shipping will be deducted from your refund.

Depending on where you live, the time it may take for your exchanged product to reach you, may vary.

If you are shipping an item over $75, you should consider using a trackable shipping service or purchasing shipping insurance. We don’t guarantee that we will receive your returned item.

X

Oops!

Sorry, it looks like some products are not available in selected quantity.

OK

Sign up to the Stevens Books Newsletter

For the latest books, recommendations, author interviews and more

By signing up, I confirm that I'm over 16. To find out what personal data we collect and how we use it, please visit. our Privacy Policy.