Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
No simple way to do data in .NET!
Message
From
29/03/2010 16:56:24
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 3.0
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01457894
Message ID:
01457951
Views:
74
>What your ParameterAddSQL method does?

The framework has been built in a way to respond to various types of backends. So, no matter how I make it evolve, we shouldn't have to change anything in the client's application. So, by using this approach, this let the backend adjust the proper syntax at that level. As the parameterization is different between SQL Server and VFP, for example, the framework will then be able to adjust the SQL command before it will be executed against the backend. The same goes on with the ParameterAdd() method which will put in to a collection all parameters. Then, the proper SQL syntax is done. And, then, for debugging purposes, this opens the door to multiple valuable information based on the current data dictionary in place. For example, I can enable oProcess.lLogData to True. This will log into the Hit for the specific user, once the hit on the site has been completed, all the SQL commands that were executed, the elapse time it took and the number of records returned. Then, I can just cut & paste as is into SQL Server to execute it for testing purposes, such as you might have seen in several messages I have posted in this forum where you could see the parameterized approach I am using.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Reply
Map
View

Click here to load this message in the networking platform