Simulating Cross Context Joins–LINQ/C#

by

Maybe something like this can get you started in the right direction. I made a mock database with similar columns based on your column names and got some results.

    class Program
{
    static AccountContextDataContext aContext = new AccountContextDataContext(@"Data Source=;Initial Catalog=;Integrated Security=True");
    static LoanContextDataContext lContext = new LoanContextDataContext(@"Data Source=;Initial Catalog=;Integrated Security=True");

    static void Main()
    {

        var query = from a in aContext.ACCOUNTs
                    join app in aContext.APPLICATIONs on a.GUID_ACCOUNT_ID equals app.GUID_ACCOUNT
                    where app.GUID_APPLICATION.ToString() == "24551D72-D4C2-428B-84BA-5837A25D8CF6"
                    select GetLoans(app.GUID_APPLICATION);

        IEnumerable<LOAN> loan = query.First();
        foreach (LOAN enumerable in loan)
        {
            Console.WriteLine(enumerable.GUID_LOAN);
        }

        Console.ReadLine();
    }

    private static IEnumerable<LOAN> GetLoans(Guid applicationGuid)
    {
        return (from l in lContext.LOANs where l.GUID_APPLICATION == applicationGuid select l).AsQueryable();
    }
}

Hope this helps!

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. Bulk-deleting in LINQ to Entities
  5. Entity framework left join
  6. Why doesn’t Include have any effect?
  7. Entity Framework/Linq EXpression converting from string to int
  8. Value cannot be null. Parameter name: source
  9. Recursive Hierarchy – Recursive Query using Linq
  10. Filter/Search using Multiple Fields – ASP.NET MVC
  11. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  12. The result of a query cannot be enumerated more than once
  13. Entity Framework. Delete all rows in table
  14. How to convert an expression tree to a partial SQL query?
  15. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  16. Generate EF orderby expression by string [duplicate]
  17. Entity-framework code is slow when using Include() many times
  18. LINQ, Unable to create a constant value of type XXX. Only primitive types or enumeration types are supported in this context
  19. The operation cannot be completed because the DbContext has been disposed using MVC 4
  20. How does LINQ expression syntax work with Include() for eager loading
  21. Linq to Entity Join table with multiple OR conditions
  22. Export Model to DataTable
  23. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  24. Only primitive types or enumeration types are supported in this context
  25. Max return value if empty query
  26. Check if list contains item from other list in EntityFramework
  27. How to do an “in” query in entity framework?
  28. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  29. Should the order of LINQ query clauses affect Entity Framework performance?
  30. How to wrap Entity Framework to intercept the LINQ expression just before execution?

Leave a Comment