title: Entity framework and Oracle Public database links
body: <p>I've recently been looking into using EF in my .Net pages but I'm struggling a little when trying to access the public databases that are set up.</p>
  
  <p>So for example in my Oracle SQL developer I would access a public database like this</p>
  
  <pre><code>SELECT name FROM users@publicserver
  </code></pre>
  
  <p>I'm trying to use this in the following way</p>
  
  <pre><code>Using myEntities As New TestEntities()
      Dim allNames = From name In myEntities.users@publicserver
                       Select name
      GridView1.DataSource = allNames
      GridView1.DataBind()
  End Using
  </code></pre>
  
  <p>Obviously this doesn't work as my EF doesn't contain the public server table as I'm not sure how to even add this to the EF (if that makes sense?)</p>
  
  <p>I'm interested to know if it is possible to achieve this and if not does anyone have any ideas on the best method of accessing this?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Ideally I'd like to be able to use LINQ with my Public database links if this is possible?</p>