Do missing foreign keys in the database have an effect on sql generated by EF? : <p>I'm working on a database-first ASP.NET MVC application. Looking at the database the foreign keys are very inconsistent, basically they are only there if it was specified in the SQL scripts that created the tables. In most cases they are not there.</p>

<p>However, looking in the edmx model, I can see that it is aware of the foreign keys i.e. it has correctly identified the navigation properties.</p>

<p>My question is, does the missing foreign keys in the actual database have an effect on the sql genereted by Entity Framework? By effect I mean negative impact on performance.</p>

<p>I can't really figure out if it matters or not.</p>

<p>Just to clarify, in the database I'm expanding tables and looking for the red key which indicates a foreign key. I'm also looking in the subfolder: "Keys".</p>
