Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <blockquote> <p>how best to integrate a method which contains a query that queries multiple entities into the repository. </p> </blockquote> <p>Considering the relationship between <code>User</code> and <code>Journey</code>, you should decide which entity owns the relationship and use <code>Aggregate Root</code> to fetch data. </p> <p>The description of <code>Aggregate Root</code> at <a href="https://stackoverflow.com/questions/1958621/whats-an-aggregate-root">What&#39;s an Aggregate Root?</a> would be helpful.</p> <p><strong>Update:</strong></p> <p>Entities</p> <pre><code>public class User { public User() { this.Journeys = new List&lt;Journey&gt;(); } public int Id { get; set; } public virtual IList&lt;Journey&gt; Journeys { get; set; } } public class Journey { public Journey() { this.Users = new List&lt;User&gt;(); } public int Id { get; set; } public virtual IList&lt;User&gt; Users { get; set; } } </code></pre> <p>Repositiories</p> <pre><code>public class UserRepository { public IList&lt;User&gt; GetAllUsersWithJourneys() { //Fetch all Users; Include Journeys } } public class JourneyRepository { public IList&lt;Journey&gt; GetAllJourneysWithUsers() { //Fetch all journeys; Include Users } } </code></pre> <p>ViewModel</p> <pre><code>public class UserJourneyViewModel { public int UserId { get; set; } public int JourneyId { get; set; } } </code></pre> <p>Controller's Action</p> <pre><code>public ViewResult Search() { // Use UserRepository or JourneyRepository to make a list of // UserJourneyViewModel that provides appropriate data for the view. } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to integrate a Linq to Entity query that queries multiple entities in a repository and send data to View?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USAbbas Amiri
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI have included my User entity above. User would be the Root. I tried changing the relationship to an one to one relationship just to see if I could obtain the Journey data from the query in the controller and I was successful. With the relationship being many to many is there something wrong with my User entity and how can I obtain the data from the query relating to the Journey details.
      singulars
      1. PO
      1. USColin Roe
    2. COI think the `Search` method is not actually a search, it fetches all users with their journeys. Am I right?
      singulars
      1. PO
      1. USAbbas Amiri
    3. COYes it is just the name of the Action
      singulars
      1. PO
      1. USColin Roe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload