Geek Answers Handbook

Change “model” to add relationships in LinqPad?

I am using LinqPad to query the MyISAM MySQL database. There are foreign keys, but there are no restrictions on them, so LinqPad cannot pick up relationships. I would like to add this relationship (tell me which fields are FK) to simplify the query. Is it possible?

+5
source share
2 answers

There is no way to do this other than adding foreign key constraints. (As an interest, what is the reason for the lack of foreign key restrictions?)

+1
source

If the FK settings are not set, you have only one option.

You must connect to your tables manually using LINQ.

, , "# Program" LINQ .

+1

More articles:


All Articles