I'm looking into a solution where i have to write TestStand Tests' results to a database through a predefined API that can be accessed in the tests' sequence. Currently the way the test results are written to a database is through ODBC and by explicitly writing SQL statements into TestStand. I want, instead to write an application say in .Net and encapsulate those SQL statements calls within it.
Is this doable at all ? Can I write the application, build the DLL, load it into TestStand and through a .Net Adpater make it available to the Tests' sequence.
To make even the process worse, the actuall .Net application will consume webservice that will do the actual writing to the database.
This is my first experience with TestStand and i'm not sure I'm on the right track. Most of the docs i sifted through don't seem to hint to externalizing database interaction through a third party object (.Net, Active X or any DLL).
Would appreciate your comments on this
Thank you ken.
As long as your .NET application/library is fully functional (can write to the database and all that), you can absolutely call your .NET assembly using the .NET module adapter from TestStand. Shouldn't be a problem.
One thing I would recommend: Where you put the .NET step will depend on whether you want the database interaction to happen for just a particular device that's being tested (i.e., from one sequence), or you want the database interaction to occur for multiple types of devices that are being tested (i.e., multiple sequences / sequence files).
If it is the first case, you'd want the .NET database steps in your client sequence file. If it is the latter (want the database interaction for any sequence that runs), you'll probably want to put your database interaction code in the process model rather than in each individual client sequence file.