No code generated for one table??

0 views
Skip to first unread message

Peter

unread,
Oct 16, 2008, 6:42:02 AM10/16/08
to WebWidgetry Users
Hi,
After some initial problems (the config dlg leaves a bit to the user
to figure iout...) I managed generated a demo project against my SQL
Server database on a remote 2003 machine,

However, the generated Model for one of the tables is empty, with just
a list if "using" statements, The other three looks OK as far as I can
see.

Any idea why it failed to generate code for one specific table. The
table def looks OK to me, but maybe something is missing?

//Peter

Jerod Venema

unread,
Oct 16, 2008, 11:46:55 AM10/16/08
to webwidge...@googlegroups.com
Make sure you have a primary key on the table. It needs a primary key to generate properly.
--
Jerod Venema

Peter

unread,
Oct 16, 2008, 4:33:36 PM10/16/08
to WebWidgetry Users
Yes that was correct, I had missed that. Thanks, but maybe the
software should warn about this since the generated code doesnt
compile?
//Peter

Ryan Gahl

unread,
Oct 16, 2008, 4:44:37 PM10/16/08
to webwidge...@googlegroups.com
Hi Peter.

You're absolutely right. We have a development roadmap we're working on for these tools, and improvements like that will be coming.

I'm glad Jerod was able to help you get going. Don't hesitate to ask further questions here.

-Ryan
--
Ryan Gahl
Manager, Senior Software Engineer
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

Jerod Venema

unread,
Oct 16, 2008, 4:45:12 PM10/16/08
to webwidge...@googlegroups.com
Yep, that's a great plan!


--
Jerod Venema

kevin...@metadatastorage.com

unread,
Oct 16, 2008, 4:47:29 PM10/16/08
to webwidge...@googlegroups.com
Peter,

Subsonic is at the core of the DAL generation and by convention it does not generate code for any table that does not have a single column primary key.  This seems like a safe assumption, given primary key standards that have evolved over the last few years.  I think SubSonic should generate an exception report so that users know what is not generated.   I will mention that to Rob over at SubSonic.

Now, from nTh Penguins point of view, the class exists and they probably generate the web service methods from existing classes in the DAL.  It may make sense to not generate anything that is not properly generated in the SubSonic side.

Kevin




From: "Peter" <fshs...@gmail.com>
Sent: Thursday, October 16, 2008 4:34 PM
To: "WebWidgetry Users" <webwidge...@googlegroups.com>
Subject: [WebWidgetry] Re: No code generated for one table??



Yes that was correct, I had missed that. Thanks, but maybe the
software should warn about this since the generated code doesnt
compile?
//Peter

Ryan Gahl

unread,
Oct 16, 2008, 4:55:08 PM10/16/08
to webwidge...@googlegroups.com
Good point, Kevin. Yea, that our DAL generation is based on SubSonic (www.subsonicproject.com), is something we will explain in more depth with a forthcoming documentation release (still looking like a couple weeks out).
Reply all
Reply to author
Forward
0 new messages