Õâ¸öÊÇÒ»¸ö¿ÕÖµ£¬Ò²¾ÍÊÇÎÞÌõ¼þ¡£ ²»»áÉú³ÉwhereÌõ¼þ¡£
Ìõ¼þµÄ×éºÏ
Á½¸öÌõ¼þͬʱ³ÉÁ¢£º
Products._.UnitPrice > 1 && Products._.CategoryID == 2 µÈЧsql¾ÍÊÇ unitprice>1 and categoryid=2
Á½¸öÌõ¼þ»ò
Products._.UnitPrice > 1 || Products._.CategoryID == 2 µÈЧsql¾ÍÊÇ unitprice>1 or categoryid=2 Ò²¾ÍÊÇ && ±íʾ×óÓÒÌõ¼þͬʱ³ÉÁ¢
|| ±íʾ×óÓÒÌõ¼þÓÐÒ»¸ö³ÉÁ¢¼´¿É
×é¼þÖØÔØÁ˲Ù×÷·û£º C# > >= <= < == != SQL > >= <= < = <> д·¨ºÍsqlÀàËÆ£¬Ò²·½±ã¼ÇÒäÓëÊéд¡£
µ±È»Ò²¿ÉµÈЧдΪ£º
WhereClip where = WhereClip.All;
where = where.And(Products._.UnitPrice > 1); where = where.Or(Products._.CategoryID == 2);
where.And µÈЧÓÚ && where.Or µÈЧÓÚ ||
ÓÅÏȼ¶¿ÉÓÃ()À¨ÆðÀ´£¬ÈçÏÂ
(Products._.ProductName.Contain(\) && Products._.UnitPrice > 1) || Products._.CategoryID == 2
µÈЧsql¾ÍÊÇ (productname like ¡®%apple%' and unitprice>1) or categoryid=2 Ò²µÈЧÓÚ
WhereClip where = WhereClip.All;
where = where.And(Products._.ProductName.Contain(\));
25
where = where.And(Products._.UnitPrice > 1); where = where.Or(Products._.CategoryID == 2); ÏÂÒ»½Ú½«½²ÊöFieldÖÐÉú³ÉÌõ¼þµÄ·½·¨¡£
Êý¾Ý¿â×é¼þ Hxj.Data £¨Ê®¶þ£© £¨Ä£ºý²éѯ¡¢¼òµ¥µÄin,not in²éѯ£©
Ìõ¼þµÄÉú³É¶¼ÊÇͨ¹ý¶Ô±íÖÐ×ֶνøÐеġ£ ±ÈÈ磺
Products._.UnitPrice > 1 Products._.CategoryID == 2 ÕâЩÊǼòµ¥µÄ±È½Ï¡£
ÏÂÃæÀ´½éÉÜͨ¹ýlike Ä£ºý²éѯ¸ÃÔõô×ö¡£
ÏÈÉÏ´úÂ룬Products._.ProductName.Contain(\) Õâ¾äµÈЧsql¾ÍÊÇ(sqlserver) productname like ¡®%apple%' ¾ÍÊÇÍêÈ«Ä£ºýËÑË÷¡£
Products._.ProductName.BeginWith(\)
Õâ¾äµÈЧsql¾ÍÊÇ(sqlserver) productname like ¡®apple%'£¬ÊôÓÚ×óÆ¥Å䣬²éÕÒproductnameÁÐÖÐËùÓÐÒÔapple¿ªÍ·µÄ¡£ Products._.ProductName.EndWith(\)
Õâ¾äµÈЧsql¾ÍÊÇ(sqlserver) productname like ¡®%apple'£¬ÊôÓÚÓÒÆ¥Å䣬²éÕÒproductnameÁÐÖÐËùÓÐÒÔapple½áβµÄ¡£ ÔÙÀ´¿´¿´in²éѯ
categoryid in (1,2,3) ÀàËƸÃÔõô´¦ÀíÄØ£¿ ¿´ÏÂÃæµÄÀý×Ó£º
DbSession.Default.From
.Where(Products._.CategoryID.SelectIn(1, 2, 3)) .ToList(); ¾ÍÊÇÕâô´¦ÀíµÄ¡£
26
Éú³ÉµÄsql£º
Text:
SELECT * FROM [Products] WHERE [Products].[CategoryID] IN
(@a5670053f4ae44f2a33eb5aaf54e9abf,@43f2ba0b559a45b38328b062c61f7caf,@4761cd088ce04ebf8d9670fb22417b8f)
Parameters:
@a5670053f4ae44f2a33eb5aaf54e9abf[Int32] = 1 @43f2ba0b559a45b38328b062c61f7caf[Int32] = 2 @4761cd088ce04ebf8d9670fb22417b8f[Int32] = 3
ÊDz»ÊÇ·ûºÏÒªÇóÁË°¡¡£
Èç¹ûÖªµÀProducts._.CategoryIDÀàÐÍ£¬µ±È»ÕâÀïÊÇint ÄÇÍƼöµÄд·¨ÊÇ£º
DbSession.Default.From
.Where(Products._.CategoryID.SelectIn
DbSession.Default.From
.Where(Products._.CategoryID.SelectNotIn
.ToList(); Éú³ÉµÄsql
Text:
SELECT * FROM [Products] WHERE [Products].[CategoryID] NOT IN
(@a154584666f34bfaaa16bf8ede39774f,@7d3231666b19496f925a09b13d3541d0,@184523c709334fb299a736f4c402a163)
Parameters:
@a154584666f34bfaaa16bf8ede39774f[Int32] = 1 @7d3231666b19496f925a09b13d3541d0[Int32] = 2 @184523c709334fb299a736f4c402a163[Int32] = 3
ÕâÑù²éѯÊDz»ÊDZäµÄ¼òµ¥ÁË°¡¡£ ÏÂÒ»½Ú½«½²Êö×Ó²éѯ¡£
27
Êý¾Ý¿â×é¼þ Hxj.Data £¨Ê®Èý£© £¨×Ó²éѯ£©
²éѯÌõ¼þµÄÖµÀ´×ÔÁíÍâÒ»´Î²éѯ¡£ ÀýÈç sqlserver sql:
select * from products where categoryid=(select top 1 categoryid from categories where categoryname=¡¯produce¡¯) ÕâÌõsqlµÄʵÏÖ´úÂëÈçÏ£º
DbSession.Default.From
.Where(Products._.CategoryID
.SubQueryEqual(DbSession.Default.From
\).Select(Categories._.CategoryID).Top(1))) .ToList(); ¶Ô±ÈÒ»ÏÂ×é¼þÉú³ÉµÄsql
Text:
SELECT * FROM [Products]
WHERE [Products].[CategoryID] = ( SELECT TOP 1 [Categories].[CategoryID] FROM [Categories] WHERE [Categories].[CategoryName] = @174b5c8999e2480594cdc08ab4d8e5bd)
Parameters:
@174b5c8999e2480594cdc08ab4d8e5bd[String] = Produce
×Ó²éѯ·½·¨¶ÔÓ¦sql±íÈçÏ£º ·½·¨Ãû³Æ SubQueryEqual SubQueryNotEqual SubQueryLess SubQueryLessOrEqual SubQueryGreater SubQueryGreaterOrEqual SubQueryIn SubQueryNotIn ÔÙдһ¸öÀý×Ó
sql = <> < <= > >= in not in 28