如何在linq quary中使用sql quary [英] how to use sql quary in linq quary

问题描述

如何在linq中使用sql quary

how to use sql quary in linq

select * from AcoTransaction where AcoTransactionTypeId IN (8,11,18,26,1,14,17,25,27,30,5,6,7,20,21,22,12,13,19,24)

in lin q quary不工作

in linq the quary is not working

acoTransaction = (DcAccountOperation.GetTable<AcoTransaction>()).Where(
                        p => (p.AcoTransactionTypeId in(8,11,18,26,1,14,17,25,27,30,5,6,7,20,21,22,12,13,19,24)).ToList();

推荐答案

看看这个：

http://msdn.microsoft.com/en-us/data/jj592907.aspx [ ^ ]

IN运算符可以通过'使用'来实现包含'

以下示例

IN operator can be achieved by using 'Contains'
Sample below

List<int> input = new List<int>() { 8, 11, 18, 26, 1, 14, 17, 25, 27, 30, 5, 6, 7, 20, 21, 22, 12, 13, 19, 24 };

List<int> source = new List<int>() { 8, 11, 18, 26, 1, 14, 17, 25, 27, 30, 5, 6, 7, 20, 21, 22, 12, 13, 19, 24 };

 var acoTransaction = source.Where(p => input.Contains(p) ).ToList();

这篇关于如何在linq quary中使用sql quary的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！