What version of visual studio for vb.net?

[ChrisK]

I am migrating existing VB6 applications to VB.Net. What version of visual
studio do I need to download for programming with a database that is SQL
2005? Will VS8 work or do I need VS5? Do I need to download anything
separate for database connections?

Thank you!

 

[sloan]

VS2005 of VS2008 will work.

But at this stage of the game, you might as well go with VS2008.


"Migrate" or "Convert"?

Conversion will take some time.

While ~~possible~~, you do NOT want to use ADODB objects. Learn how to use
the ADO.NET objects.

DataSet
IDataReader

 

[Cor Ligthert[MVP]]

Chris,

Hi Chris, VB6 was a little bit strange product as it was in Visual Studio
1998 but as well sold as VB 6.

The newer products have a version name and a language name.
Therefore there is no VS5 and not VS8.

Those products are Visual Studio 2005 (which holds VB8) and Visual Studio
2008 which holds (VB9).

As freeware it is also possible to use products like VB 2008 Express.

For the SQL server it is not important which version you use, however the
2008 version can be used with Linq to SQL, which has a way of working like
the with the Recordset. The problem with the recordset is, that it does not
fit easy to the true Net data Controls.

I won't say not to use ADO (but like sloan I strongly advice not to use it),
however try to avoid the MS Flexgrid and the
Microsoft.visualbasic.collection.

Cor

 

[ChrisK]

One additional question on this post... what is the recommendation on using
LINQ from VB.Net to the SQL Server table? Is that considered to be a good
way to retrieve specific records and updating them back to the table?