Databases
StackOverflow2013
Postsdbo
POUnable to create properties based on foreign-key relationship in Linq-to-SQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to create properties based on foreign-key relationship in Linq-to-SQL
    primarykey
    data
    text
    <p>Table name: <code>Author</code></p> <ul> <li>AuthorID -> primary key</li> <li>FirstName</li> <li>LastName</li> </ul> <p>Table name: <code>Titles</code></p> <ul> <li>ISBN -> primary key</li> <li>BookTitle</li> <li>EditionNumber</li> <li>CopyRight</li> </ul> <p>Table name: <code>AuthorISBN</code></p> <ul> <li>ISBN -> foreign key</li> <li>AuthorID -> foreign key</li> </ul> <p>I can do: </p> <pre><code>var AuthorsAndISBNs = from author in database.Author join books in database.AuthorISBN on author.AuthorID equals books.AuthorID orderby author.LastName, author.FirstName select new { author.FirstName, author.LastName, books.ISBN }; </code></pre> <p>However, I cannot do: </p> <pre><code>var authorsAndTitles = from title in database.Titles from book in title.AuthorISBN let author = book.Author orderby author.LastName, author.FirstName, title.BookTitle select new { author.FirstName, author.LastName, title.BookTitle }; </code></pre> <p>I thought LINQ automatically creates properties based on foreign-key relationships, which enables you to easitly access related rows in other tables:(</p> <blockquote> <p>Author has one-to-many relationship with AuthorISBN which has 'many-to-one' relationship with Titles</p> </blockquote> <p>Please help! been stuck on this for days:'( THANK YOU!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmarc_s
    1. USuser1683987
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUnable to create properties based on foreign-key relationship in Linq-to-SQL
      1. This table or related slice is empty.
      1. VTClose
    1. COCan you post your domain objects (Title, Author, and AuthorISBN)? Are you writing these classes by hand or using a tool to generate them?
      singulars
      1. POUnable to create properties based on foreign-key relationship in Linq-to-SQL
      1. USChaseMedallion
    2. CODuplicate of [Linq to Sql Foreign key relationships](http://stackoverflow.com/questions/12501285/linq-to-sql-foreign-key-relationships) - you've **just asked** this same question only 5 hours ago - please **do not** post the same question over and over again!
      singulars
      1. POUnable to create properties based on foreign-key relationship in Linq-to-SQL
      1. USmarc_s
    3. CO@Chasemedallion no I am not writing the classes by hand. I have already developed the tables in mySQL added the connection to my program in c#, and used object relational mapping (omr) to drag-and-drop them into a dbml file called Books.dbml. This method created a BookDataContext Object automatically to connect to my database.
      singulars
      1. POUnable to create properties based on foreign-key relationship in Linq-to-SQL
      1. USuser1683987
 

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