|zyciis| NHibernate 如何生成 SELECT *, NEWID() AS NEWID FROM Sys_Company 语句，谢谢


        //SELECT *, NEWID() AS NEWID FROM Sys_Company 
        [NUnit.Framework.Test]
        public void SelectALLGuidFromTableOrderBy()
        {
            var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();
            var crit = session.CreateCriteria<Model.Sys.Company>();
            crit.SetProjection(NHibernate.Criterion.Projections.ProjectionList()
                .Add(NHibernate.Criterion.Projections.SqlProjection("NEWID() AS NEWID"
                , new string[] { "NEWID" }
                , new NHibernate.Type.IType[] { NHibernate.NHibernateUtil.Guid }))
            );
            var list = crit.List();
            Console.Write(list.Count);
        }以上是生成
SELECT NEWID() AS NEWID FROM Sys_Company 
但怎么生成
SELECT *, NEWID() AS NEWID FROM Sys_Company 
谢谢