Possible caching data reader.

gistfile1.cs

public static SomeEntity Get(string someEntityIdentifier)
        {
            return Cache.Get(string.Format("MyCacheKey_{0}", someEntityIdentifier), CacheFrequency.Daily, () =>
                    {
                        Entity result = null;

                        DataManager.ReadFromStoredProcedure("some_entity_fetching_stored_proc", new Dictionary<string, object>
						{
							{"@id", someEntityIdentifier },
						}, reader =>
                        {
                            while (reader.Read() && result == null)
                            {
                                //do something with the record here
                            }
                        });

                        return result;
                    });
         }