使用直接ado.net与ORM的性能提升？(Performance gains using straight ado.net vs an ORM?)

 我没有在列表和arraylist中摆弄索引，而是将实现更改为使用通用Dictionary<tkey, tvalue>因此索引可以是简单的查找。 请记住，这会不断添加项目，因此如果经常调用，您将耗尽内存。 这里没有清理。 
 
class TimedSingleton
{
    // have a dictonary to hold the seconds
    // and the instance so we can lookup
    private static Dictionary<int, TimedSingleton> AddedPositions = new Dictionary<int, TimedSingleton>();

    private static DateTime _startTime = DateTime.Now;

    protected TimedSingleton()
    {
    }

    public static TimedSingleton Instance()
    {
        // divide by 5
        int index = (int)DateTime.Now.Subtract(_startTime).TotalSeconds / 5;
        Debug.WriteLine(index);

        // 
        TimedSingleton result;
        // if you're going to multhreed this
        lock(AddedPositions)
        {
            // try to get the index seconds ...
            if (!AddedPositions.TryGetValue(index,out result))
            {
                // not happened
                Debug.WriteLine("Created new instance");
                result = new TimedSingleton();
                // store it for later
                AddedPositions.Add(index, result);
            }
            else
            {
                // result has now a previous instance
                Debug.WriteLine("from cache");
            }
        }
        return result;
    }
}

Instead of the fiddling with the indexes in a list and arraylist I changed your implementation to use a generic Dictionary<tkey, tvalue> instead so the index can be a simple lookup. Keep in mind that this keeps adding items so if called often enough you'll run out of memory. There is no clean up here.
 
class TimedSingleton
{
    // have a dictonary to hold the seconds
    // and the instance so we can lookup
    private static Dictionary<int, TimedSingleton> AddedPositions = new Dictionary<int, TimedSingleton>();

    private static DateTime _startTime = DateTime.Now;

    protected TimedSingleton()
    {
    }

    public static TimedSingleton Instance()
    {
        // divide by 5
        int index = (int)DateTime.Now.Subtract(_startTime).TotalSeconds / 5;
        Debug.WriteLine(index);

        // 
        TimedSingleton result;
        // if you're going to multhreed this
        lock(AddedPositions)
        {
            // try to get the index seconds ...
            if (!AddedPositions.TryGetValue(index,out result))
            {
                // not happened
                Debug.WriteLine("Created new instance");
                result = new TimedSingleton();
                // store it for later
                AddedPositions.Add(index, result);
            }
            else
            {
                // result has now a previous instance
                Debug.WriteLine("from cache");
            }
        }
        return result;
    }
}