且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

实体框架 - 从数据库刷新对象

更新时间:2023-02-13 14:56:44

public static Entities myEntities = new Entities();

public static Measurement GetLastMeasurement(int conditionId)
{
    myEntities.Refresh(RefreshMode.StoreWins, myEntities.Measurements);
    var allMeasurements = myEntities.Measurements.ToList();//retrieves all measurements from database

    return (from measurement in allMeasurements
            where measurement.ConditionId == conditionId
            select measurement).OrderByDescending(cd => cd.Timestamp).First();
}

当你每次使用它刷新存储时,什么意义使缓存?您可以将其标记为:

What sense makes caching when you refresh store every time you want to use it? You could chage it to:

public Measurement GetLastMeasurement(int conditionId)
{
    var entities = new Entities();
    return (from measurement in entities.Measurements
            where measurement.ConditionId == conditionId
            select measurement).OrderByDescending(cd => cd.Timestamp).First();
}

它还会在每次调用时查找数据库,

It also look up in database with every call, but makes much less operations.