Click here to Skip to main content
15,907,120 members
Home / Discussions / C#
   

C#

 
GeneralRe: how to making async call to proxy webreference created from asmx webservice Pin
ArunHanu15-Feb-17 19:04
ArunHanu15-Feb-17 19:04 
GeneralRe: how to making async call to proxy webreference created from asmx webservice Pin
Nathan Minier16-Feb-17 1:00
professionalNathan Minier16-Feb-17 1:00 
GeneralRe: how to making async call to proxy webreference created from asmx webservice Pin
ArunHanu16-Feb-17 22:23
ArunHanu16-Feb-17 22:23 
Questionusing @ as Text for a link Pin
Member 1299330414-Feb-17 4:54
Member 1299330414-Feb-17 4:54 
AnswerRe: using @ as Text for a link Pin
OriginalGriff14-Feb-17 6:03
mveOriginalGriff14-Feb-17 6:03 
AnswerRe: using @ as Text for a link Pin
Richard MacCutchan14-Feb-17 6:31
mveRichard MacCutchan14-Feb-17 6:31 
AnswerRe: using @ as Text for a link Pin
Richard Deeming14-Feb-17 6:42
mveRichard Deeming14-Feb-17 6:42 
Questionhow to jump to the particular section in a tab from different tab Pin
Dhyanga13-Feb-17 7:01
Dhyanga13-Feb-17 7:01 
AnswerRe: how to jump to the particular section in a tab from different tab Pin
Richard Deeming13-Feb-17 7:59
mveRichard Deeming13-Feb-17 7:59 
QuestionRead xml file from folder and extract data to database Pin
Member 1299751812-Feb-17 21:47
Member 1299751812-Feb-17 21:47 
AnswerRe: Read xml file from folder and extract data to database Pin
Pete O'Hanlon12-Feb-17 22:02
mvePete O'Hanlon12-Feb-17 22:02 
GeneralRe: Read xml file from folder and extract data to database Pin
Member 1299751813-Feb-17 7:51
Member 1299751813-Feb-17 7:51 
GeneralRe: Read xml file from folder and extract data to database Pin
Member 1299751813-Feb-17 7:52
Member 1299751813-Feb-17 7:52 
GeneralRe: Read xml file from folder and extract data to database Pin
Pete O'Hanlon13-Feb-17 8:12
mvePete O'Hanlon13-Feb-17 8:12 
AnswerRe: Read xml file from folder and extract data to database Pin
Garth J Lancaster12-Feb-17 22:32
professionalGarth J Lancaster12-Feb-17 22:32 
QuestionQuery group before and has numbered in access 2003 ? Pin
Member 245846712-Feb-17 20:57
Member 245846712-Feb-17 20:57 
AnswerRe: Query group before and has numbered in access 2003 ? Pin
Pete O'Hanlon12-Feb-17 22:01
mvePete O'Hanlon12-Feb-17 22:01 
QuestionHow to convert pdf to word(2003, 2007 and 2010)? Pin
Member 1275769511-Feb-17 3:46
Member 1275769511-Feb-17 3:46 
AnswerRe: How to convert pdf to word(2003, 2007 and 2010)? Pin
OriginalGriff11-Feb-17 4:19
mveOriginalGriff11-Feb-17 4:19 
AnswerRe: How to convert pdf to word(2003, 2007 and 2010)? Pin
Dave Kreskowiak11-Feb-17 4:56
mveDave Kreskowiak11-Feb-17 4:56 
AnswerRe: How to convert pdf to word(2003, 2007 and 2010)? Pin
Patrice T12-Feb-17 10:32
mvePatrice T12-Feb-17 10:32 
QuestionReturn List From Joined Tables Using LINQ Pin
Liagapi10-Feb-17 19:14
Liagapi10-Feb-17 19:14 
I am trying to return a list from three tables which have been joined using LINQ. At the moment I can only get a list which contains data from one table instead of all three tables.

Below is my code
C#
public List<string> GetProductDetails(string productId)
{
  var db = new ProductContext();
  IEnumerable<Employee> emps = db.Employees.ToList();
  IEnumerable<Project> projs= db.Projects.ToList();
  IEnumerable<Product> prods = db.Products.ToList();

  var productionDetails = from e in emps
  join prj in projs on e.EmployeeID equals prj.ProjectID
  join prd in prods on e.EmployeeID equals prd.productID
  where prd.productID == Convert.ToInt32(productId)
  select new {employee = e.EmployeeName, project = prj.ProjectName , product = prd.ProductName };

  return productionDetails.Select(m=>m.EmployeeName).ToList();
}

I would like the list to contain employee, project, and product.

modified 11-Feb-17 1:22am.

AnswerRe: Return List From Joined Tables Using LINQ Pin
Garth J Lancaster10-Feb-17 20:35
professionalGarth J Lancaster10-Feb-17 20:35 
GeneralRe: Return List From Joined Tables Using LINQ Pin
Liagapi10-Feb-17 23:11
Liagapi10-Feb-17 23:11 
GeneralRe: Return List From Joined Tables Using LINQ Pin
Garth J Lancaster11-Feb-17 1:39
professionalGarth J Lancaster11-Feb-17 1:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.