Attempting to start the data web service for the first time

[serbach]

Dear Group,

I'm running Visual Studio 2005 Professional under Windows XP x64. I
have a database in SQL Server 2005 on my local workstation that I used
for generating the data web service with the WebWidget. The database
has about 30-35 tables.

My problem is this: at the point when I click Play, I get build
errors. When I check the error list I see 128 errors, all of the same
kind:

"The type or namespace name 'Airconl' could not be found (are you
missing a using directive or an assembly reference?)"

All the errors point to the Structs.cs in the Utility folder. Here
are three lines of code from Structs.cs in the Service Call Results
region:

[XmlInclude(typeof(test.EP2005.Airconl)),
XmlInclude(typeof(test.EP2005.AirconlCollection)),
XmlInclude(typeof(test.EP2005.SearchResultsRecordset<Airconl,
AirconlCollection>)),

Every occurrence of a table name or collection name in this portion of
Structs.cs has the squiggly line under the table or collection name.
I can go no further with the demo.

Any ideas why just the Structs.cs would present a problem?

Sincerely,

Steve Erbach
Neenah, WI

[Ryan Gahl]

Hi Steve. First of all.. small world (I live in Neenah). How did you find us (have we met somewhere recently and I'm just drawing a blank, in which case I apologize)?

OK, now about the issue...

I'm going to go out on a limb here, as it could be a number of things, and suggest the first thing you look at is that you have a primary key set on all your tables. We use SubSonic under the covers, and it will not generate code for tables without PKs (yes, we need to implement better handling of that case).

If that's not your issue, then I'd need you to send me some more info in order to dig in a bit. The ideal thing would be if you could shoot me over a .sql file with your db schema scripted out so I could try generating the DAL on my end, but if that's a no-go due to proprietary stuff, we can start by just having you paste the contents of various files, starting with the Model and Controller classes of some of the tables in question.

--
Ryan Gahl
CEO
Nth Penguin, LLC
http://www.nthpenguin.com
--
WebWidgetry.com / MashupStudio.com
Future Home of the World's First Complete Web Platform
--
Inquire: 1-920-574-2218
Blog: http://www.someElement.com
LinkedIn Profile: http://www.linkedin.com/in/ryangahl