Does SilkPerformer support the loadtesting of a SQL Server database via ADO.NET?
Currently there is no support in SilkPerformer for recording a .NET script that contains ADO.NET calls because ADO.NET for SQL Server is natively implemented in the .NET programming language which the SilkPerformer Recorder does not support.
However if the application you wish to test only uses ADO.NET to connect to a different data source - the native ADO DLLs would be loaded and this would allow a user to perform a normal COM/ADO recording by loading the DLLs into the SilkPerformer Recorder’s Application Profile.
Therefore, if you wish to test ADO.NET for SQL Server using SilkPerformer then there are two methods available in which to do this:
- Using the SilkPerformer .NET Explorer to load the DLLs which contain the ADO.Net calls
- Implement a framework approach using the SilkPerformer .NET Framework.
The SilkPerformer .NET Framework approach should be favoured, especially if you have an application in which database components are separated in their own components (DLLs). This would enable a user to write a Framework project in which you can load the DLL and then make the required method calls for the database component.