linq inner join, not in문 질문드립니다.

Question

1. select a.role_nm, a.reg_time, a.reg_user_id, b.user_id, b.reg_time,b.reg_user_idfrom com_role a inner join com_roleuser b on a.role_id &#61; b.role_id;2. Select role_nm, reg_time, reg_user_idfrom com_role where role_id NOT IN ( Select role_id from com_roleuser);이런 쿼리를 linq 문으로 변경하고싶은데 답을 못 찾겠습니다ㅜㅜ

XeO3 · Accepted Answer

Linq간만에 써봐서.. 에러나면 말씀해 주세요 ㅎㅎ 1.from a in com_role join b in com_roleuser on a.role_id equals b.role_id select new {a.role_nm, a.reg_time, a.reg_user_id, b.user_id, b.reg_time,b.reg_user_id}2.from a in com_role where !(from b in com_roleuser select b.role_id) .Contains(a.role_id ) select new {a.role_nm, a.reg_time, a.reg_user_id} 혹은..이렇게 쓰셔도 됩니다.com_role.join(com_roleuser, a &#61;> a.role_id , b &#61;> b.role_id , (a,b) &#61;> new {a.role_nm, a.reg_time, a.reg_user_id, b.user_id, b.reg_time,b.reg_user_id}); com_role .where(a&#61;> !com_roleuser.any(b&#61;> a.role_id &#61;&#61;&#61; b.role_id)) .select(a&#61;> new {a.role_nm, a.reg_time, a.reg_user_id})

linq inner join, not in문 질문드립니다.

1개의 답변

Q&A 목록