static void RunRetrivalTest2()
{
ResourceSummary Input = new ResourceSummary();
IEnumerable <object> Result = null;
ConsoleKeyInfo KeyInfo;
do
{
try
{
PerformanceDbContext_NonVirtual DbContext = new PerformanceDbContext_NonVirtual();
var x = DbContext.ResourceSummaryDetails.CallStoredProc(Input);
Result = x[0].ToArray();
foreach (ResourceSummaryNonVirtual 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);
}
public void CF_ResourseSummaryRetrivalTest()
{
ResourceSummary Input = new ResourceSummary()
{
PersonName = "SQL++.NET LIB PERFORMANCE TEST",
Country = "INDIA",
State = "GUJRAT",
City = "BARODA",
District = "UNSPECIFIED",
Street = "1 SHANTI NAGAR STREET",
HouseNo = "C8",
Pin = Hash,
MobileNo = "9051778445",
HomePhoneNo = "9051778445",
EmailAddress = "*****@*****.**",
MothersName = "VISUAL STUDIO",
FathersName = "PERFORMANCE TEST",
Employer = "COP",
EmployerCountry = "USA",
EmployerCity = "BALA CYNWYD",
EmployerState = "PENNSYLVANIA",
EmployerDistrict = "PHILADELPHIA",
EmployerPin = "19015",
EmployerStreet = "1800 GREEN STREET",
EmployerHouseNo = "F2",
CTC = 1000.56M,
NET = 10000.65M,
Gross = 10000.11M,
MobileNo2 = Hash
};
PerformanceDbContext_NonVirtual DbContext = new PerformanceDbContext_NonVirtual();
Stopwatch sw = new Stopwatch();
sw.Start();
var x = DbContext.ResourceSummaryDetails.CallStoredProc(Input);
object[] xxx = x[0].ToArray();
sw.Stop();
Console.Write(string.Format("Record Retrived : {0} in time : {1}", xxx != null ? xxx.Length : 0, sw.Elapsed.TotalMilliseconds));
}
