Can We Insert New Reocrd By Using Ants Load

[jagadeesh_qc]

Hi All,

Can We Insert a New Reocrd By Using Ants Load script in Database. If yes What are the steps?


Thank You,
Jagadeesh

[Brian Donahue]

Hello,

ANTS Load can only make web requests. If you have a web application that does the database updates, you can use ANTS Load as a harness to get it to perform many updates automatically in a short period of time. The software is mainly designed to stress-test websites rather than test their functionality is working properly, however.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[tommyjjohnson]

I've used ANTS Load to interact with a database directly, without using my Web site. All you have to do is write VB.Net code to do it. I used this example to test database performance:

Dim con As System.Data.SqlClient.SqlConnection
Dim com As System.Data.SqlClient.SqlCommand
Dim ElapsedTime As TimeSpan

Try
con = New System.Data.SqlClient.SqlConnection("Server=dbtest1;database=nevada;uid=xxxx;pwd=xxxx")
con.Open()
com = New System.Data.SqlClient.SqlCommand(QueryName, con)
com.CommandType = Data.CommandType.StoredProcedure
com.CommandTimeout = 2400
com.ExecuteNonQuery()
Catch ex As Exception
If Me.Id < 2 Then
AntsHelper.Tracker.SendToExternalHtml("c:\loadtest\hyperthreading.htm", ex.ToString(), "&nbsp;")
End If
Result = "ERROR"
Finally
If con.State <> Data.ConnectionState.Closed Then
con.Close()
End If

com.Dispose()
con.Dispose()

ElapsedTime = DateTime.Now.Subtract(now)
AntsHelper.Tracker.SendToExternalLog("c:\loadtest\hyperthreading.txt", QueryName & vbTab & Result & vbTab & ElapsedTime.ToString())
End Try

Alternately, one could write an assembly, reference it, and use that. I haven't found anything that I can't do with ANTS load so far...some things are really difficult and some things are really slow, but I've been able to do them.