Assign linq results to public list

Question

Hi guys Ok can someone point out where I am going wrong here? I want to assign the results to a list and then assign that list to the itemsource of a grid.... public class AllLists { public static List string > LstQteHeader = new List string >(); } using ( var context = new AscentEntities ()) { AllLists .LstQteHeader = ( from d in context.Qte_Header select d); } } }

Dean · Answer

Perfect thanks

Vulpes · Answer

When you apply the ToList() extension method to the LINQ query you'll get a List object. As you're assigning it to AllLists.LstQteHeader which is now of that type no conversions are necessary and it works fine :)

Dean · Answer

Yes that's perfect. Stupid question but can you explain to me why that worked?

Vulpes · Answer

I've no idea what that means but perhaps the best thing to do would be to change the type of LstQteHeader to match: public class AllLists { public static List LstQteHeader = new List (); } Hanook's code should then work.

Dean · Answer

Yes I did try using .tostring() Didn't have any errors until I run it I then got: 'The invocation of the constructor on type 'Ascent_ERP.MainWindow' that matches the specified binding constraints threw an exception.' Line number '16' and line position '343'. No clue what that means? Thanks.

Vulpes · Answer

I take it from the error message that 'd' is of type Ascent_ERP.Qte_Header. You therefore need some way of providing a string representation of this object - either ToString() if the class overrides it or by direct manipulation.

Dean · Answer

This returned: Error 1 Cannot implicitly convert type 'System.Collections.Generic.List ' to 'System.Collections.Generic.List

Hanook · Answer

Refer this link http://stackoverflow.com/questions/7488980/syntax-for-linq-query-to-liststring http://stackoverflow.com/questions/2502586/linqtosql-query-to-return-liststring

Vulpes · Answer

Try: AllLists .LstQteHeader = ( from d in context.Qte_Header select d.ToString()).ToList(); though no need to apply ToString() to d if it's already a string.

Hanook · Answer

May be this? using ( var context = new AscentEntities ()) { AllLists .LstQteHeader = ( from d in context.Qte_Header select d) .ToList() ; }