title: Using views to link two databases
body: <p>A quick rundown. I'm creating a Entity Framework and VB project. The new project will not write any data to the secondary database, it will have its own database where all the new information is stored. However the new project will gather information from the secondary database. </p>
  
  <p>So I have created Views within the projects database that retrieve information from the secondary database. Using the following SQL Statements.</p>
  
  <pre><code>SELECT SecondaryDB.Schema.Table.Column From SecondaryDB.Schema.Table
  </code></pre>
  
  <p>Essentially, I'm hoping to accomplish a number of objectives. </p>
  
  <ul>
  <li>I don't want any changes to the secondary database to occur.</li>
  <li>I would like to have this all under one Model in Entity Framework.</li>
  <li>Controlling access to the information handled by the project and its database.</li>
  </ul>
  
  <p>My question is, is this a reasonable solution, given my requirements? I'm fairly new to EF (by the way I'm using 6.0) </p>
  
  <p>Are there any other solutions that would accomplish my objectives, that would be better suited?</p>