DevForce Community Forum : Ideablade and MySQL

DevForce Community Forum : Ideablade and MySQL http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Ideablade and MySQL Sun, 12 Apr 2026 22:20:20 -700 Tue, 30 Aug 2011 02:51:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2936 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Ideablade and MySQL : Thank you very much for the response,... http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11594#11594 Author: Deceased
Subject: 2936
Posted: 30-Aug-2011 at 2:51am

Thank you very much for the response, it is very much appreciated.

Regards

]]> Tue, 30 Aug 2011 02:51:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11594#11594 Ideablade and MySQL : Update:This is the closest article... http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11569#11569 Author: DenisK
Subject: 2936
Posted: 29-Aug-2011 at 4:22pm

Update:

This is the closest article that I've found that describes the workaround when using InnoDB engine. Not sure how up to date this is since it was written back in 2006.

http://www.techrepublic.com/article/an-introduction-to-foreign-keys-and-referential-integrity-in-mysql/6035435

]]> Mon, 29 Aug 2011 16:22:49 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11569#11569 Ideablade and MySQL : Hi Deceased;It seems that this... http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11568#11568 Author: DenisK
Subject: 2936
Posted: 29-Aug-2011 at 4:03pm

Hi Deceased;

It seems that this is a known bug. The following is a statement from the following wiki page, http://en.wikipedia.org/wiki/ADO.NET_Entity_Framework#Entity_Data_Model

Even though there exists a bug in Visual Studio 2010 which does not import foreign keys from MySql database when Entity Data Model is generated, but a workaround is available for it.

I've tried searching for the workaround but am having no luck in finding it. Perhaps you can try posting in your MySql connector provider's website/forum to see if they already have a fix for it.

Edited by DenisK - 29-Aug-2011 at 4:07pm]]> Mon, 29 Aug 2011 16:03:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11568#11568 Ideablade and MySQL : HiI've been using Ideablade... http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11557#11557 Author: Deceased
Subject: 2936
Posted: 28-Aug-2011 at 8:16pm

Hi

I've been using Ideablade with MSSQL up untill now, but now I am required to use it with a MySQL database.

I've established that Ideablade works with MySQL, but I have the following problem:

The relationships (Foreign Keys) that I create in the database are not generated in the EDMX and I have a suspicion that it has to do with the database engine that I'm using.

Am I correct in assuming this? (Or is it something else?)

If so, what engine should I be using?

At the moment my tables use the InnoDB engine...

Any help would be appreciated.

]]> Sun, 28 Aug 2011 20:16:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2936&PID=11557#11557