13,190
社区成员
发帖
与我相关
我的任务
分享
Context context=new Context();
var result = (from book in context.Books
where book.Price > 200
orderby book.IssueDate descending
select new
{
Name = book.Name,
IssueNumber = "#" + book.Issue
}).ToList();
Books book =new Books();
var result= OQL.From(book)
.Where(cmp=>cmp.Property(book.Price) > 200)
.OrderBy(o=>o.Desc(book.IssueDate))
.End
.MapToList(()=>new {
Name = book.Name,
IssueNumber = "#" + book.Issue
});
Books book =new Books();
book.Name="C语言程序设计(第二版)";
book.ID= 100;
EntityQuery<Book>.Instance.Update(book);
除此之外,也可以使用OQL更新,如下例子:
Books book =new Books();
book.Name="C语言程序设计(第二版)";
book.ID= 100;
OQL q=OQL.From(book)
.Update(book.Name)
.Where(book.ID)
.END;
EntityQuery<Book>.Instance.ExeucteOQL(q);
可见,SOD框架支持2种更新方式,并且没有状态跟踪问题,不需要先查询出实体再更新,跟你写SQL一样的感觉。