LLBLGEN v5.1 - self servicing VB .NET 4.0

Hi support team

I try to using random function in sql with Sorter newID but when it excute to GetMulti. It still loop there forever. Are you have any suggestion for this problem ? Regard.

Real code :

        Dim col = New Som0EmailQueueCollection()

        Dim qf = New QueryFactory()

        Dim newIdField = EntityFieldFactory.Create(IRIS.Som0EmailQueueFieldIndex.Id)
        newIdField.Alias = "newid()"
        newIdField.ExpressionToApply = New Expression()

        Dim sorter = New SortExpression()
        sorter.Add(New SortClause(newIdField, SortOperator.Ascending))

        col.GetMulti(Nothing, 0, sorter)

You fetch all the data, so if there are millions of rows in the table, it will take a while.

our tests work fine:

IEntityField newIDField = CustomerFields.Country;
newIDField.Alias = "NEWID()";
newIDField.ExpressionToApply = new Expression();

ISortExpression sorter = new SortExpression(new SortClause(newIDField, SortOperator.Ascending));
CustomerCollection customers = new CustomerCollection();
customers.GetMulti(null, 0, sorter, null);

Your instance of the queryfactory isn't needed btw...

Otis wrote:

You fetch all the data, so if there are millions of rows in the table, it will take a while.

our tests work fine:

IEntityField newIDField = CustomerFields.Country;
newIDField.Alias = "NEWID()";
newIDField.ExpressionToApply = new Expression();

ISortExpression sorter = new SortExpression(new SortClause(newIDField, SortOperator.Ascending));
CustomerCollection customers = new CustomerCollection();
customers.GetMulti(null, 0, sorter, null);

Your instance of the queryfactory isn't needed btw...

Thanks for your help!