I am trying to find the largest job number currently in the database in the entity Project.

Sage.Platform.RepositoryHelper<Sage.Entity.Interfaces.IProject> rep =
                Sage.Platform.EntityFactory.GetRepositoryHelper<Sage.Entity.Interfaces.IProject>();
Sage.Platform.Repository.ICriteria criteria = rep.CreateCriteria();
           
criteria.Add(rep.EF.Eq("ProjectType", "Insurance"));
criteria.AddOrder(rep.EF.Asc("JobNumber"));
criteria.SetProjection(rep.PF.Property("JobNumber"));
criteria.SetMaxResults(1);
           
Sage.Entity.Interfaces.IProject project = criteria.UniqueResult<Sage.Entity.Interfaces.IProject>();

Even when I take out the ProjectType criteria, I get nothing returned.  Does anyone have any thoughts on why this wouldn't be working?

Not sure you need the SetProjection - try removing that. Also you dont need a unique result as you are setting max to 1, so that can be changed too.

Could you post the equivalent SQL for this query, and also confirm it returns the correct result?

Thanks,

Nick

Figured it out.  As I was building the SQL, I realized that there are 3 different 'Project Types': Division, Project Type, and Insurance Project Type.  I was looking in the wrong one.  It should have been Division.  Thanks anyways Nick.