Devart Forums

Posted: **Wed 22 Apr 2009 08:05**

Hi,

I have been evaluating your project. I have two major complaints. The first is that Entity Developer is not associating certain FK's. Specifically the relationship between PkrSession and PkrTable in my data model.

Second, when I run the model and so some queries, I get invalid type numeric. Now, I have read that is sometimes cause by non-recognized data types, but I am using SQL Maestro to produce the model. You guys should be able to handle its output. I will send the data model to you and code in a separate email as its still proprietary.

The bottom line is that I will totally need to use either SQL Compact or abandon LINQ. Can you help?

Posted: **Wed 22 Apr 2009 13:19**

To define the association between two tables automatically, it is necessary that the amount of the columns from the foreign key of the PokerTable table corresponds to the amount of columns from the primary key of the PokerSession table. So there are two possible ways to resolve the issue:
1) create the association in Entity Developer manually;
2) change your database schema. For example, the association will be defined automatically if you replace the PokerTable script with the following:

Code: Select all

CREATE TABLE PokerTable (
XSessGUID varchar(40) NOT NULL,
RoomID integer NOT NULL,
TimeStarted datetime,
TimeEnded datetime,
GameStructure varchar(15),
GameType varchar(15),
SmallBlind integer,
BigBlind integer,
Ante integer,
isTournament varchar(1),
TourneyBuyIn numeric(0,2),
AmountAtTable numeric(0,2),
RakePaid numeric(0,2),
NetAmount numeric(0,2),
RoomType varchar(15) NOT NULL,
PRIMARY KEY (RoomID),
/* Foreign keys */
FOREIGN KEY (XSessGUID, RoomType)
REFERENCES PokerSession(XSessGUID, RoomType)
);

We cannot reproduce the "invalid type numeric" exception with the script you have sent us using Entity Developer 2.0.11. Please try using it and notify us about the results.

Devart Forums

Beta Evaluation - Not ready for prime time

Beta Evaluation - Not ready for prime time