linq中有没有类型似sql中in 的用法

Question

假如我有一个sql语句select * from News where fatherId in {1,2,3}

用linq怎么转换呀！好像有一个是Containts，但是我的fatherId字段为整形

应该怎么写呀

---

man

Answer 1

您好

請參考 LINQ - IN 原來很簡單

---

歡迎參觀我的Blog.NET菜鳥自救會

Answer 2

假如我有一个sql语句select * from News where fatherId in {1,2,3}

用linq怎么转换呀！好像有一个是Containts，但是我的fatherId字段为整形

应该怎么写呀

---

man

    Hi.. try:

 

      var query=from n in News

                     where new int[]{1,2,3}.Contains(n.fatherId)

                    select n;

 

    http://blog.csdn.net/q107770540/archive/2010/03/17/5387946.aspx

---

Best Regards,
If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".