Devart Forums

Hi,
I sent a message earlier with the following example query in vb.net:

Dim qry = from a in db.YourTable where a.IntegerField = CInt (“1”) select a.

This errors out when executed with the following error:
“No coercion operator is defined between types ‘System.String’ and ‘System.Int32’. “

I then tried it with int32.Parse(“1”) instead of the CInt and it works correctly.

Either way, it’s a bug as in prior versions of LinqConnect I could use the following query and it would work.

Dim qry = from a in db.YourTable where a.IntegerField = “1” select a.

This is really a big problem. I have 20+ applications and 1000’s of lines of code I would have to review and change just to do this silly cast.
Now, I realize that this is not an issue in C#, but obviously it is in vb. This should be a fairly straightforward fix on your side. Whereas it is a monstrous change on mine.
I have been unable to upgrade since version 6.8 because of one problem after the next. Please, please, get this right.
Thanks … Ed

Sorry for the delay. We have answered you via the mail.

Hey

Have any Information to the user users about this error!?
I got the same Problem and Need help to this.

THX - Have a nice evening

This issue has been fixed since dotConnect for Oracle 7.4/LinqConnect 4.1.151. Please try updating the version of the product you are using (dotConnect for Oracle/ LinqConnect) and notify us about the results.
New builds can be downloaded from http://www.devart.com/dotconnect/oracle/download.html and http://www.devart.com/linqconnect/download.html (trial versions) or from Registered Users' Area (for users with valid subscription only).

Hey

Thx for your reply
The main problem is: I use dotConnect for mySQL! - And the version I use ist the latest available (downloaded yesterday)
THX

This fix is also related to dotConnect for MySQL. We couldn't reproduce this error with the latest version. Please specify the following:
- the query that you are executing;
- the data types of each property of the entities from the query;
- the stack trace of the exception.

Also, we are sending you a sample project to the e-mail address you provided in your forum profile, please check that the letter is not blocked by your mail filter. Please make changes to it so that the issue could be reproduced and send it back to us or send us your project/model.

Hey Mariaal

I have some strange behaivors.
In your test environment, everything works really fine. - I also imported my database into your provided project and played around. - Everything is fine.
But in my big project, I got some error's. - For example the associateWith isn't working. -> But in your project it also work's.
So I think, maybe the problem is in the old version of the generated Designer/vb files.
Can I rebuild the complete DataContext Class from scratch without having to delete it (I did soooooo many changes by hand during the last 4-5 years and I don't wan't to do it again...) can I start a rebuild anyhow else?
THX for any information.

Could you please send us your sample project/model or make changes to our sample and send it back to us, so that we are able to investigate this situation and find the solution for you.

Hey

I have sent you about 4 Weeks ago an sample, where you have been able to reproduce my Problems. Are there any News about this? - Has it been fixed!?
What Kind of Status has the Problem (if not fixed yet)

THX

We are working on this issue now. We plan to fix it in the one of the nearest builds. We will inform you when the fix is available.

This same error is happening to me when using dotConnect for MySQL Professional 8.9.980.
I have to do this as a workaround...
Has it been fixed?

@dan_j
We cannot reproduce the error with a current (8.10.1152) version. Please localize the issue and send us a small test project with the corresponding DDL/DML script for reproducing.