Question

是否有办法通过所有新的/经修改的实体,在田地建立、插入、更新的实体?

反对: 我可以找到这些实体的名单,但找不到确定实体财产价值的方法。

foreach (var item in db.ObjectStateManager.GetObjectStateEntries(EntityState.Added))
{
System.Data.Objects.DataClasses.EntityObject entity = (System.Data.Objects.DataClasses.EntityObject)(item.Entity);
// now how can I set its .inserted_at to DateTime.Now
}

我的目前解决办法

public interface IUpdateTrack
{
    DateTime? updated_at { get; set; }
    Guid? updated_by { get; set; }
}
public interface IInsertTrack
{
    DateTime? inserted_at { get; set; }
    Guid? inserted_by { get; set; }
}

部分类别中的接口

public partial class crm_customer : BaseDB.IInsertTrack, BaseDB.IUpdateTrack

储存舱

public void Save()
{
    foreach (var item in db.ObjectStateManager.GetObjectStateEntries(EntityState.Added))
    {
        System.Data.Objects.DataClasses.EntityObject entity = (System.Data.Objects.DataClasses.EntityObject)(item.Entity);
        if (item.Entity is BaseDB.IInsertTrack)
        {
            IInsertTrack insert_track = (IInsertTrack)(item.Entity);
            insert_track.inserted_at = DateTime.Now;
            insert_track.inserted_by = BaseDB.SessionContext.Current.ActiveUser.UserUid;
        }
    }
    foreach (var item in db.ObjectStateManager.GetObjectStateEntries(EntityState.Modified))
    {
        if (item.Entity is BaseDB.IUpdateTrack)
        {
            IUpdateTrack update_track = (IUpdateTrack)(item.Entity);
            update_track.updated_at = DateTime.Now;
            update_track.updated_by = BaseDB.SessionContext.Current.ActiveUser.UserUid;
        }
    }

I would like a solution that does not require implementing the interface for each class in the model, its error prone, you might forget to implement this interfaces for some classes. I am using EF4 using database-first approach.

Answer 1

Yes, there is a perfect way to accomplish this in Entity Framework 4.0, Thanks to Julia Lerman for pointing out this nice trick.


using System.Data.Common;
using System.Data.Metadata.Edm;
...

var entries = from e in db.ObjectStateManager.GetObjectStateEntries(
        EntityState.Added | EntityState.Modified)
              where e.Entity != null 
              select e;

foreach (var entry in entries) {

    var fieldMetaData = entry.CurrentValues.DataRecordInfo.FieldMetadata;
    FieldMetadata updatedAtField = fieldMetaData
        .Where(f => f.FieldType.Name == "updated_at").FirstOrDefault();

    if (updatedAtField.FieldType != null) {
       string fieldTypeName = updatedAtField.FieldType.TypeUsage.EdmType.Name;

        if (fieldTypeName == PrimitiveTypeKind.DateTime.ToString()) {
            entry.CurrentValues.SetDateTime(updatedAtField.Ordinal, 
                                            DateTime.Now);
        }
    }


}

You can then call this code from within the SavingChanges event to be sure that any updated_at field is automatically updated.

By the way, the System.Data.Metadata.Edm namespace gives you access to the PrimitiveTypeKind class.

友情链接