RavenDb使用

在Raven中查询数据，查询条件必须在index中。

如果查询条件不在index中就会出现如下异常

                var query = session.DynamicIndexQuery<ServiceProviderCallTransaction>()
                                    .Where(x => x.LocationId == request.Id).ToList()

System.ArgumentException: The field 'LocationId' is not indexed, cannot query on fields that are not indexed

在Raven中创建Index

public class App_ActivityLog : AbstractIndexCreationTask<ActivityLog>
    {
        public App_ActivityLog()
        {
            Map = records => from record in records
                             select new
                             {
                                 Id = record.Id,
                                 ClientId = record.ClientId,
                                 ActivityDate = record.ActivityDate,
                                 CategoryId = record.CategoryId,
                                 NameId = record.NameId,
                                 StaffId = record.StaffId,
                                 Status_Value = record.Status.Value,
                                 LocationId = record.LocationId,
                                 ProcedureCode = record.ProcedureCode,
                                 Affiliation_Value = record.Affiliation.Value,
                                 SourceReferenceId = record.SourceReferenceId,
                                 ClaimId = record.ClaimId,
                                 ProgramTypeId = record.ProgramTypeId
                             };
        }
    }