C# ISession.GetNamedQuery方法代码示例

        static void Aggregation(ISession session)
        {
            //            var customers = from c in session.Query<Customer>()
            //                            where c.CustomerAddresses.Count > 0
            //                            select c;
            //            var customers = session.CreateQuery("from Customer c where size(c.CustomerAddresses) > 0").List<Customer>();
            //            Console.WriteLine(customers.Count());

            //            var stats = from c in session.Query<Customer>()
            //                        group c by c.FirstName into grp
            //                        where grp.Count() > 10
            //                        orderby grp.Count() ascending
            //                        select new{grp.Key, Count=grp.Count()};
            //            foreach (var stat in stats)
            //            {
            //                    Console.WriteLine("{0}: {1}", stat.Key, stat.Count);
            //            }

            //            var stats = session.CreateQuery("select c.FirstName, count(c) from Customer c group by c.FirstName having count(c) > 10 order by count(c) asc")
            //                               .List<object[]>();
            var stats = session.GetNamedQuery("FirstNameCountQuery")
                               .SetParameter("mincount", 12)
                               .List<object[]>();
            foreach (var stat in stats)
            {
                Console.WriteLine("{0}: {1}", stat[0], stat[1]);
            }
        }

		/// <summary>
		/// Get an executable instance of <see cref="IQuery"/>, to actually run the query.
		/// </summary>
		public override IQuery GetExecutableQuery(ISession session)
		{
			IQuery result = session.GetNamedQuery(queryName);
			SetDefaultProperties((ISessionFactoryImplementor)session.SessionFactory);
			SetQueryProperties(result);
			return result;
		}

        private void GetColumns(ISession session)
        {
            IQuery query = session.GetNamedQuery("sp_columns");
            query.SetString("table_name", m_Name);

            IList<sp_column> columns = query
                .SetResultTransformer(Transformers.AliasToBean(typeof(sp_column)))
                .List<sp_column>();

            foreach (sp_column column in columns)
            {
                m_Columns.Add(column.COLUMN_NAME, column);
            }
        }

 /// <summary>
 /// Gets called by HibernateTemplate with an active
 /// Hibernate Session. Does not need to care about activating or closing
 /// the Session, or handling transactions.
 /// </summary>
 /// <remarks>
 /// <p>
 /// Allows for returning a result object created within the callback, i.e.
 /// a domain object or a collection of domain objects. Note that there's
 /// special support for single step actions: see HibernateTemplate.find etc.
 /// </p>
 /// </remarks>
 public object DoInHibernate(ISession session)
 {
     IQuery queryObject = session.GetNamedQuery(queryName);
     outer.PrepareQuery(queryObject);
     queryObject.SetProperties(valueObject);
     return queryObject.List();
 }

        internal static ISession CheckFirstRunTasks(ISession session)
        {
            // Return quickly
            if (!_firstRunTasksWereExecuted)
                using(new WriteLockDisposable(_firstRunTasksLocker))
                {
                    // Check again inside the lock
                    if (_firstRunTasksWereExecuted) return session;

                    try
                    {
                        // Run first-run tasks

                        // Check the aggregates
                        var maxStatus = session.QueryOver<NodeVersionStatusHistory>()
                            .Select(Projections.Max<NodeVersionStatusHistory>(x => x.Date))
                            .SingleOrDefault<DateTimeOffset>();

                        var maxAggregate = session.QueryOver<AggregateNodeStatus>()
                            .Select(Projections.Max<AggregateNodeStatus>(x => x.StatusDate))
                            .SingleOrDefault<DateTimeOffset>();

                        if (maxStatus > maxAggregate)
                        {
                            var sql = session.GetNamedQuery("AggregateNodeStatus_All")
                                .ExecuteUpdate();
                        }
                    }
                    catch (Exception ex)
                    {
                        LogHelper.Error<NhFactoryHelper>("Could not run checks against to ensure that node status aggregates are populated", ex);
                    }
                    finally
                    {
                        _firstRunTasksWereExecuted = true;                        
                    }
                }
            return session;
        }

 /// <summary>
 /// Get an executable instance of <see cref="IQuery"/>, to actually run the query.
 /// </summary>
 public override IQuery GetExecutableQuery(ISession session)
 {
     IQuery result = session.GetNamedQuery(queryName);
     SetQueryProperties(result);
     return result;
 }

 public IQuery CreateQuery(ISession session)
 {
     return session.GetNamedQuery(queryName);
 }