Transformers.AliasToBean: Value cannot be null. Parameter name: key

[mazharqayyum]

Just test upgraded from version 3.3.1 to 5.0.0 from nuget. Some of our test cases are broken after upgrade and they all seems to be making use of Transformers.AliasToBean. I am not able to open latest code in Visual Studio 2015 so at the moment can't do further debugging.

at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
at NHibernate.Impl.CriteriaImpl.List(IList results)
at NHibernate.Impl.CriteriaImpl.List[T]()
at NHibernate.Impl.CriteriaImpl.Subcriteria.List[T]()`

[fredericDelaporte]

There has been some work on this result transformer in #597. There are some details about it in NH-3693.

NHibernate is using the VS2017 csproj format, so you need a compatible IDE, like JetBrains Rider or Visual Studio 2017 Community (the later can be used freely by anyone for open source projects).

[fredericDelaporte]

Without more information, this will likely be closed. We have many tests passing with this transformer, so we need a failing test case for your trouble. (What is the bean, the query, the database used, its schema involved for this case, the complete failure (not just a stack trace excerpt),...?) We do not ask you to debug NHibernate code, just your own failing code should allow to give way more information.

[mazharqayyum]

I will post the details. I was trying to sum up with a failing test case to demonstrate the issue.

[mazharqayyum]

ICriteria criteria = NHibernateHelper.CreateCriteria<Orders.Order>("O", maximumRows, startRowIndex, sortExpression)
                .CreateCriteria("Items", "OI", NHibernate.SqlCommand.JoinType.InnerJoin)
                .CreateCriteria("OI.Product", "P", NHibernate.SqlCommand.JoinType.InnerJoin)
                .Add(Restrictions.Eq("Store", store));
            Disjunction orderStatusDisjunction = new Disjunction();
            foreach (OrderStatus orderStatus in reportStatuses)
            {
                orderStatusDisjunction.Add(Restrictions.Eq("O.OrderStatus", orderStatus));
            }

            criteria.Add(orderStatusDisjunction);

            if (startDate > DateTime.MinValue)
            {
                // CONVERT DATE TO UTC
                startDate = LocaleHelper.FromLocalTime(startDate);
                criteria.Add(Restrictions.Ge("O.OrderDate", startDate));
            }

            if (endDate > DateTime.MinValue)
            {
                // CONVERT DATE TO UTC
                endDate = LocaleHelper.FromLocalTime(endDate);
                criteria.Add(Restrictions.Le("O.OrderDate", endDate));
            }

            return criteria.SetProjection(Projections.ProjectionList().Add(Projections.Property("P.Id"), "ProductId")
                .Add(Projections.Property("P.Name"), "Name")
                .Add(Projections.Sum(Projections.Cast(NHibernateUtil.Int32, Projections.Property("OI.Quantity"))), "TotalQuantity")
                .Add(Projections.Sum("OI.Price"), "TotalPrice")
                .Add(Projections.GroupProperty("P.Id"))
                .Add(Projections.GroupProperty("P.Name")))
                .SetResultTransformer(Transformers.AliasToBean(typeof(ProductSummary)))
                .List<ProductSummary>();`
public class ProductSummary
    {
        public int ProductId { get; set; }

        public string Name { get; set; }

        public int TotalQuantity { get; set; }

        public decimal TotalPrice { get; set; }
    }

Order can have multiple order items where each order item (order line item) can have a product associated.

[fredericDelaporte]

What is the database, what are the mappings of involved entities, ...? We need something similar to Stack Overflow Minimal, Complete, Verifiable Example.

[mazharqayyum]

Database is SQL Server 2012. Actually I am trying to create a test by forking the nhibernate core and following contribution document. I am having trouble setting up a test with northwind database. Is there any special base test class or a similar test case that can be used as sample. I am able to run all existing test cases by following the documentation.

[hazzik]

The test to follow is NH0000

…

On Sun, 15 Oct 2017 at 8:34 AM, Mazhar ***@***.***> wrote: Database is SQL Server 2012. Actually I am trying to create a test by forking the nhibernate core and following contribution document. I am having trouble setting up a test with northwind database. Is there any special base test class or a similar test case that can be used as sample. I am able to run all existing test cases by following the documentation. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#750 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAI1l6JIDEnUSP9wo_zs6MxXldV257Nsks5ssQzfgaJpZM4P28Mr> .

[fredericDelaporte]

Also, the CONTRIBUTING.md file at the root of the repository give some guidance for test cases.