Visual Studio newbie questions

[marchelloUA]

Hi all,
my need is to find appropriate forum thread for my questions:
- where can I download service pack 2 for Visual Studio 2010 ?
- how do I connect to MS SQL 2005 from Visual Studio ?
- how do I connect to Oracle 11g from Visual Studio ?
- how do I change from FrameWork Client to FrameWork Full in Visual Studio ?

 

[jmcilhinney]

- where can I download service pack 2 for Visual Studio 2010 ?

VS updates should be done through Microsoft Update but you can also download directly from MSDN.

- how do I connect to MS SQL 2005 from Visual Studio ?

Using the SqlConnection class. There are lots of ADO.NET tutorials and examples around and a large proportion are for SQL Server.

- how do I connect to Oracle 11g from Visual Studio ?

The code is basically the same as for SQL Server except you use types from a different namespace. You can download ODP.NET (Oracle Developer Tools for .NET) from the Oracle web site and it provides equivalent tools and types as are already built in for SQL Server.

- how do I change from FrameWork Client to FrameWork Full in Visual Studio ?

Open the Compile page of the project properties and then the Advanced Compile Options dialogue.

 

[marchelloUA]

Open the Compile page of the project properties and then the Advanced Compile Options dialogue.

This is valid for C#. How about Visual Basic ?

 

[JohnH]

This is valid for C#. How about Visual Basic ?

It is valid for VB Express also. 'ACO' button is at the very bottom of that page, maybe you have to scroll down page to see it.