Subsonic scaffold many-to-many controls are disappearing.

Question

I'm using the SubSonic scaffold control with auto-generating many to many controls.

<subsonic:Scaffold ID="scfMain" runat="server"
    AutoGenerateManyToMany="true"></subsonic:Scaffold>

On Page_Load I'm setting the table name

scfMain.TableName = "Foo";

The many to many controls are generated by a many to many table, two foreign keys, two primary keys. This works initially, but after a while the many to many controls disappear. The only way to get them back is to restart the app somehow, either by changing the web config, recycling the app pool, or restarting the site.

Is this a known bug, or is there something I'm doing wrong? I'm seeing the same thing on my local machine, staging, and production, so it doesn't seem to be unique to one environment.

Answer 1

The many to many controls are generated by a many to many table, two foreign keys, two primary keys

Does that mean you have two primary keys in your many to many table? SubSonic does not support multiple primary keys in one table.