The specified value is not an instance of 'Edm.Int64'

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
johnselkirk
Posts: 10
Joined: Thu 07 Oct 2010 00:03
Location: US

The specified value is not an instance of 'Edm.Int64'

Post by johnselkirk » Wed 02 Jan 2013 21:14

I am trying to update a double value using DotConnect version 4.2.132.0 and .NET 3.5.

When I try to save the changes on a new row I get an error saying :
The specified value is not an instance of 'Edm.Int64'
When I implement the code using .NET 4.0 I don't get the issue but I am bound to 3.5 for the project deliverable :(

I have created a small sample that reproduces the error and it is on dropbox : http://dl.dropbox.com/u/2292728/TCT/Dev ... eIssue.zip

Any advice would be GREAT!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: The specified value is not an instance of 'Edm.Int64'

Post by Shalex » Thu 03 Jan 2013 14:57

We have reproduced the problem and are investigating it.

johnselkirk
Posts: 10
Joined: Thu 07 Oct 2010 00:03
Location: US

Re: The specified value is not an instance of 'Edm.Int64'

Post by johnselkirk » Mon 07 Jan 2013 12:48

Thanks,

Any idea on when there will be a fix or steps to workaround/resolve?

I am on a project timeline so just need to manage expectations.

John.

johnselkirk
Posts: 10
Joined: Thu 07 Oct 2010 00:03
Location: US

Re: The specified value is not an instance of 'Edm.Int64'

Post by johnselkirk » Tue 08 Jan 2013 10:43

I figured it out.

It was not the X, Y double columns it was the SeqNum column (Int32) that was defined in the SSDL as integer. This has not been a problem in the past but that column is part of the Key so it may make a difference.

I changed the SSDL type for the SeqNum to int32 and all is well.

Thanks for your help.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: The specified value is not an instance of 'Edm.Int64'

Post by Shalex » Wed 09 Jan 2013 08:48

Thank you for your feedback.

Pauli
Posts: 10
Joined: Thu 11 Oct 2012 14:21
Location: Finland

Re: The specified value is not an instance of 'Edm.Int64'

Post by Pauli » Sun 03 Mar 2013 14:49

Thank you John for informing the solution.

I also had same problem. I tried to found from other places until I found your solution.

From Devart people I ask, why my int32 fields has been changed to integer? I have made all changes witn ENtity Developer.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: The specified value is not an instance of 'Edm.Int64'

Post by Shalex » Mon 04 Mar 2013 17:46

Pauli wrote:From Devart people I ask, why my int32 fields has been changed to integer? I have made all changes witn ENtity Developer.
Could you please give us a detailed description of the problem? If possible, send us a test model and specify the exact steps we should follow to reproduce the issue.

Pauli
Posts: 10
Joined: Thu 11 Oct 2012 14:21
Location: Finland

Re: The specified value is not an instance of 'Edm.Int64'

Post by Pauli » Tue 05 Mar 2013 09:43

Hi
I happy that everything works now and I am too busy to write more detailed description or try to reproduce the situation. I don't know why Entity Developer changed int32 fields to integer fields.

If I find out something then I will inform you.

Post Reply