C# Linq Guid Anonymous Type Problem?

Unless I'm missing something, why don't you just select q. QuestionID instead of making a new anonymous-type wrapper? Var matchedques = from q in dc.GetTable() where q.QuestionText.

Contains(quesText) select q. QuestionID; foreach (var element in matchedques) { MessageBox. Show(element.ToString()); } Alternatively, give the field a name ( theID below) and access it directly: var matchedques = from q in dc.GetTable() where q.QuestionText.

Contains(quesText) select new{ theID = q. QuestionID }; foreach (var element in matchedques) { MessageBox. Show(element.theID.ToString()); } Apparently, there was more to the question than I first thought.In response to the comment, keep in mind that you're returning an enumeration of results in matchedques (hence the foreach above, right?

). So the following line is also in error: string qidGuidString = matchedques.ToString() You either want string qidGuidString = matchedques.Single().ToString() if matchedques should contain a single result, or a foreach loop if matchedques should contain multiple results Note that there's no reason to convert a GUID to string and back again, and you can also use the query to return something more useful (namely, a new DateLastUsed object): var matchedques = from q in dc.GetTable() where q.QuestionText. Contains(quesText) select new DateLastUsed() { DLUID = Guid.NewGuid(), QuestionID = q.

QuestionID, DateLastUsed1 = DateTime. Now }; Table dlused = Repository. GetDateLastUsedTable(); foreach(var dlu in matchedques) { dlused.

InsertOnSubmit(dlu); dlused.Context.SubmitChanges(); }.

Unless I'm missing something, why don't you just select q. QuestionID instead of making a new anonymous-type wrapper? Var matchedques = from q in dc.GetTable() where q.QuestionText.

Contains(quesText) select q. QuestionID; foreach (var element in matchedques) { MessageBox. Show(element.ToString()); } Alternatively, give the field a name ("theID" below) and access it directly: var matchedques = from q in dc.GetTable() where q.QuestionText.

Contains(quesText) select new{ theID = q. QuestionID }; foreach (var element in matchedques) { MessageBox. Show(element.theID.ToString()); } Apparently, there was more to the question than I first thought.In response to the comment, keep in mind that you're returning an enumeration of results in matchedques (hence the foreach above, right?

). So the following line is also in error: string qidGuidString = matchedques.ToString(); You either want string qidGuidString = matchedques.Single().ToString(); if matchedques should contain a single result, or a foreach loop if matchedques should contain multiple results. Note that there's no reason to convert a GUID to string and back again, and you can also use the query to return something more useful (namely, a new DateLastUsed object): var matchedques = from q in dc.GetTable() where q.QuestionText.

Contains(quesText) select new DateLastUsed() { DLUID = Guid.NewGuid(), QuestionID = q. QuestionID, DateLastUsed1 = DateTime. Now }; Table dlused = Repository.

GetDateLastUsedTable(); foreach(var dlu in matchedques) { dlused. InsertOnSubmit(dlu); dlused.Context.SubmitChanges(); }.

I tried that, changing the code to: dlu. QuestionID = matchedques; Recieved this: Error:Cannot implicitly convert type 'System.Linq. IQueryable' to 'System.

Guid' C:\Documents and – Goober May 5 '09 at 9:26 I edited the answer to address this. – lc. May 5 '09 at 9:33 I implemented the code sample you posted above, and now although the code fires without any errors as it was before, it isn't actually inserting any new details.

– Goober May 5 '09 at 10:52 Try inserting a breakpoint in the foreach loop. Expand the results of matchedques and see if you're getting the results you want. At this point I'm not sure whether the error is in the code above, the results of dc.GetTable(), or something happening in dlused.Context.SubmitChanges()... – lc.

May 5 '09 at 11:22.

Why don't just select q. QuestionID; instead of this `select new { q. QuestionID };' stuff?

1 Beat me to it by 35 secs. – lc. May 5 '09 at 9:21 I tried that, changing the code to: dlu.

QuestionID = matchedques; Recieved this: Error:Cannot implicitly convert type 'System.Linq. IQueryable' to 'System. Guid' C:\Documents and – Goober May 5 '09 at 9:26 sahgilbert - see my answer below – Winston Smith May 5 '09 at 9:28.

You are calling .ToString() on matchedques, which is an enumeration: var matchedques = from q in dc.GetTable() where q.QuestionText. Contains(quesText) select new{ q. QuestionID }; string qidGuidString = matchedques.ToString(); So in your example above, matchedques is an enunmeration of anonymous types (you should probably do away with that and select q.

QuestionID directly). Calling ToString() on this will return a string representation of the object, and not simply the QuestionId of the first element of the sequence. Are you expecting there to always be only one result for the above query?

If so, you should probably look at the Single operator. Something like this should do: var matchedQuesId = dc.GetTable() . Where(q =>q.QuestionText.

Contains(quesText)) .Single() . QuestionID; In this case, you can then use matchedQuesId directly. Note that if the Where query matches none, or more than one elements, this will throw an error.

Read up on the Single operator to find out why.

Change to: ... var matchedques = from q in dc.GetTable() where q.QuestionText. Contains(quesText) select q. QuestionID; e.g. Remove new {...}, so you are creating a new anonimouse type with the id property.

If you vote down, please specify the reason. What problem with this answer? – Kamarey May 5 '09 at 12:14.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.