Select seems not to work

Zero-G. · Post by **Zero-G.** » Mon 23 Feb 2009 11:59

Hey
I use VB.NET 2008 and your latest components of dotConnect for mySQL

I try to execute the following statement:

Dim Mitarbeiter = From Query In LinqProvider.GetLinQProvider.mitarbeiters _
                              Order By Query.NName, Query.VName _
                              Select Name = Query.NName & ", " & Query.VName, ID = Query.ID

There I get the following error:
bei System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bei System.ThrowHelper.ThrowArgumentOutOfRangeException()
bei Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(List`1 A_0, List`1 A_1, OverloadArguments& A_2, IList`1& A_3, Boolean& A_4, List`1 A_5)
bei Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(List`1 A_0, List`1 A_1, List`1 A_2, Type A_3)
bei Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(l A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.c(SqlExpression A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.a(e A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.e(bg A_0)
bei Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(bg A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.a(as A_0)
bei Devart.Data.Linq.Provider.Query.DbMethodCallConverter.a(as A_0)
bei Devart.Data.Linq.Provider.Query.SqlVisitor.a(SqlNode A_0)
bei Devart.Data.Linq.Provider.DataProvider.a(a A_0, Type A_1, SqlNode A_2, ReadOnlyCollection`1 A_3)
bei Devart.Data.Linq.Provider.DataProvider.a(Expression A_0)
bei Devart.Data.Linq.Provider.DataProvider.h(Expression A_0)
bei Devart.Data.Linq.DataQuery`1.i()
bei System.Linq.SystemCore_EnumerableDebugView`1.get_Items()

I have tried around and I get this error on each statement, I try to give a new "Name" -> like Select "****" =

THX

AndreyR · Post by **AndreyR** » Wed 25 Feb 2009 10:00

We are investigating this problem. I will let you know about the results of our investigation.

AndreyR · Post by **AndreyR** » Wed 25 Feb 2009 11:19

The problem is fixed. Look forward to the next build.

Zero-G. · Post by **Zero-G.** » Wed 25 Feb 2009 12:40

Hey

When will this be? - Please don't understand it wrong, but I can not wait for a month again...

When you update the to the new version, please change the VB.NET Template at the Entity Developer - Because the last update has had the old (wrong) Template again.

If possible, I would take a pre-next-build, because everything else seems to work for me & I would be able to give it to my consumers.

THX

Zero-G. · Post by **Zero-G.** » Wed 25 Feb 2009 15:17

One more question:

Will in the upcomming Version the ENUM Type be available?

The created DataContext from the Entity Developer creates the Enum Type, but it is not supportet

THX

AndreyR · Post by **AndreyR** » Thu 26 Feb 2009 12:07

Support for the ENUM type will be added soon.
We plan to release the next build in the end of the next week.