Errata
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. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted By | Date submitted | Date corrected |
---|---|---|---|---|---|
Printed | Page CD-ROM |
Practice Test question scored incorrectly |
Microsoft Press | Jul 13, 2010 | |
Printed | Page xix |
"Next, Previous, and Go To" should be "Next and Previous" |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 44 |
SQL queries are incorrect |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 54 |
Server should be System |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 103 |
"LEFT INNER JOIN" should be "INNER JOIN" |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 138 |
PROPERTY should be METHOD |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 143 |
DataSet should be DataTable |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 147 |
Incorrect description of sample code |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 175 |
SupplierLocation should be SupplierAddress |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 214 |
Incorrect column names used |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 223 |
Products should be Product |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 224 |
“FillBySupplierID and GetDataBySupplierID.” should be “FillBySupplierID.” |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 292-294 |
Multiple entries should be removed from Table 6-1 |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 321 |
Systen.Environment should be System.Diagnostics |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 364 |
VideoGameStoreDB should be VideoGameStoreDBContext |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 380 |
SELECT statement duplicated |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 409 |
OfProduct should be Of Product |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 437 |
OPERATOR should be FUNCTION |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 459 |
1943 should be 1942 |
Microsoft Press | Jul 13, 2010 | |
Printed | Page 476 |
EntityClass Model should be Entity Data Model |
Microsoft Press | Jul 13, 2010 | |
Other Digital Version | CD-ROM |
Practice Test question scored incorrectly In the practice exam included on the Companion CD, one of the questions is scored incorrectly. The question reads: "You use two DataContext instances to retrieve objects from two database tables. After modifying the returned objects, you call the SubmitChanges method on each instance of DataContext. You want changes to both databases to occur in the context of a single distributed transaction." The answer that should be marked correct reads: "Embed calls to the SubmitChanges method within a TransactionScope with TransactionScopeOption set to RequiredNew. Call Complete after the update." |
Microsoft Press | May 06, 2010 | |
Other Digital Version | CD-ROM |
Unable to answer practice test question In the practice exam, one of the questions includes instructions to select options from a list, but the list does not exist. The question begins: "You are designing an occasionally connected smart client." This question cannot be answered or scored as it is. |
Microsoft Press | May 06, 2010 | |
Printed | Page 17 |
"File, New, New File" should be "Project, Add New Item" On page 17, the last sentence is incorrect. Change: "You can also select File, New, New File from the menu bar, and choose the confi g fi le type from the window shown in Figure 1-3." To: "You can also select Project, Add New Item from the menu bar, and choose the confi g fi le type from the window shown in Figure 1-3." |
Microsoft Press | May 06, 2010 | |
Printed | Page 51 |
"Initial Catalog" should be "InitialCatalog" On page 51, the connection strings used in answer B are incorrect. Change: Dim theConnectionString As String = "Data Source=jim-pc;Initial Catalog=VideoGameStoreDB;Integrated Security=SSPI;"To: Dim theConnectionString As String = "Data Source=jim-pc;InitialCatalog=VideoGameStoreDB;Integrated Security=SSPI;"" Change: "string theConnectionString = "Data Source=jim-pc;Initial Catalog=VideoGameStoreDB;Integrated Security=SSPI;"; To: "string theConnectionString = "Data Source=jim-pc;InitialCatalog=VideoGameStoreDB;Integrated Security=SSPI;"; |
Microsoft Press | May 06, 2010 | |
Printed | Page 96 |
SqlCommand should be SqlParameterCollection On Page 96, the sentence before the bulleted list is incorrect. Change: "In addition, the SqlCommand object has an overloaded Add method, which can be used to add parameters with and without a direct reference to a SqlParameter, as shown in the following list:" To: "In addition, the SqlParameterCollection object has an overloaded Add method, which can be used to add parameters with and without a direct reference to a SqlParameter, as shown in the following list:" |
Microsoft Press | May 06, 2010 | |
Printed | Page 113 |
"Asynchronous Prossessing=true" missing from code sample On page 113, the 5th line of the C# code sample is missing a parameter. Change: Security=SSPI;";To: Security=SSPI;Asynchronous Prossessing=true;"; |
Microsoft Press | May 06, 2010 | |
Printed | Page 143 |
PROPERTY should be METHOD On page 143, the title of the first column in Table 3-4 is incorrect. Change: "PROPERTY" To: "METHOD" |
Microsoft Press | May 06, 2010 | |
Printed | Page 146 |
GetProducts should be GetProductRows On page 146, the last sentence of the second paragraph is incorrect. Change: "The SupplierRow offers a method named GetProducts, which returns an array of ProductRow objects." To: "The SupplierRow offers a method named GetProductRows, which returns an array of ProductRow objects." |
Microsoft Press | May 06, 2010 | |
Printed | Page 148 |
Incorrect tables and columns referenced in code sample explanation On page 148, the first paragraph and following code sample are incorrect. Change: For example, the following code sets the expression for the OrderLinesCount column of the Orders table: ' VB Tables("Suppliers").Columns("ProductCount").Expression = "Count(Child(Product))" // C# Tables["Suppliers "].Columns["Product Count"].Expression = "Count(Child(Product))";To: For example, the following code sets the expression for the ProductCount column of the Suppliers table: ' VB Tables("Suppliers").Columns("ProductCount").Expression = "Count(Child(Product))" // C# Tables["Suppliers"].Columns["ProductCount"].Expression = "Count(Child(Product))"; |
Microsoft Press | May 06, 2010 | |
Printed | Page 206 |
BatchUpdateSize should be UpdateBatchSize On page 206, the first sentence of step 2 is incorrect. Change: "CustomerTableAdapter does not expose the BatchUpdateSize property because this is a SqlDataAdapter-specifi c property." To: "CustomerTableAdapter does not expose the UpdateBatchSize property because this is a SqlDataAdapter-specifi c property." |
Microsoft Press | May 06, 2010 | |
Printed | Page 219 |
4-3 should be 4-4 On page 219, the last sentence before Table 4-4 is incorrect. Change: "See Table 4-3 for a list of transaction scope options." To: "See Table 4-4 for a list of transaction scope options." |
Microsoft Press | May 06, 2010 | |
Printed | Page 224 |
Incorrect instruction in step 5 On page 224, the second sentence of step 5 is incorrect. Change: "In the wizard, when entering the SQL statement, select all fields except the SupplierLocation field." To: "In the wizard, when entering the SQL statement, select all fields." |
Microsoft Press | May 06, 2010 | |
Printed | Page 230 |
scope.Commit() missing from code sample On page 230, an additional line is needed in the code sample. Change: Using scope As New TransactionScope() SaveCustomer(ds) SavePurchase(ds) End UsingTo: Using scope As New TransactionScope() SaveCustomer(ds) SavePurchase(ds) scope.Commit() End Using |
Microsoft Press | May 06, 2010 | |
Printed | Page 299 |
Incorrect description of step 3 On page 299, the descript ion of step 3 is incorrect. Change: "Inside the Main method, create an instance of the GameList class called games. Also, add a reference to the GameList namespace to the top of the file, as shown here:" To:"Create a query to retrieve the games:" |
Microsoft Press | May 06, 2010 | |
Printed | Page 330 |
"XmlReadMode.Ignore schema" should be "XmlReadMode.ReadSchema" On page 330, the last sentence is incorrect. Change: "Alternatively, you can use XML schema to define the layout and only use XmlReadMode.Ignore schema as you’ll see in the next section." To: "Alternatively, you can use XML schema to define the layout and only use XmlReadMode.ReadSchema as you’ll see in the next section." |
Microsoft Press | May 06, 2010 | |
Printed | Page 375 |
Line missing from code sample On page 375, the VB code is missing a line. Change: Select c Return query.ToList() End FunctionTo: Select c Trace.WriteLine(query.ToString()) Return query.ToList() End Function |
Microsoft Press | May 06, 2010 | |
Printed | Page 386 |
Step 7 should be removed On page 386, step 7 is incorrect and should be disregarded. |
Microsoft Press | May 06, 2010 | |
Printed | Page 410 |
Error in code sample On page 410, the 10th line of the code sample is incorrect. Change: ObjectQuery productQueryUsingNavigationProperty =To: ObjectQuery productQueryUsingNavigationProperty = |
Microsoft Press | May 06, 2010 | |
Printed | Page 455 |
Code should be Practice Files On page 455, the second sentence of the Lab section is incorrect. Change: "All the lab files can be installed from the Code folder on the companion CD." To: "All the lab files can be installed from the Practice Files folder on the companion CD." |
Microsoft Press | May 06, 2010 | |
Printed | Page 466 |
Visual Studio 7 should be Visual Studio 97 On page 466, the explanation for answer D of Question 1 of Lesson 2 is inaccurate. Change: "Correct: Typed DataSets were introduced in Visual Studio 7." To: "Correct: Typed DataSets were introduced in Visual Studio 97." |
Microsoft Press | May 06, 2010 | |
Printed | Page 479 |
DataAdapter definition is incorrect On page 479, the definition for DataAdapter is incorrect. Change: "DataReader is used to consume data in a read-only, forward-only, sequential and unbuffered fashion." To: "Represents a set of SQL commands and a database connection that are used to fill the DataSet." Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections. |
Microsoft Press | May 06, 2010 |