Errata for MCTS Self-Paced Training Kit (Exam 70-561): Microsoft® .NET Framework 3.5—ADO.NET Application Development
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
| Version |
Location |
Description |
Submitted by |
Date submitted |
| Printed, PDF, |
Page 363
Lesson objectives |
Chapter 8: LINQ to SQL
Lesson 1: Introduction to LINQ to SQL
?After this lesson, you will be able to:
- Insert /Update/Delete data using a command
- Insert /Update/Delete data using a data adapter
- Insert/Update/Delete data using a Typed DataSet
- Change the batch size of a bulk update
- Update custom data types
- Use stored procedures to update data
- Use dynamic SQL to update data
Estimated lesson time: 45 minutes?
The objectives for this lesson are almost an exact copy of the objective for ?Chapter 4 Updating Data? ?Lesson 1: Updating Data? which is surely a mistake?
Chapter 4: Updating Data
Lesson 1: Updating Data
?After this lesson, you will be able to:
- Insert /Update/Delete data using a command
- Insert /Update/Delete data using a DataAdapter
- Insert/Update/Delete data using a Typed DataSet
- Change the batch size of a bulk update
- Update custom data types
- Use stored procedures to update data
- Use dynamic SQL to update data
Estimated lesson time: 45 minutes?
|
Brian Cowan |
Sep 02, 2010 |
| Printed |
Page 377
2nd question on Lesson Review (Chapter 8 Lesson 1) |
CommitChanges method should be replaced by SubmitChanges in all answer options A. through D. as well as solution at the end of the book.
As per MSDN http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.aspx, SubmitChanges does exist in the DataContext class, CommitChanges doesn't.
This is a technical typo.
|
David Salamanca |
Jan 17, 2013 |
| PDF |
Page 390
Exercise 2 Step 4 |
The property to be changed is not "Update" property.
"Insert" property is to be changed.
|
NARUOKA, Tomohiko |
Jan 24, 2012 |
| Printed |
Page 397
4th paragraph |
Replace:
Once you click Add, the Entity Data Model Wizard opens
By
Once you click Add, and select the ADO.NET Entity Data model from the list of available templates, the Entity Data model wizard opens.
|
David Salamanca |
Jan 18, 2013 |
| Printed |
Page 410
8th line of code onwards |
Replace
ObjectQuery productQueryUsingNavigationProperty<Product> =
theContext.Product;
foreach (Product theProduct in productQueryUsingNavigationProperty)
{
theProduct.GameReference.Load(MergeOption.AppendOnly);
if(aProduct.Game!=null)
{
System.Console.WriteLine(aProduct.Game.Developer)
}
}
by
ObjectQuery<Product> productQueryUsingNavigationProperty =
theContext.Product;
foreach (Product theProduct in productQueryUsingNavigationProperty)
{
theProduct.GameReference.Load(MergeOption.AppendOnly);
if(theProduct.Game!=null)
{
System.Console.WriteLine(theProduct.Game.Developer)
}
}
|
David Salamanca |
Jan 20, 2013 |