文件名称:Friendly Query
文件大小:28KB
文件格式:DLL
更新时间:2013-05-15 16:22:11
Friendly Query
Project Description(项目说明)
SharePoint Friendly Query is a query builder library which release you from the complex CAML. Just use T-SQL liked gramma as "SELECT * from Announcement WHERE Title CONTAINS 'Erucy' ORDER BY ID DESC".
该类库使用类似T-SQL的语法实现SharePoint列表查询,从而是我们从复杂的CAML格式中解脱出来。
A Code example just like: (代码示例)
SPWeb web = SPContext.Current.Web;
string queryStr = "SELECT * FROM 通知 WHERE 标题 CONTAINS 'Erucy' AND ID > 10";
FriendlyQuery query = new FriendlyQuery(web, queryStr);
query.RowLimit = 100;
query.Scope = FriendlyQuery.QueryScope. AllItemsAndFolders;
SPListItemCollection items = query.GetItems();
foreach(SPListItem i in items)
Response.Write(i.Title + "
");