Execute a database script before or during test execution

[David]

Hello again,

I would like to be able to run a database script before a test executes or even during test execution would be great.
I was wondering if it was possible.

For example, In my website I need to log in as a certain user to access their roles and privileges, but this user might be logged into the system.  So, I would like to be able to run a database script that terminates their session and it would allow me to log in as that user before my test executes.

Thanks for any help provided.

[David]

I found a basic solution that I could use here for those who may have similar questions.

http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/code-samples/general/access-sql-database.aspx

[Byron]

Hi David,

This is the correct solution: in code, create a SqlCommand object containing the query to execute the database script and send the query to the database. Please let us know if we can help you further.

All the best,
Byron
the Telerik team