I have the following table: CREATE TABLE [dbo].[Exception] ( [ExceptionID]INTIDENTITY (1, 1) NOT NULL, [ParentExceptionID] INTNULL,
I have two classes, the Group class has a many to many relationship with the User class (representing the groups a user belongs to) and then the group also has a relationship of one to many with the u
I am having a problem trying to map out a many-to-many relationship , where both sides of the relationship reference the same entity. I am using Fluent NHibernate and NH3.1.
Hi using SQL Server 2008, I\'ve built a small database for a baseball league, I\'m having problem creating relationships between the Teams(PK: TeamID) and GameSchedule(PK: GameID, FK1: HomeTeamID, FK
Ok, I thought I had this but I am not getting the results that I am expecting. Hopefully someone can help.
I wasn’t sure how to really word my question and I may change it based on some feedback. When it is a good idea to have reference relationships (in my POCOs) setup so I can look up a parent record f
Hi database experts, I have a question that is more focused on theory, but I would also be interested in some pratical advices, if possible.
I have some a couple of entities. One is used for the actual product information. The second one is for the information regarding certain documentation (in this case some PDF files). I am trying to pu
I\'m making an ERD, so that I can build my shopping cart. I am confused about the relationship between Order and Customer.
Dunno how to name this properly. I have two entities in m:n relationship: Member and Role. public class Role