Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Break one table into many or leave alone?
Message
 
À
05/11/2009 16:53:26
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01433360
Message ID:
01433477
Vues:
41
>But that;s the point.In .net you pull the data and you populate the control - seperate steps.

The same is in VFP (when you work with SQL Server, or any other DBs, BTW working with with NATIVE is the same, just hidden and easier:-))


> Get all the data in one trip, then populate the controls. ADO works differently from Fox. There is a lot of power in the disconnected nature of ADO data. You can return multiple cursors with a single sproc - one trip to the server - and then fill multiple datatables from that sproc from which you fill your controls., It is more efficient than 25 trips.

I didn't see ANY difference here than VFP. SP is programed on server and it returns resultset based on parameters you passed, no matter what your FrontEnd is.

>One of the big myths that has lived in our community for too long is that Fox "handles data" better than .NET. Just isn't true. I handles it differently and there are strengths and weaknesses on both sides, but once you really get your head into the .NET way of doing things you'll find the advantages can be very great.

Agreed. But ALL controls in VFP is DB designed. So you have to changed two or 3 properties (VISUALLY) and all done!

Don't get me wrong here, I am not against .NET (And I'm always against the discussions which is better). Just some things are easier to do in VFP that in .NET (at least for me)).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform