Post
by MariiaI » Fri 27 Jul 2012 10:31
Sorry for the delay. According to the latter screenshot you are using LinqConnect. Please confirm this and specify whether you need the same information about using Entity Framework.
To be able to work with the autogenerated values, you should check that the following settings are set for the entity key in your model:
- Server Data Type = SERIAL NOT NULL;
- Auto-Sync = OnInsert;
- Auto Generated Value = true.
Also, we have sent you a sample project, that demonstrates how to work with autogenerated values in PostgreSQL. Please check that the letter is not blocked by your mail filter.
As for the many-to-many association, these columns point to the columns of the junction table, to which two other tables are associated.
For example, in your case:
on the Parent side - Class Property "ClassId' corresponds to the ClassID ('Attending' class), so you should set the Column to ClassID.
on the Child side - Class Property "PersonId' corresponds to the PersonID ('Attending' class), so you should set the Column to PersonID.
In this case you should remove the 'Attending' class from your model and just specify its name in the Association Editor, as displayed on your screenshot.
In another case, if you need this class to work in the model, you should create two associations (two 1-to-many associations with the Attending class on the many side).
As for the documentation, we're working on it now. Also, we would be grateful if you specify what else is unclear about working with our ORM solutions and what else we should add to our documentation.