Question

Linq to SQL如何实现链接加条件查询

Answer 1

LEFT OUTER JOIN [dbo].[MemberSort] AS [t1] ON ([t1].[MemberType] =0) AND ([t0].[MemberID] = [t1].[MemberID])ORDER BY(CASEWHEN [t1].[SortNumber] IS NOT NULL THEN [t1].[SortNumber]ELSE 9999END) 希望在Linq to SQL中获得同样的支持。