Subsonic ActiveRecord and Foreign Key Property Names

Question

My first question is here on Stackoverflow (good luck :))

So, I have a new site, in my opinion, which I would like to create using as many “generations” as possible, due to the fact that I'm tired of coding the same material again and again.

It made me look into the SubSonic project (looked at other things created by Rob), and I really like the concept. The only thing, in my opinion, is the scenario in which I created my database model using the ASP.NET build-in membership provider.

Currently, I am faced with the fact that if I have a table Newswith a column EditorIDand CreatorIDthat are the foreign key of the table aspnet_Users, this leads me to trouble. The properties generated in my class Newswill be called aspnet_Usersandaspnet_Users1

Is there a way to capture this process and use a foreign key name or something else? I would like these properties to be called Editor and Creator, of course.

Is it possible?

Answer 1

My first thought: you do not want to do this (FK in the membership table). Although convenient - you are tying your design to another system, which can be a problem.

, - , - FK .

- , ( , 3.0), .