Subsonic ActiveRecord and foreign key property names

Question

Hi All, my first question here on Stackoverflow (wish me luck :))

So, I have a new site on my mind that I would like to create using as much "generation"-friendly stuff as possible due to the fact that I'm getting tired of coding the same stuff all over again.

This has made me take a peek at the SubSonic project (have been looking at the other stuff created by Rob as well) and I really like the concept. The only thing on my mind is the scenario where I have created my database-model using the ASP.NET "build-in" Membership provider.

The stuff I am currently facing is the fact that if I have, for example, a News table with an EditorID and a CreatorID column which are both a foreign key to the aspnet_Users table, this gets me in to kind of a trouble. The properties generated on my News class will be named aspnet_Users and aspnet_Users1

Is there some way of hijacking this process and having it make use of the foreign key name or something? I would like to have these properties called Editor and Creator of course.

Is this possible?

Answer 1

My first thought is you don't want to do this (the FK to the membership table). While convenient - you're tying your design to another system which can be an issue.

What I might suggest is having an intermediary table - Users if you will - and leave the FK relationship off.

That said - yes you should be able to tweak the templates (assuming you're using 3.0) to accomodate your needs.