Return a List using LINQ

[Illegal Operation]

Hi! I need some help. This is very trivial but I seem to be struggling. How do I return a List from the below mentioned code?

private List GetOrderHeaders()
{
var TestVar = from OH in db.SF_GetLatestOrderEntry()
select OH;
}

Illegal Operation

[Arun Jacob]

Have you tried, return TestVar.toList()

Arun Jacob http://codepronet.blogspot.com/

[Illegal Operation]

Yes and I get this error Cannot implicitly convert type'System.Collections.Generic.List<WindowsFormsApplication1.SF_SelectLatestOrderEntryResult>' to 'System.Collections.Generic.List

Illegal Operation

[Arun Jacob]

Modify method as,

private List<WindowsFormsApplication1.SF_SelectLatestOrderEntryResult> GetOrderHeaders()
{
var TestVar = from OH in db.SF_GetLatestOrderEntry()
select OH;
return TestVar.toList();
}

or simply,

private List<WindowsFormsApplication1.SF_SelectLatestOrderEntryResult> GetOrderHeaders()
{
return db.SF_GetLatestOrderEntry().toList();
}

Arun Jacob http://codepronet.blogspot.com/

[Illegal Operation]

Thank you! That worked. Another quick question? I have a LINQ query returning results

        var OrderHeader = (from OrderHeaders in db.OEORDHs
                           where OrderHeaders.COMPLETE != 5 && OrderHeaders.COMPLETE != 4 && OrderHeaders.COMPLETE != 3
                           orderby OrderHeaders.ORDUNIQ descending
                           select OrderHeaders);

How can I assign the results to properties? I have created a property named pCustomer and modified the code but that does not work.

        var OrderHeader = (from OrderHeaders in db.OEORDHs
                           where OrderHeaders.COMPLETE != 5 && OrderHeaders.COMPLETE != 4 && OrderHeaders.COMPLETE != 3
                           orderby OrderHeaders.ORDUNIQ descending
                           select new

{
pCustomer = OrderHeaders.Customer
});

Illegal Operation

[dan sh]

Try this:

var TestVar = (from OH in db.SF_GetLatestOrderEntry()
select OH).ToList();

[Arun Jacob]

Instead of assigning object, assign properties,

var OrderHeader = (from OrderHeaders in db.OEORDHs
where OrderHeaders.COMPLETE != 5 && OrderHeaders.COMPLETE != 4 && OrderHeaders.COMPLETE != 3
orderby OrderHeaders.ORDUNIQ descending
select new pCustomer()
{
propertyname1 = OrderHeaders.Customer.propertyname1,
propertyname2 = OrderHeaders.Customer.propertyname2
});

Arun Jacob http://codepronet.blogspot.com/