資源簡介
優選方案是:PredicateExtensions 很方便,很強大
調用示例:
public static void Test3() { DbDataContext db = new DbDataContext(); Expression<Func<TemplateDocument, bool>> expressleft = PredicateExtensions.True<TemplateDocument>(); expressleft = expressleft.Or(t => t.CategoriesID > 3); Expression<Func<TemplateDocument, bool>> expressright = PredicateExtensions.False<TemplateDocument>(); expressright = expressright.Or(t => t.CategoriesID < 5); expressleft = expressleft.And(expressright); var sql = db.GetCommand(db.TemplateDocument.Where(expressleft).Select(t => new { t.TemplateID, t.TemplateName, t.CategoriesID })).CommandText; Console.WriteLine(sql); }
代碼片段和文件信息
#pragma?warning?disable?1591
//------------------------------------------------------------------------------
//?
//?????This?code?was?generated?by?a?tool.
//?????Runtime?Version:2.0.50727.1433
//
//?????Changes?to?this?file?may?cause?incorrect?behavior?and?will?be?lost?if
//?????the?code?is?regenerated.
//?
//------------------------------------------------------------------------------
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Data.Linq;
using?System.Data.Linq.Mapping;
using?System.Linq;
using?System.Linq.expressions;
using?System.Reflection;
public?partial?class?News?:?System.Data.Linq.DataContext
{
??#region?Extensibility?Method?Definitions
??partial?void
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????5121??2009-01-16?10:49??mywork\NewsInfo.cs
?????文件????????982??2009-01-16?10:49??mywork\NewsInfo.map
?????文件????1048576??2009-02-05?14:42??mywork\News_Data.MDF
?????文件???????1760??2009-01-19?11:43??mywork\www\Default.aspx
?????文件???????1362??2009-01-19?11:41??mywork\www\Default.aspx.cs
?????文件???????2993??2009-01-19?11:46??mywork\www\edit.aspx
?????文件???????2792??2009-01-19?16:15??mywork\www\edit.aspx.cs
?????文件??????76415??2009-01-16?09:19??mywork\www\NewsInfo.cs
?????文件??????15629??2009-01-16?09:19??mywork\www\NewsInfo.map
?????文件????????805??2009-01-19?11:31??mywork\www\search.aspx
?????文件???????8467??2009-01-16?17:03??mywork\www\web.config
?????文件???????1531??2009-01-19?13:55??mywork\www\ocx\issue\search_advance.ascx
?????文件???????2253??2009-01-19?11:02??mywork\www\ocx\issue\search_advance.ascx.cs
?????文件???????2569??2009-01-19?13:53??mywork\www\ocx\issue\search_table.ascx
?????文件???????2678??2009-01-19?16:09??mywork\www\ocx\issue\search_table.ascx.cs
?????文件???????4311??2008-08-03?22:32??mywork\www\images\button_search.jpg
?????文件???????4203??2008-07-24?10:16??mywork\www\images\search.jpg
?????文件???????4232??2008-03-04?13:54??mywork\www\css\st
?????文件?????122880??2008-09-30?22:57??mywork\www\Bin\AspNetPager.dll
?????文件??????11264??2009-02-05?14:31??mywork\www\Bin\NewsInfo.dll
?????文件??????34304??2009-02-05?14:31??mywork\www\Bin\NewsInfo.pdb
?????文件??????13651??2008-07-18?18:38??mywork\www\Bin\Net.KKcms.Web.xm
?????文件??????48640??2008-07-18?18:38??mywork\www\Bin\Net.KKcms.Web.pdb
?????文件??????32768??2008-07-18?18:38??mywork\www\Bin\Net.KKcms.Web.dll
?????文件??????31990??2008-07-18?18:38??mywork\www\Bin\Net.KKcms.Common.xm
?????文件?????398848??2008-07-18?18:38??mywork\www\Bin\Net.KKcms.Common.pdb
?????文件?????208896??2008-07-18?18:38??mywork\www\Bin\Net.KKcms.Common.dll
?????文件??????89230??2009-01-19?10:34??mywork\www\App_Code\Dynamic.cs
?????文件????????982??2009-01-16?10:49??mywork\www\App_Code\NewsInfo.map
?????文件???????1411??2009-01-19?10:04??mywork\www\App_Code\PredicateExtensions.cs
............此處省略53個文件信息
評論
共有 條評論