Exemple #1
0
        static TimeSpan InvokeStoredProcedure()
        {
            Stopwatch stopwatch = new Stopwatch();
            TimeSpan  timeUsedToGetFromStoredProcedure;
            VehicleServiceDataAccess         vehicleData = new VehicleServiceDataAccess();
            List <uspVehicleServiceComplete> resultFromStoredProcedure;

            ///Measure time used to get data from the Stored Procedure
            stopwatch.Start();
            resultFromStoredProcedure = vehicleData.GetDataFromStoredProcedure();
            stopwatch.Stop();
            timeUsedToGetFromStoredProcedure = stopwatch.Elapsed;
            stopwatch.Reset();
            return(timeUsedToGetFromStoredProcedure);
        }
Exemple #2
0
        static TimeSpan InvokeView()
        {
            Stopwatch stopwatch = new Stopwatch();
            TimeSpan  timeUsedToGetFromView;
            VehicleServiceDataAccess      vehicleData = new VehicleServiceDataAccess();
            List <VehicleServiceComplete> resultFromView;

            ///Measure time used to get data from the View
            stopwatch.Start();
            resultFromView = vehicleData.GetDataFromView();
            stopwatch.Stop();
            timeUsedToGetFromView = stopwatch.Elapsed;
            stopwatch.Reset();
            return(timeUsedToGetFromView);
        }