gistfile1.txt

public IList<Location> NearbyLocations(decimal latitude, decimal longitude, int distance, int excludeLocationId)
{
     var criteria = Session.CreateSQLQuery("exec NearbyLocations @Latitude=:latitude, @Longitude=:longitude, @Distance=:distance, @ExcludeId=:excludeid");

     criteria.SetDecimal("latitude", latitude);
     criteria.SetDecimal("longitude", longitude);
     criteria.SetInt32("distance", distance);
     criteria.SetInt32("excludeid", excludeLocationId);
            
     criteria.AddEntity(typeof (Location));
     criteria.SetCacheable(true);

     var results = criteria.List<Location>().ToList();

     return results;
 }