Article ID: 972392 - Last Review: June 10, 2009 - Revision: 1.5

MCTS Self-Paced Training Kit (Exam 70-561): Microsoft® .NET Framework 3.5—ADO.NET Application Development comments and corrections

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

On This Page

Expand all | Collapse all

SUMMARY

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5 ADO.NET Application Development, 978-0-7356-2563-1.

The following topics are covered:

  • CD-ROM: Practice Test question scored incorrectly
  • CD-ROM: Practice Test question scored incorrectly
  • CD-ROM: Unable to answer practice test question
  • Page xix: "Next, Previous, and Go To" should be "Next and Previous"
  • Page 17: "File, New, New File" should be "Project, Add New Item"
  • Page 44: SQL queries are incorrect
  • Page 51: "Initial Catalog" should be "InitialCatalog"
  • Page 54: Server should be System
  • Page 96: SqlCommand should be SqlParameterCollection
  • Page 103: "LEFT INNER JOIN" should be "INNER JOIN"
  • Page 113: "Asynchronous Prossessing=true" missing from code sample
  • Page 138: PROPERTY should be METHOD
  • Page 143: PROPERTY should be METHOD
  • Page 143: DataSet should be DataTable
  • Page 146: GetProducts should be GetProductRows
  • Page 147: Incorrect description of sample code
  • Page 148: Incorrect tables and columns referenced in code sample explanation
  • Page 175: SupplierLocation should be SupplierAddress
  • Page 206: BatchUpdateSize should be UpdateBatchSize
  • Page 214: Incorrect column names used
  • Page 219: 4-3 should be 4-4
  • Page 223: Products should be Product
  • Page 224: Incorrect instruction in step 5
  • Page 224: “FillBySupplierID and GetDataBySupplierID.” should be “FillBySupplierID.”
  • Page 230: scope.Commit() missing from code sample
  • Pages 292-294: Multiple entries should be removed from Table 6-1
  • Page 299: Incorrect description of step 3
  • Page 321: Systen.Environment should be System.Diagnostics
  • Page 330: "XmlReadMode.Ignore schema" should be "XmlReadMode.ReadSchema"
  • Page 364: VideoGameStoreDB should be VideoGameStoreDBContext
  • Page 375: Line missing from code sample
  • Page 380: SELECT statement duplicated
  • Page 386: Step 7 should be removed
  • Page 409: OfProduct should be Of Product
  • Page 410: Error in code sample
  • Page 437: OPERATOR should be FUNCTION
  • Page 455: Code should be Practice Files
  • Page 459: 1943 should be 1942
  • Page 466: Visual Studio 7 should be Visual Studio 97
  • Page 476: EntityClass Model should be Entity Data Model
  • Page 479: DataAdapter definition is incorrect
Back to the top

MORE INFORMATION

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."

Back to the top

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 create a DbCommand to execute a query. You must retrieve a DBDataReader that you can use to access the result set. What should you do?"

The answer that should be marked correct reads:
"Use the DbCommand.ExecuteDbDataReader method to execute the command text against the connection and return a DbDataReader."

Back to the top

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.

Back to the top

Page xix: "Next, Previous, and Go To" should be "Next and Previous"

On page xix, the last sentence is incorrect.

Change:
"To take the test, answer the questions and use the Next, Previous, and Go To buttons to move from question to question."

To:
"To take the test, answer the questions and use the Next and Previous buttons to move from question to question."

Back to the top

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."

Back to the top

Page 44: SQL queries are incorrect

On page 44, the SQL queries used in the code sample are incorrect.

Change: 
theTransaction = theConnection.BeginTransaction("myFirstTransaction")

Dim theCommand As SqlCommand = New SqlCommand()
theCommand.CommandText = "SELECT top 10 * FROM game"
theCommand.CommandType = CommandType.Text
theCommand.Transaction = theTransaction
theCommand.Connection = theConnection
theCommand.ExecuteNonQuery()

Console.WriteLine("First command executed successfully.")

Dim theSecondCommand As SqlCommand = New SqlCommand()
theSecondCommand.CommandText = "SELECT top 10 * FROM accessory"

To: 
theTransaction = theConnection.BeginTransaction("myFirstTransaction")

Dim theCommand As SqlCommand = New SqlCommand()
theCommand.CommandText = "UPDATE product SET listprice = 59.99
	WHERE productid = 2020"
theCommand.CommandType = CommandType.Text
theCommand.Transaction = theTransaction
theCommand.Connection = theConnection
theCommand.ExecuteNonQuery()

Console.WriteLine("First command executed successfully.")

Dim theSecondCommand As SqlCommand = New SqlCommand()
theSecondCommand.CommandText = 
	"INSERT INTO product (ProductName, ProductDescription, ListPrice,
		ProductTypeID, ReleaseDate, ListPriceCurrency) " +
	"VALUES ('Super Fight 2', 'The sequel to the #1 XBox 360 game
		that never was', 59.99, 1, '2008-11-01', 'USD')"

Back to the top

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;";


Back to the top

Page 54: Server should be System

On page 54, the second sentence of the first paragraph is incorrect.

Change:
"This is a smart move—Microsoft supplies a number of different data providers, including the native provider for SQL Server, but third parties can supply their own (for example, when using the Oracle Relational Database Management Server (RDBMS)) or a custom data provider can be written by any competent developer."

To:
"This is a smart move—Microsoft supplies a number of different data providers, including the native provider for SQL Server, but third parties can supply their own (for example, when using the Oracle Relational Database Management System (RDBMS)) or a custom data provider can be written by any competent developer."

Back to the top

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:"

Back to the top

Page 103: "LEFT INNER JOIN" should be "INNER JOIN"

On page 103, the second line of answer A to question 2 is incorrect.

Change: 
FROM product p LEFT INNER JOIN productType pt on pt.ProductTypeID =

To: 
FROM product p INNER JOIN productType pt on pt.ProductTypeID =

Back to the top

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;";

Back to the top

Page 138: PROPERTY should be METHOD

On page 138, the title of the first column in Table 3-2 is incorrect.

Change:
"PROPERTY"

To: "METHOD"

Back to the top

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"

Back to the top

Page 143: DataSet should be DataTable

On page 143, the Description of RejectChanges in Table 3-4 is incorrect.

Change:
"Rolls back all the changes to the data in the DataSet, similar to a rollback at database level except this is done to the in-memory data."

To:
"Rolls back all the changes to the data in the DataTable, similar to a rollback at database level except this is done to the in-memory data."

Back to the top

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."

Back to the top

Page 147: Incorrect description of sample code

On page 147, the paragraph after the code sample is incorrect.

Change:
"In the previous code, the BuildDataSetWithRelation method creates two tables, adds them to the DataSet, and then proceeds to build a DataRelation between the two tables, from the ContactType fi eld in Contact to the primary key in the ContactTypes table. By enabling constraints when creating the relationship, the foreign key constraint is automatically implemented. Adding data that holds a reference to a non-existing entry in the ContactTypes table will cause an exception to be thrown. Adding the ContactTypes entry before adding the Contact works fine."

To:
"In the previous code, the BuildDataSetWithRelation method creates two tables, adds them to the DataSet, and then proceeds to build a DataRelation between the two tables, from the SupplierID field in Product to the primary key in the Supplier table. By enabling constraints when creating the relationship, the foreign key constraint is automatically implemented. Adding data that holds a reference to a non-existing entry in the Supplier table will cause an exception to be thrown. Adding the Supplier entry before adding the Product works fine."

Back to the top

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))";

Back to the top

Page 175: SupplierLocation should be SupplierAddress

On page 175, step 6 refers to an incorrect field.

Change:
"6. In the wizard, when entering the SQL statement, select all fi elds except the SupplierLocation field."

To:
"6. In the wizard, when entering the SQL statement, select all fi elds except the SupplierAddress field."

Back to the top

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."

Back to the top

Page 214: Incorrect column names used

On page 214, the third paragraph is incorrect.

Change:
"The code shown in Listing 4-2 shows how to create a relationship between two tables. The foreign key constraint is enabled, so only existing values for the ContactType fi eld are allowed. It shows that the BuildDataSetWithRelation method creates two tables, adds them to the DataSet and then proceeds to build a DataRelation between the two tables. The relationship connects the ContactType fi eld in Contact to the primary key in the ContactTypes table. By enabling constraints when creating the relationship, the foreign key constraint is automatically implemented, and adding data that holds a reference to a nonexisting ContactTypes entry causes an exception to be thrown. The correct implementation would be to add the ContactTypes entry before adding the Contact entry."

To:
"The code shown in Listing 4-2 shows how to create a relationship between two tables. The foreign key constraint is enabled, so only existing values for the SupplierID field are allowed. It shows that the BuildDataSetWithRelation method creates two tables, adds them to the DataSet and then proceeds to build a DataRelation between the two tables. The relationship connects the SupplierID field in Product to the primary key in the Supplier table. By enabling constraints when creating the relationship, the foreign key constraint is automatically implemented, and adding data that holds a reference to a nonexisting Supplier entry causes an exception to be thrown. The correct implementation would be to add the Supplier entry before adding the Product entry."

Back to the top

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."

Back to the top

Page 223: Products should be Product

On page 223, step 4 is incorrect.

Change:
"Drag the Products table onto the design surface."

To:
"Drag the Product table onto the design surface."

Back to the top

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."

Back to the top

Page 224: “FillBySupplierID and GetDataBySupplierID.” should be “FillBySupplierID.”

On page 224, steps 8.b. and 9.b. are incorrect.

Change:
"Name the query "FillBySupplierID and GetDataBySupplierID.""

To:
"Name the query "FillBySupplierID.""

Back to the top

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 Using

To: 
Using scope As New TransactionScope()
	SaveCustomer(ds)
	SavePurchase(ds)
	scope.Commit()
End Using

Back to the top

Pages 292-294: Multiple entries should be removed from Table 6-1

On pages 292-294, the following rows should be removed from Table 6-1:
Join
SelectMany
ThenBy
ThenByDescending
ToDictionary
ToLookup

Back to the top

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:"

Back to the top

Page 321: Systen.Environment should be System.Diagnostics

On page 321, the second sentence of Practice 1 is incorrect.

Change:
"Use LINQ to query the process list that is returned by System.Environment’s Process class."

To:
"Use LINQ to query the process list that is returned by System.Diagnostics’s Process class."

Back to the top

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."

Back to the top

Page 364: VideoGameStoreDB should be VideoGameStoreDBContext

On page 364, the second sentence of the "DataContext" section is incorrect.

Change:
"VideoGameStoreDB is a class that inherits from System.Data.Linq.DataContext."

To:
"VideoGameStoreDBContext is a class that inherits from System.Data.Linq.DataContext."

Back to the top

Page 375: Line missing from code sample

On page 375, the VB code is missing a line.

Change:
		Select c
	Return query.ToList()
End Function

To: 
		Select c
	Trace.WriteLine(query.ToString())
	Return query.ToList()
End Function

Back to the top

Page 380: SELECT statement duplicated

On page 380, the code sample in the UPDATE STATEMENT section is incorrect.

Change: 
exec sp_executesql N'UPDATE [dbo].[Product]
SET [ListPrice] = @p2
WHERE ([ProductID] = @p0) AND ([ProductVersion] = @p1)

SELECT [t1].[ProductVersion]
FROM [dbo].[Product] AS [t1]
WHERE ((@@ROWCOUNT) > 0) AND ([t1].[ProductID] = @p3)',
N'@p0 int,@p1 timestamp,@p2 float,
@p3 int',@p0=4,@p1=0x0000000000001696,@p2=39.930000000000007,@p3=4

SELECT [t1].[ProductVersion]'
FROM [dbo].[Product] AS [t1]
WHERE ((@@ROWCOUNT) > 0) AND ([t1].[ProductID] = @p3)',
N'@p0 int,@p1 timestamp,@p2 float,
@p3 int',@p0=4,@p1=0x0000000000001696,@p2=39.930000000000007,@p3=4

To: 
exec sp_executesql N'UPDATE [dbo].[Product]
SET [ListPrice] = @p2
WHERE ([ProductID] = @p0) AND ([ProductVersion] = @p1)

SELECT [t1].[ProductVersion]'
FROM [dbo].[Product] AS [t1]
WHERE ((@@ROWCOUNT) > 0) AND ([t1].[ProductID] = @p3)',
N'@p0 int,@p1 timestamp,@p2 float,
@p3 int',@p0=4,@p1=0x0000000000001696,@p2=39.930000000000007,@p3=4

Back to the top

Page 386: Step 7 should be removed

On page 386, step 7 is incorrect and should be disregarded.

Back to the top

Page 409: OfProduct should be Of Product

On page 409, the 14th line of the code sample is incorrect.

Change: 
ObjectQuery(OfProduct) = theContext.Product

To: 
ObjectQuery(Of Product) = theContext.Product


Back to the top

Page 410: Error in code sample

On page 410, the 10th line of the code sample is incorrect.

Change: 
ObjectQuery productQueryUsingNavigationProperty<Product> =

To: 
ObjectQuery<Product> productQueryUsingNavigationProperty =


Back to the top

Page 437: OPERATOR should be FUNCTION

On page 437, the title of the left column in Table 10-7 is incorrect.

Change:
"OPERATOR"

To:
"FUNCTION"

Back to the top

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."

Back to the top

Page 459: 1943 should be 1942

On page 459, there are three references to “1943: Joint Strike” that should read "1942:Joint Strike."

In step 6, change:
"In the else part of the if statement, change the game’s ProductName to “1943: Joint Strike” (note that the year is changing)."

To:
"In the else part of the if statement, change the game’s ProductName to “1942: Joint Strike” (note that the year is changing)."

On the 6th line of the VB code sample, change: 
game.ProductName = "1943: Joint Strike"

To: 
game.ProductName = "1942: Joint Strike"

On the 9th line of the C# code sample, change: 
game.ProductName = "1943: Joint Strike";

To: 
game.ProductName = "1942: Joint Strike";

Back to the top

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."

Back to the top

Page 476: EntityClass Model should be Entity Data Model

On page 476, the explanation of answer D to question 2 is incorrect.

Change: "Incorrect: This answer refers to the EntityClass Model source code file."

To:
"Incorrect: This answer refers to the Entity Data Model source code file."

Back to the top

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.
Back to the top
APPLIES TO
  • MCTS Self-Paced Training Kit (Exam 70-561): Microsoft .NET Framework 3.5—ADO.NET Application Development, ISBN 978-0-7356-2563-1
Back to the top
Keywords: 
KB972392
Back to the top