LINQ To SQL 中查询语句的使用

 今天在网上看到关于LINQ To SQL中in的使用方法(http://blog.csdn.net/Code6421/archive/2008/05/30/2495480.aspx)学习到LINQ中查询的方法有以下两种，本人至今学习到的方法。

1.使用in查询

IN

C#

       var result = from s in context.Customers where (new string[] { "UK", "Lisboa" }).Contains(s.City) select s;

 

VB.NET

       Dim lists = From s In context.Customers Where (New String() {"UK", "Lisboa"}).Contains(s.City) Select s

 

NOT IN

 

C#

       var result = from s in context.Customers where !(new string[] {"UK", "Lisboa"}).Contains(s.City) select s;

VB.NET

       Dim lists = From s In context.Customers Where Not (New String() {"UK", "Lisboa"}).Contains(s.City) Select s;

 

2.使用SqlMethods.Like查询

C#

      var result = from s in context.Customers where SqlMethods.Like(s.City, string.Format("%{0}%", "Lisboa")) select s;

 

 

本人所学到的两种方法在性能方面上没有进行过比较。但是前者也更灵活的进行Not查询，后者则可以进行姓氏查询等等，都有利与弊。希望各位网友点明以及指正，谢谢。