Databases
StackOverflow2013
Postsdbo
POasp.net using mvc 3 linq and join
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POasp.net using mvc 3 linq and join
    text
    copied!<p>i have a problem with my join in my asp.net .. i have two database tables.. named APPLICANT and Profile...they have the same fields.. meaning if the Last name in applicant is null the last name is already in profile table. I already connect my program to the applicant table.. but it have so many null fields that have to fetch from the profile data table.... sorry i'm new in asp.net ... </p> <p>Here's my code in controller:</p> <pre><code> public View Result Index() { var applicants = (from a in db.APPLICANTs select a).ToList(); return View(applicants); } </code></pre> <p>heres my context:</p> <pre><code>public partial class APPLICANT { public int APPLICANT_ID { get; set; } public Nullable&lt;int&gt; Profile_id { get; set; } public string APPLICANT_LastName { get; set; } public string APPLICANT_FirstName { get; set; } public string APPLICANT_MiddleName { get; set; } public string APPLICANT_Address { get; set; } public string APPLICANT_City { get; set; } public string APPLICANT_ZipCode { get; set; } public string APPLICANT_Phone { get; set; } public string APPLICANT_Email { get; set; } } public partial class Profile { public int PROFILE_ID { get; set; } public string Applicant_LASTNAME { get; set; } public string Applicant_FIRSTNAME { get; set; } public string Applicant_MIDDLENAME { get; set; } public string Applicant_EMAIL { get; set; } public string Applicant_PHONE { get; set; } public string Applicant_ADDRESS { get; set; } public string Applicant_ZIPCODE { get; set; } public string Applicant_CITY { get; set; } } </code></pre> <p>thanks for those who can help my problem..</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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