Hi All,

In my contact page there is no binding between ICategory Table and I need only CategoryId column from ICategory table based on the category column whose value will be sent by the user(User will pass category value from text box). Is there any method by which we can get particular column value[CategoryID in this case ] from the table ICategory table using Icriteria and Irepository methods.

Thanks in advance

With Regards,

Mayank Pant

If you're only getting one row back, you can use a UniqeResult:

    Sage.Platform.RepositoryHelper<Sage.Entity.Interfaces.ICategory> f = Sage.Platform.EntityFactory.GetRepositoryHelper<Sage.Entity.Interfaces.ICategory>();
    Sage.Platform.Repository.ICriteria crit = f.CreateCriteria();
    crit.Add(f.EF.Eq("CategoryName", "SomeValue"));
    crit.SetProjection(f.PF.Property("Id"));
    String sId = crit.UniqueResult<System.String>();

Thanks, but I only need a particular column value from the record, "CategoryID "  based on category value which is passed by the user. Is it possible?

That's what that code should return.  I'm assuming you have named your table "Category".  Note that it's best practive to not include the ID column in the properties as it is always referenced as "Id" regardless of what entity it is.

Thanks for help. It is working.

With Regards,

Mayank Pant.