Where 附加条件 附加不上 DataClasses1DataContext aa = new DataClasses1DataContext(); System.Linq.Expressions.Expression<Func<KeHuGuanLi1, bool>> lianxiren = p1 => p1.LianXiRen.Contains("123"); var p = from item in aa.KeHuGuanLi1 select item; p.Where(lianxiren); p.ToList();
sql 没有where
SELECT [t0].[KHID], [t0].[KHName], [t0].[KHPinYin], [t0].[LianXiRen], [t0].[LianXiDianHua], [t0].[LianXiDiZhi], [t0].[ZTFlag] FROM [dbo].[KeHuGuanLi] AS [t0]