Explore BrainMass
Share

Explore BrainMass

    Entity Frame Query

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I have 4 values from table c.

    I want to insert them into tables a,b,c,d.

    Using entity queries, these tables have relations such as a.i = b.i, c.e = d.e, b.f = c.f.

    How do I do that through entity queries?

    © BrainMass Inc. brainmass.com October 10, 2019, 5:31 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/entity-frame-query-508046

    Solution Preview

    Dear student,

    var myQuery = from a in myentiryorContext.Table_a
    join b in myentiryorContext.Table_b on a.i equals b.i
    join c in myentiryorContext.Table_c on b.f = c.f
    join d in myentiryorContext.Table_d on c.e =d.e
    select new {c.Column1, c.Column2,c.Column4,c.Column3}

    LINQ is a query language will allow you query the data souce ( SQL, or any data source that support ...

    Solution Summary

    This solution explains how to solve a problem related to programming languages in software development.

    $2.19