Deal of the Day

Home » Main » Manning Forums » 2007 » LINQ in Action

Thread: Can't get Chapter 11 to work.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 3 - Pages: 1 - Last Post: Oct 12, 2009 11:19 AM by: fabrice.marguerie Threads: [ Previous | Next ]
W8GAZ

Posts: 1
From: Minnesota
Registered: 5/2/08
Can't get Chapter 11 to work.
Posted: May 2, 2008 10:39 AM
  Click to reply to this thread Reply

I'm trying to get Chapter 11 to run. I get the Amazon data but I get the following error : Invalid column name 'SubjectId'. Invalid column name 'PublisherId'.
at :
foreach(DataGridViewRow row in rows) {
row.DefaultCellStyle.BackColor = Color.LightGray;
row.Cells[0].ReadOnly = true;
row.Cells[1].Value = "** Already Exists ** - " + row.Cells[1].Value;
}

line.

steve.eichert

Posts: 22
From: Philadelphia
Registered: 5/12/07
Re: Can't get Chapter 11 to work.
Posted: May 13, 2008 8:20 AM   in response to: W8GAZ in response to: W8GAZ
  Click to reply to this thread Reply

Hello Steve,

Sorry for the delay in responding. Let me download the source code we have posted and check a couple things out. It sounds like the version of the database you are running the sample against isn't lining up with the version that the sample you are running expects.

I'll follow up shortly.

Cheers,
Steve

steve.eichert

Posts: 22
From: Philadelphia
Registered: 5/12/07
Re: Can't get Chapter 11 to work.
Posted: May 20, 2008 8:20 AM   in response to: steve.eichert in response to: steve.eichert
  Click to reply to this thread Reply

Which database are you using to try the samples? From my investigation it appears that the database that is used for the LINQ to XML samples is missing from the source code download.

We'll try and get an update released shortly. Since we already have two separate databases being used in the source code I'll try and sync them up to reduce the pain of working with the samples. I'll report back here when a new zip file is available.

Cheers,
Steve

fabrice.marguerie


Posts: 225
From: France
Registered: 4/28/06
Re: Can't get Chapter 11 to work.
Posted: Oct 12, 2009 11:19 AM   in response to: W8GAZ in response to: W8GAZ
  Click to reply to this thread Reply

This issue is fixed in the updated download file. It was not a problem with the database, but with the LINQ to SQL design file (.dbml).
I ran into this issue today and finally fixed it. Sorry for the delay.

Legend
Gold: 300 + pts
Silver: 100 - 299 pts
Bronze: 25 - 99 pts
Manning Author
Manning Staff
Manning Developmental Editor