I already have a database schema in MySQL and am trying to use the reverse mapping wizard to make my classes. Due to the design of the schema it hard to work out what settings I need to use.
I have a table called application which has a primary id column called applicationid and some other columns that contain info about that application.
I also have a table called station which has a primary id column called stationid and then a column called stationname and have a table called User which has a primary id column called userid and then a column called username.
I then have a table called applicationassignment which does not have a primary id column but has three columns called applicationid , stationid and userid.
The reverse mapping wizard show this on the applicationassignment table
//***Telerik OpenAccess - Reverse Engineering errors***
#error No primary key fields specified.
The table data would look something like this:-
ApplicationId ApplicationName ApplicationPath
1 notepad C:\windows\notepad.exe
ApplicationId StationId UserId
1 1 0
1 0 2
1 2 0
1 0 1
As you can see a record for each assignment, I know not plesant but stuck with it.
To query the applicationassignment table I would join application,station and user. What would I need to set on the reverse mapping wizard so that it will not display the error. I.e class, collection etc..