Errors executing my application after updating to 7.7

[malea]

Hello,

I have purchased and installed latest version of dotConnect for Oracle Professional (7.7.224).

Till now, I was using version 5.70 in my project without problems.

After updating to 7.7 version, when I launch my application I obtain two critial errors:

The first one:

"System.Security.VerificationException: Operation could destabilize the runtime".

The code:

Code: Select all

private static IEnumerable<CacheX> GetCacheX()
{
    using (var context = new Context())
    {
        return context.MYTABLE.Select(c => new CacheX
        {
            Code = c.CODE,
            Desc = c.NAME
        }).ToArray();
    }
}

The sencond one:

"base {System.SystemException}: Index was outside of the bounds of the array."

The code:

Code: Select all

var test = context.MYTABLE2.Where(c => c.CODE == "A")
                            .GroupBy(c => new { c.ID, c.NUMBER })
                            .ToArray();

I have looked for information but until now I haven't found a solution.
This code was working perfectly with version 5.70.
Could you help me?

Regards.

[MariiaI]

Thank you for the report. We have reproduced the second issue ("Index was outside of the bounds of the array" exception). We will investigate it and inform you about the results as soon as possible.

As for the first issue ("Operation could destabilize the runtime" exception), we couldn't reproduce it. We are sending you a simple test 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.

[malea]

Thank you.

Could you resend me the test project? I was having problems with my e-mail account and I have changed it in my profile.

[MariiaI]

We have sent you a sample project again, please check that the letter is not blocked by your mail filter.
Please confirm whether you received it or not.

[malea]

I have found a solution.

If I use "ToArray()" just after where clause, it works. But I don't know where is the problem yet.

For the first error:

Code: Select all

private static IEnumerable<CacheX> GetCacheX()
{
    using (var context = new Context())
    {
        return context.MYTABLE.ToArray().Select(c => new CacheX
        {
            Code = c.CODE,
            Desc = c.NAME
        }).ToArray();
    }
}

And for the second error:

Code: Select all

var test = context.MYTABLE2.Where(c => c.CODE == "A").ToArray()
                            .GroupBy(c => new { c.ID, c.NUMBER })
                            .ToArray();

PD: I have received the test project.

[MariiaI]

Thank you for the additional information.
We still can not reproduce the first problem. Could you please give us the definition of the 'CacheX' class, so that we able to investigate this situation. Or, please, make changes to the sample project that we have sent you so that the issue could be reproduced and send it back to us.

[MariiaI]

The bug related to the 'Index was outside of the bounds of the array' error when using GroupBy in queries is fixed.
New build of dotConnect for Oracle 7.7.242 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27136.

[malea]

Thank you for the additional information.
We still can not reproduce the first problem. Could you please give us the definition of the 'CacheX' class, so that we able to investigate this situation. Or, please, make changes to the sample project that we have sent you so that the issue could be reproduced and send it back to us.

Hello,

Sorry for the delay. I have sent a mail with my app to reproduce the first problem, because I cannot reproduce the errors with your test app.

I hope you can help me.

[MariiaI]

Thank you for the sample project. The first issue is still not reproducible on our environment.
Please specify the full stack trace of this exception and please refer to these topics, possibly there is a solution for this issue:
Link1, Link2, Link3, Link4, Link5

[malea]

Sorry, the first line of the stracktrace was not correct. Now it is correct.

en MaterializeCacheTransportista(MaterializerScope )
en Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
en Devart.Data.Linq.Engine.ObjectReader`1.c()
en System.Linq.Buffer`1..ctor(IEnumerable`1 source)
en System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
en Acceso_a_Datos.Cache.CacheSystem.GetCacheTransportistas() en C:\Users\Pepe\Desktop\GC 2.14.0.4\Acceso a Datos\Cache\CacheSystem.cs:línea 667

[MariiaI]

Thank you for the additional information. We are investigating this behaviour. We will inform you about the results as soon as any are available.

[malea]

Sorry, the first line of the stracktrace was not correct. Now it is correct.

I have read the topics you sent me and I have not found a solution.

en MaterializeCacheTransportista(MaterializerScope )
en Devart.Data.Linq.Engine.ObjectReader`1.a(T& A_0)
en Devart.Data.Linq.Engine.ObjectReader`1.c()
en System.Linq.Buffer`1..ctor(IEnumerable`1 source)
en System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
en Acceso_a_Datos.Cache.CacheSystem.GetCacheTransportistas() en C:\Users\Pepe\Desktop\GC 2.14.0.4\Acceso a Datos\Cache\CacheSystem.cs:línea 667

[MariiaI]

Thank you for the additional information. We have reproduced this issue. We are working on it and we will inform you about the results as soon as any are available.

As a workaround, you could change the definitions of CacheTransportista and CacheProveedor from struct to class or remove {get;set;} from the struct definitions.

[MariiaI]

The bug related to materializing structs in the "select new" clause is fixed.
New version of dotConnect for Oracle 7.8 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=27556.

[malea]

Thank you for the info.
I'm downloading it.