C#, LINQ, Table Join 關聯欄位條件需加工處理
執行會發生錯誤
可以正常執行
- var query = from data in dbContextTT.AA
- join t2 in dbContextTT.BB on "ABC=" + data.A1 equals t2.B1
- select data;
- var query = from data in dbContextTT.AA
- join t2 in dbContextTT.BB on data.A1 equals t2.B1.Replace("ABC=", "")
- select data;
留言
張貼留言