Code:

1                this.Query
2                    .Select(this.query.IdCotista.Count().Distinct())
3                    .Where(this.query.IdCarteira == idCarteira,
4                          (this.query.Quantidade. + this.query.QuantidadeBloqueada != 0)
5                    );
6                this.Query.Load();
    

1    this.Query
2          .Select(this.query.IdCotista.Count().Distinct())
3          .Where(this.query.IdCarteira == idCarteira,
4                     (this.query.Quantidade + this.query.QuantidadeBloqueada != 0)
5           );
6    this.Query.Load();

This code used to work in the last version of Es2007.

The error now is NullReferenceException: Object reference not set to an instance of an object

Code:

1                PosicaoCotistaQuery posicaoCotistaQuery = new PosicaoCotistaQuery("p");
2                PosicaoCotistaQuery posicaoCotistaSubQuery = new PosicaoCotistaQuery("p1");
3    
4                string column = "<count(distinct sub." + PosicaoCotistaMetadata.ColumnNames.IdCotista + ") as IdCotista>";
5    
6                posicaoCotistaQuery.Select("" + column + "");
7                //
8                posicaoCotistaQuery.From
9                    (
10                       posicaoCotistaSubQuery.Select(posicaoCotistaSubQuery.IdCarteira, 
11                                                                      posicaoCotistaSubQuery.IdCotista,
12                                                                      (posicaoCotistaSubQuery.Quantidade + posicaoCotistaSubQuery.QuantidadeBloqueada).As("Quantidade"))
13                                             .Where(posicaoCotistaSubQuery.IdCarteira == idCarteira &
14                                                        posicaoCotistaSubQuery.Quantidade != 0)                                                 
15                   ).As("sub");
16   
17               PosicaoCotistaCollection posicaoCotistaCollection = new PosicaoCotistaCollection();
18               posicaoCotistaCollection.Load(posicaoCotistaQuery);
19