Problem with DB-Index

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Problem with DB-Index

Post by Zero-G. » Sat 14 Feb 2009 10:03

Hey
I don't know, if this is a bug, or a don't known issue...
Following steps to reproduce:
In mySQL create a Table with 3 Fields.
Let's say:
ID (BigInt) dID(BigInt) cID(Bigint)
All three fields have to be Primary
Then create a second table with one field
dID (BigInt)
OK - Now create a froeign key between dID SecondTable and dID First table

When yout then generate the model in the entity Designer (1.0.53) then you will see, that the designer will NOT create the association. (Maybe, he knows, that it won't work...)
Then add an association by hand, like above. - And Validate. It tells, everything is OK.
But when running a Linq with this fields, there will be an error.

So, please take a look on this behaivor

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 17 Feb 2009 12:31

Could you please provide a more detailed description of the problem?
Please post the exception message and the stack trace.
What LINQ query were you using?

Post Reply