Somasegar's WebLog

Somasegar's WebLog : Visual Studio and S...

Good that there is a patch available for VS 2005 to connect to SQL 2008. Also are there express editions of VS 2008 as was the case with VS 2005?

If you really want to make database developers more productive move VFP into the .NET family and give us a true data centric language. Current data capabilities in .NET and SQL Server are not even on par with FoxBase let alone Visual FoxPro.

The real issue is MSFT is too busy trying to attract developers using non-microsoft tools such as ruby into .NET instead of worrying about their current customer base.

This just get me so mad Microsoft owns the VFP source code so there is no research required just port the current language over and you guys won't. The form designer, report writer and sql server are fine IN VS and Sql Server... All we NEED is the data access functions. Hell I would be happy with an equilivent of the following commands

open database (pass in a connection string)

use (opens a table in the current open database)

SELECT (database and table name) .I.E SELECT (mydatabase.mytablename)

scatter memvar to object name

gather memvar form object name

seek function

set order to

scan for

endscan

replace statement

SELECT INTO CURSOR

appen blank

begin transaction

commit transaction

Take a look at the following example to add a record

OPEN DATABASE MyDatabase

USE mytable

begin tranasction

scatter memv blank

m.myfieldname = "mystring"

insert into mydatabase.mytable from memvar

commit transaction

Now figure out how many lines of .BLOAT code is necessary to pull off the same trick ... This really is a no brainer when it comes to how to make developers more productive.

Even if you guys did implement these functions I'm sure you would F it up somehow by over complicating the entire process for some obsure academic case....

Developers who have no idea what these command are have no idea of the flexiability this would give us and the productivity increase we would experience of not having to screw around with database reader and adaters.

In additional

- Fix function performance issues in SQL Server

- Add a debugger to SQL Server

- Fix the group by clause so we can include a unique identifier for each record in the data set return by in the select statement.

I wish there was an alternative to VFP so MSFT would commit some resources to developing a REAL database language. Instead of the crap we are dealt with from Microsoft in terms of data access... The best solution would be an alternative to Microsoft so I would not have to deal with Microsoft all !!!!!!!

Best Regards,

Mark Gordon

Mark - We are committed to productivity for database developers.  I would like to talk about your concerns futher.  Please contact me at megp@microsoft.com.

Question on this:

For Visual Studio 2008 to support SQL Server 2008, we will be delivering a patch to coincide with the next CTP of SQL Server 2008

When is next CTP of SQL Server 2008 coming out? Waiting eagerly to use LINQ/dbml from within VS.NET 2008.

Thanks for the info, but how about leaving a highlighted note on this here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en

and somewhere else related to VS2008 where developers are expected to pass by.

That would have saved me several hours of browsing and searching. Given the hype about the two products, it's very hard to believe the patch isn't ready yet.

/gustav

When will the patch for VS 2008 become available?

For anyone watching this space for an update here's a link to the patch for VS 2008

http://www.microsoft.com/downloads/details.aspx?familyid=A999C84F-0FE5-4926-A1BF-4730D1CAA98C&displaylang=en

I haven't tried it yet, has anyone else? Got any comments on it?

I am testing it - seems to work, at least worked once. I worked, i managed to create a connection and some DBML file but then it lost connection and I can't connect again.

Download Visual Studio 2008 SP1 Beta here. Added full support for SQL Server 2008 and many other cool features.

http://www.microsoft.com/downloads/details.aspx?FamilyId=CF99C752-1391-4BC3-BABC-86BC0B9E8E5A&displaylang=en

ok, I'm lost on the Microsoft site at this point.  I'm attempting to buy a single package of Visual Studio 2008 and SQL Server to run on MS Server 2003/2008.  

When I look at the MS website there is an option for VS Professional with MSDN Professional which includes a "subscription" to SQL Server.  Is the SQL server only supported by VS in that package?

Mark,

you are so d*mn right! There is not even one single programming language on the market that can compete with MS Visual Foxpro. I've been working with VFP for 10 years now. But I also worked a lot with PHP, ASP.NET, C#, VB and J2EE for more than 7 years. VFP is best when it goes for data - even with SQL server in the backend VFP is uncomparable. It's a pitty that MSFT dropped VFP. It' fast, ultra-stable. RAD-capable, easy to deploy ans do on. Linq is a nice try to bring VFP ideas into the .Net world, but....

Did you know that a small spanish company managed what the Microsoft guys couldn't? Look here: http://www.etecnologia.net/

You are right Mark. When it comes to data manipulation vfp is great. I think MS will loose a lot of programmers by leaving vfp. I'm sure if etecnologia will succeed in their project most of vfp developers will buy etecnologia product. And because vfp.net anounced by Etecnologia will be their primary product, they will invest in it and make it far better than everything MS has at the moment when comes to data access.

I don't know why the "smart guys" from MS can't learn from the VFP flexibility and at least make another language easy to work with like vfp was if not move vfp in .net and promote it as the best tool for data access. It is much simple to work with sql server backend and vfp as frontend than with these days .net products.

For me is important to make an application fast and flexible and things what I could do with vfp easy and with couple of instructions I need 10 times more time consuming to do in C#