Thank you for the quick response. I received your email related to the CopyDataMembers issue this morning and I am going to test it out and reply you back with my findings. I really want the CopyDataMembers using reflection to work
I feel sad that I purchased 2 licenses for dotConnect and I am having this weird issue
. I will work on the sample you provided and respond you back asap.
On the other issue, Yes I did receive the email for CAST from INT to LONG and vice versa. I am not able to overcome that. The only way I was able to resolve the issue was to change my INT variables to LONG. This is a pain, since in prior versions of dotConnect 6.x and below this was never an issue and even though I do something like;
Code: Select all
ArticleVersion articleVersionSource = bdcSource.ArticleVersions.Single(av => av.ArticleVersionId == ArticleVersionID);
Here in the above line of Linq Expression, av.ArticleVersionId is of datatype long? of object type ArticleVersion (which is article_version table in MySQL database). On the other hand ArticleVersionID
is a variable of type INT.
FYI, the actual datatype for article_version_id (ArticleVersionId) in the database is INT(10), but when it generates the Objects and Classes using dotConnect for Linq Entity Developer tool it makes it as long?
, which is okay, but why do I have to CAST it?
The only solution I found was to make my variable which I have defined in ASP.NET as INT to LONG. Am I missing anything?
Any help would be appreciated!