This question is locked. New answers and comments are not allowed.
Hi All,
How can I use case statement along with select. here is my problem.
var query = from contracts in scope.Extent<VARMSContract>()
join employee in scope.Extent<VARMSEmployee>() on contracts.EmployeeID equals (employee.EmployeeID)
select new
{
ContractID = contracts.ContractID,
ContractTitle = contracts.ContractTitle,
ContractDesc = contracts.ContractDesc,
ContractStartDate = contracts.ContractStartDate,
Owner = employee.EmployeeFirstName + " " + employee.EmployeeLastName,
ContractTypeName = contracts.VARMSContractType.ContractTypeName,
CounterParty =
contracts.VARMSContractType.ContractTypeID == 1 ? Here I want a customer name from VARMSCustomer class :
contracts.VARMSContractType.ContractTypeID == 2 ? Here I want a manufacturer name from VARMSManufacturer class :
"N/A"
};
How can I do that?
How can I use case statement along with select. here is my problem.
var query = from contracts in scope.Extent<VARMSContract>()
join employee in scope.Extent<VARMSEmployee>() on contracts.EmployeeID equals (employee.EmployeeID)
select new
{
ContractID = contracts.ContractID,
ContractTitle = contracts.ContractTitle,
ContractDesc = contracts.ContractDesc,
ContractStartDate = contracts.ContractStartDate,
Owner = employee.EmployeeFirstName + " " + employee.EmployeeLastName,
ContractTypeName = contracts.VARMSContractType.ContractTypeName,
CounterParty =
contracts.VARMSContractType.ContractTypeID == 1 ? Here I want a customer name from VARMSCustomer class :
contracts.VARMSContractType.ContractTypeID == 2 ? Here I want a manufacturer name from VARMSManufacturer class :
"N/A"
};
How can I do that?