public void ReadCandidatesListFromSQLAzure()
{
Stopwatch stopWatch = new Stopwatch();
var sut = new SQLAzureDemo.SQLAzureProvider();
var maxId = sut.GetLastCandidateId() + 1;
stopWatch.Start();
var result = sut.GetCandidatesList(1000);
stopWatch.Stop();
Trace.WriteLine("Read 1000 candidates from SQL Azure took:" + stopWatch.Elapsed);
Trace.Flush();
}
public void Add10000CandidatesToSQLAzure()
{
Stopwatch stopWatch = new Stopwatch();
var sut = new SQLAzureDemo.SQLAzureProvider();
var maxId = sut.GetLastCandidateId() + 1;
stopWatch.Start();
for (int i = 0; i < 10000; i++)
{
var candidate = new SQLAzureDemo.Candidate()
{
FirstName = "Aram",
LastName = "Koukia",
CandidateId = maxId + i,
CandidateStatusId = 1
};
sut.AddCandidate(candidate);
}
stopWatch.Stop();
Trace.WriteLine("Add 10000 rows to SQL Azure took:" + stopWatch.Elapsed);
Trace.Flush();
}
