public void ScopeTestRetrival()
{
ResourceSummary Input = new ResourceSummary()
{
PersonName = "SQL++.NET LIB PERFORMANCE TEST",
};
IEnumerable <ResourceSummary> Result = null;
using (ConnectionScope scope = new ConnectionScope())
{
SpResourceSummaryDetails Sp = new SpResourceSummaryDetails();
Stopwatch sw = new Stopwatch();
sw.Start();
Sp.Execute(Input, scope);
Result =
Sp.GetResult <ResourceSummary>();
sw.Stop();
Console.Write(string.Format("Record Retrived : {0} in time : {1}", Result != null?Result.Count():0, sw.Elapsed.TotalMilliseconds));
}
//Assert.IsTrue(Result.Count > 0);
}
static void RunRetrivalTest1()
{
ResourceSummary Input = new ResourceSummary();
IEnumerable <ResourceSummary> Result = null;
ConsoleKeyInfo KeyInfo;
do
{
try
{
using (ConnectionScope scope = new ConnectionScope())
{
SpResourceSummaryDetails Sp = new SpResourceSummaryDetails();
Sp.Execute(Input, scope);
Result = Sp.GetResult <ResourceSummary>();
}
foreach (ResourceSummary each in Result)
{
Console.WriteLine(string.Format("{0}\t{1}\t{2}\t{3}", each.PersonId, each.PersonName, each.EmailAddress, each.CTC));
}
}
catch (Exception ex)
{
Console.WriteLine("Exception : {0}", ex.Message);
}
Console.WriteLine("Would you like to perform it again ? (Y/N)");
KeyInfo = Console.ReadKey();
}while (KeyInfo.Key == ConsoleKey.Y);
}
