I've got a handful of tables during my database, one known as Task, and the other known as User. The Job table has two posts CreatedBy and ModifiedBy that map towards the UserId column within the User table.

I wish to add the consumer table towards the dbml file and add the associations. I notice since after i take a look at class I've two qualities one known as User and also the other known as User1. I'd favour it say CreatedByUser and ModifiedByUser.

Must I just use an customize the qualities or is it more beneficial to create the table in to the dbml file two times and relabel it as to the I'd look.

Just wondering what the easiest method to do this is.

Relabel the qualities. These actually are just qualities and it is ok to link it well towards the same table.