This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
When testing an update of a one to many relationship it works fine in SQL Server, but not in MySql. The difference is I gather that a foreign key as well as the Foreign Key relationship has not been set in the MySql scenario. Is this a must in order for this to work? If so, unfortunately this can be a show stopper for us since this constrains us to a certain type of DB engine for MySql that is not optimized for the performance requirement we have.
|
|
|
Hi Tobias, No foreign key constraints are required. What is the problem you're having? Cheers, Andrew. |
|
|
Well, that's great news for us. Unfortunately I don't have the source code available right now with the problem, but I'll update this post first thing in the morning (Swedish time :) with a more detailed description of the problem I experienced.
|
|
|
Nope, still does not work. And it is not even the one to many relationship that does not work. It is actually a simple INSERT method into one table that does not work in MySql but works in SqlServer Express version. Though I am using a Value Object, so perhaps this is part of the problem? replaced some values with xxxx obviously... :) and finally the save operation in code: Now this gotta be a simple error somewhere I hope. I guess there is
a way to turn on a logging feature and receive a more detailed error
message as to the cause of the problem? |
|
|
Hi Tobias, I have created a solution (attached) which copies your code, SQL and test and it appears to work fine. Please try my code out and see if there is anything missing from your view. One important note, I have used the original MySQL provider assembly that, I believe, you have since upgraded. Note that you would need also reference (or drop into your BIN directory) the Mono.Security.dll file which is required by the provider (it is also included with the MySQL provider). Could you try that out and let me know how you get on. Cheers, John-Daniel |
|
|
This is a bug in release 1.1 which is fixed in the 1.2 upcoming version. In nightly build 20080124 it works fine. I adjusted the title of first entry this thread from previous name to make the bug easier to find for those who might be looking for it. |
|