Hi all,
before posting I checked the documentation a copule of times.
And I'm confused, I try something very similar to the code segment bellow, however this can't even compile on .NET.



I Get an error with something like: "Error 1 'System.Collections.IEnumerable' does not contain a definition for 'MoveNext'", Which is correct, only the interface IEnumerator have
those definitios.

Any idea if this is a bug ? Do we really have this code working on .NET or something similar to it ?

Thanks in advance for your help.
Best reagards

Luis de Sousa

Try:

IEnumerable enumerable = session.Enumerable("select count(*) from ....");
IEnumerator en = enumerable.GetEnumerator();
en.MoveNext();
int count = (int) en.Current;

(the IEnumerable interface allows you to create an enumerator).

Dragos

Hi Dragos,

I tried your approach and it worked correctly.
When working under to much pressure, some times we miss what
is right in front of our eyes!
Anyway the documentation must be corrected.
Thanks for the help, regards

Luis Filipe de Sousa

Hello!
I tried something like this:



In particular I tried:
IEnumerable enu = session.Enumerable(" from Order myOrder");

but when compiling I received this error:
Using the generic type 'System.Collections.Generic.IEnumerable<T>' requires '1' type arguments

So I assume there is something I don't know about generic in .NET 2.0....
Anyway I tried something like this:

IEnumerable<Order> enu = session.Enumerable(" from Order myOrder");

But received:
Cannot implicitly convert type 'Examples.Northwind.Order' to 'System.Collections.Generic.IEnumerable<Examples.Northwind.Order>'. An explicit conversion exists (are you missing a cast?)


Then I tried to cast it to the Order class:

IEnumerable<Order> enu = (Order) session.Enumerable(" from Order myOrder");

But then I had:
Cannot implicitly convert type 'Examples.Northwind.Order' to 'System.Collections.Generic.IEnumerable<Examples.Northwind.Order>'. An explicit conversion exists (are you missing a cast?)

What hell do I have to do for this should work?

Thanks in advance!
ema[/b]

Try

System.Collections.IEnumerable enu = session.Enumerable(" from Order myOrder");

Gert

Ok, it worked!
I feel a bit stupid about this problem ;-) but I knew it was something very easy !!



System.Collections.IEnumerable enu = session.Enumerable(" from Order myOrder");

[/quote]

Thanks Gert!
ema