亚音速查询(ConditionA或ConditionB)和ConditionC [英] Subsonic Query (ConditionA OR ConditionB) AND ConditionC
本文介绍了亚音速查询(ConditionA或ConditionB)和ConditionC的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
如何构建这种格式的亚音速查询
(ConditionA或ConditionB)和
ConditionC
块引用>
㈣想尽各种办法,但我似乎无法得到期望的结果。
这里有一件事我累了:
查询q = Challenge.CreateQuery();
q.WHERE(Challenge.Columns.ChallengeeKey,playerKey)
.OR(Challenge.Columns.ChallengerKey,playerKey);
q.AND(Challenge.Columns.Complete,FALSE);
解决方案我使用亚音速2.2,我尝试了一些在罗伯的例子变化,但一直得到的消息的异常:需要至少有一个从指定的表
在此取得了理想的结果结束:
挑战挑战=新选择(),从(Challenge.Schema)
.WhereExpression(Challenge.Columns.ChallengerKey)。 IsEqualTo(playerKey)
。或(Challenge.Columns.ChallengerKey).IsGreaterThan(playerKey)
.AndExpression(Challenge.Columns.Complete).IsEqualTo(假)
.ExecuteSingle<挑战与GT;( );
How do I build a query in Subsonic that of this format
(ConditionA OR ConditionB) AND ConditionC
Iv tried various approaches but I cant seem to get the desired result.
Here is one thing i tired:
Query q = Challenge.CreateQuery(); q.WHERE(Challenge.Columns.ChallengeeKey, playerKey) .OR(Challenge.Columns.ChallengerKey, playerKey); q.AND(Challenge.Columns.Complete, false);
解决方案I'm using Subsonic 2.2, I tried a few variations on Rob's example but kept getting an exception with the message: "Need to have at least one From table specified"
In the end this achieved the desired result:
Challenge challenge = new Select().From(Challenge.Schema) .WhereExpression(Challenge.Columns.ChallengerKey).IsEqualTo(playerKey) .Or(Challenge.Columns.ChallengerKey).IsGreaterThan(playerKey) .AndExpression(Challenge.Columns.Complete).IsEqualTo(false) .ExecuteSingle<Challenge>();
这篇关于亚音速查询(ConditionA或ConditionB)和ConditionC的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文