How do I pass the query or results of a Linq to SQL query to the next method

Question

Hi there, I have a Linq to SQl query in C#

var queryGetAllPricingData = from i in dB.Invoices
                         join c in dB.Contracts
                         on i.ContractId 
                         equals 
                         c.ContractId
                         where i.InvoiceStatusId == 100
                         select new { i, c]};

Then I do a test for any results:

if (queryGetAllPricingData.Count() > 0)

Then I want to use the results in a new method.

What do I pass to the new method? This does not appear to work

if (queryGetAllPricingData.Count() > 0)
{
     GetPricingModel(queryGetAllPricingData);
}

internal void GetPricingModel(IQueryable queryGetAllPricingData)
{
foreach (var record in queryGetAllPricingData)
  {
     DO SOMETHING;
  }
}

What should I be doing?

Answer 1

Please see this question for answers: http://stackoverflow.com/questions/55101/using-linq-how-can-i-pass-a-var-back-from-a-method

Answer 2

You cannot pass anonymous types into a new method, what you need to do is create a class to hold the information

Answer 3

Well, your problem is this:

var queryGetAllPricingData = from i in dB.Invoices
                           .....
                         select new { i, c]};

You're getting back an IQueryable of an anonymous type, and you can't pass those around.

You'll need to create a container type for this, something like:

public class InvoiceContract
{
   Invoice inv { get; set; }
   Contract contr { get; set; } 
}

and then change your LINQ query to:

var queryGetAllPricingData = from i in dB.Invoices
                           .....
                         select new InvoiceContract { inv => i, contr => c };

and then use IQueryable<InvoiceContainer> as your type on the second method you want to call:

internal void GetPricingModel(IQueryable<InvoiceContract> queryGetAllPricingData)

That should work (I hope! No way of testing this right now, all off the top of my head)

Marc