public static dynamic GetProjectIdForEngNum(List<string> engNums)
{
using (new TransactionScope(
TransactionScopeOption.Required,
new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted }))
{
using (var db = new ActiveDbContext())
{
var result = (
from dm in db.Set<DOCMASTER>()
join prj in db.Set<PROJECT>() on
dm.DOCNUM equals prj.DOCNUM
where
engNums.Contains(dm.C2ALIAS) &&
dm.C_ALIAS.Equals("WEBDOC", StringComparison.OrdinalIgnoreCase) &&
dm.DOCNAME.Equals("", StringComparison.OrdinalIgnoreCase)
select new { EngNum = dm.C2ALIAS, EngId = prj.PRJ_ID }).ToList();
return result;
}
}
}
