tags:

views:

19

answers:

1
+1  Q: 

How to add a foreign key, through the interface, to ASPNET Membership provider?

I'm using VWD 2008 Express Edition with MVC and I am trying to add a foreign key from my database to the ASPNET Membership database's Users table. Is this possible using the user interface or do I have to scrounge up some SQL every time I want to do this?

Edit: After thinking about this for a minute, I realized that maybe having an FK to a different DB wasn't even possible... I really didn't think about my question thoroughly enough, did I?

+1  A: 

There is no API for that. Script your database once you created the membership tables and use your script from there on. (BTW, you don't have to use that table structure to use the membership provider if it doesn't suit your needs.)

Maxwell Troy Milton King  2010-02-13 01:39:31
+1 this is the correct answer.
Sky Sanders  2010-02-17 19:01:51

related questions

LINQ to SQL - Nullable INT in ForeignKey = "Cannot create an association..."
Disappearing Foreign Keys in phpMyAdmin
SQL : one foreign key references primary key in one of several tables
Are foreign keys indexed automatically in SQL Server?
MySQL: How to determine foreign key relationships programmatically?
Foreign key referencing composite table
SQL design around lack of cross-database foreign key references
How do I query for foreign keys that don't match their constraints?
How to persist an enum using NHibernate
Should you make a self-referencing table column a foreign key?
Foreign keys in MySQL?
How do the Postgres foreign key 'on update' and 'on delete' options work?
Why specify primary/foreign key attributes in column names
Two foreign keys instead of primary
How do I see all foreign keys to a table or column?
Foreign Key naming scheme
Can/how do you add a circle of references without breaking RI?
SQL 2005 Foreign key between another base
Database Design Issues with relationships
Firebird 1.5.3: How to add FK with connected users to the DB?
Can foreign key constraints be temporarily disabled using TSQL?
When/Why to use Cascading in SQL Server?
Extra tables or non-specific foreign keys?
Are foreign keys really necessary in a database design?
Multiple foreign keys?