LINQ to SQL example for TBH

dparsons · #1 (**permalink**) April 23rd, 2008, 06:04 PM

Hello everyone,
I am going to maintain this thread as errors in the manuscript or code come to light.

The last code example directly before the section on Scalar Functions (~pg 17) displays this code as to be added:

Code:

return new Article(record.ID, record.AddedDate, record.AddedBy,
                record.CategoryID, record.tbh_Category.Title, 
                record.Title, record.Abstract, record.Body, 
                record.Country, record.State, record.City, 
                (DateTime)record.ReleaseDate, 
                (DateTime)record.ExpireDate, record.Approved,  
                record.Listed, record.CommentsEnabled,  
                record.OnlyForMembers, record.ViewCount, 
                record.Votes, record.TotalRating);

It needs to instead be:

Code:

return new Article(record.ArticleID, record.AddedDate, record.AddedBy,
                record.CategoryID, record.tbh_Category.Title, 
                record.Title, record.Abstract, record.Body, 
                record.Country, record.State, record.City, 
                (DateTime)record.ReleaseDate, 
                (DateTime)record.ExpireDate, record.Approved,  
                record.Listed, record.CommentsEnabled,  
                record.OnlyForMembers, record.ViewCount, 
                record.Votes, record.TotalRating);

This is only an issue if you are copying the code directly from the manuscript; the code download is correct.

Thanks!
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

dparsons · #2 (**permalink**) April 26th, 2008, 09:25 AM

Also on Page 17 after you have modifed your first few methods the Blox instructs:

"At this point rebuild and run your application. If you login as Admin and navigate to the Manage Articles section, for example, you will notice that it operates just as it did prior to the changes!"

This is inaccuarte because one of the last things you do is change the arguments of the GetArticleListFromArticleDetailsList to a type of: List<tbh_Article>

This is going to cause compile errors in the other methods that you have not yet edited. The last few sentences should read:

"At this point you can try to rebuild TBH but, as you will see, you need to first alter a few other methods before you will see the fruits of your labor. You will address these methods in the following sections."

Thanks to forum user: kalel_4444 for pointing out this mistake as well as the issue in my first post.

Thanks!
-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Need to download code?

Navigation