Entity Framework code first with complex oracle stored procedure
<p>I am working on upgrading an ASP.Net Web Forms application to MVC + EF Web Application.</p>

<p>I am more or less clear about the MVC part but seems to be a bit stuck about the EF part.</p>

<p>Since its a upgrade so there already exists a DB with lot of stored procedures, functions and other things and I would like to keep them.</p>

<p>For EF Code First from DB is the prefered option as it generates the Model classes automatically.</p>

<p>I am struggling to conceptualize how this will actually work.</p>

<p>for example:</p>

<p>I have two tables Employee &amp; Salary as</p>

<p><a href="https://i.stack.imgur.com/ZKxZe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZKxZe.png" alt="enter image description here"></a> <a href="https://i.stack.imgur.com/BvskK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BvskK.png" alt="enter image description here"></a></p>

<p>There is a stored procedure getEmployeeDetails which returns a cursor with properties from both tables.</p>

<p>I am not sure how to map this in DbContext as what I have read so far is that you can map stored procedure to a single mode and not two or more.</p>

<p>Can someone please suggest what can do done here and what will be the best option in terms or using EF code first with existing procedures.</p>

<p>Thanks!!!</p>