i have (2) tables which have primary keys on a legacy db. i want to map non-primary key properties of these tables. for example,
USERS PROFILES
----- -------
UserId int ProfileId int
Name string ...
someId int <-----> someotherId int
using Fluent nhibernate, how do i map this relationship? also, these tables already have foreign keys, does that matter for nhibernate?