nHibernate Storeprocedure Call

Question

I want to call the sp from the application with out specifying anything in the mapping file my sp return is a list.

public IList<INewItem> GetItemsByfilter(IList<object> Filters)
{
    // call sp with out using the mapping file sp returns a dataset
}

Answer 1

IList results = session.CreateSQLQuery("exec myStoredProcedure").List();

Or get the raw IDbConnection from session.Connection and use ADO.NET to run the stored procedure.