RavenDb使用
在Raven中查询数据，查询条件必须在index中。
如果查询条件不在index中就会出现如下异常
var query = session.DynamicIndexQuery<ServiceProviderCallTransaction>()
.Where(x => x.LocationId == request.Id).ToList()
.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, "Courier New", courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }
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
};
}
}
最新文章
- Leetcode 259. 3Sum Smaller
- python第十九天-----Django进阶
- .NET易忘备留 ORACLE存储过程调用
- 使用 PHP 限制下载速度
- rsync实现免密码操作的一种实现方式
- spring IOC源码分析（2）
- SPBF（队列优化的Bellman-Foord）
- Guestinfo.hbm(1)The markup declarations contained or pointed to by the document type declaration must be well-formed
- 存储linux RAID6被重建成RAID5的数据恢复解决方案
- 一个web应用的诞生(11)--列表分页
- Submin1安装记录（CentOS5）
- POJ 3468 A Simple Problem with Integers（树状数组区间更新） 续
- J.U.C JMM. pipeline.指令重排序，happen-before(续)
- python -- 字符串 for循环
- BaseDao.util(虎大将军)
- kali入门
- 基于Python Pillow库生成随机验证码
- Extjs4.2+webAPI+EF实现分页以及webapi的数据传值(续）
- linux 释放内存及查看内存命令
- 201621123008 《Java 程序设计》 第九周学习总结