I moving from sql to oracle, I want to ask that My company have oracle server8i, now I want to use Visual studio(I can setup any version) to code a website, does oracle support 'linq to oracle', and can you guide me , which version I should have to develop.
* server cannot upgrade database
* client can setup any version of visual studio, oracle client
The version of ODP.NET that supports Entity Framework doesn't support connecting to Oracle 8 server. So you won't be able to use that.
In fact I think to connect to Oracle 8 you're going to have to use a fairly old version of ODP.net so I'm not really sure what options it's going to have to use any kind of Linq. Linq to SQL might be your only option.