//EntityFrameWork query 예제
//Order by
GetBoardCateList().OrderBy(c => c.sort_id);
GetBoardCateList().OrderBy(c => c.id).ThenBy(c => c.sort);
GetBoardCateList().OrderByDescending(c => c.id).ThenByDescending(c => c.sort);
// index like 사용 방법
from user in _iOnBR.oncd_users
where user.sort == (
(
from userS in _iOnBR.oncd_users
where userS.user == rUser
select userS.sort
).FirstOrDefault()
)
&& user.path.StartsWith(
(
from userC in _iOnBR.oncd_users
where userC.user == rUser
select userC.path
).FirstOrDefault()
)
select userGroup
// Where 사용 방법 Connection 한번 하는 것으로 확인 됨
public List<oncd_test> GetUser(string rTesetID, string rSearch1, string rSearch2)
{
var xTests = from test in _iOnBR.oncd_tests
where test.test_id == rTestID
select user;
if (!string.IsNullOrEmpty(rSearch1)) {
xTests = xTests.Where(u => u.search1 == rSearch1);
}
if (!string.IsNullOrEmpty(rSearch2))
{
xTests = xTests.Where(u => u.search2 == rSearch2);
}
return xTests.ToList();
}