public override JustGronkIT() { using (_db = new MDBDataContext("myconnectstring")) { //do stuff with SQL //Note that I am using a using block and connections to SQL are properly disposed of when the using block ends } }
/// <summary> /// Constructor /// </summary> public BaseDAL() { mdbDataContext = new MDBDataContext(DatabaseConnection.DatabaseConnectionString); //To avoid Error : Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. mdbDataContext.CommandTimeout = !String.IsNullOrEmpty(DatabaseConnection.DataContextCommandTimeout.ToString()) ? Convert.ToInt32(DatabaseConnection.DataContextCommandTimeout) : mdbDataContext.CommandTimeout; }
/// <summary> /// Run recalculation process /// </summary> /// <param name="mdbConnectionString"></param> /// <param name="logFilePath"></param> private void Run(string mdbConnectionString, string logFilePath) { Recalculation recalculation = new Recalculation(); //recalculation.RecalculateMilestones(); MDBDataContext arbsDataContext = new MDBDataContext(mdbConnectionString); List <Library.DataAccess.LINQ.Recalculation> recalculations = arbsDataContext.Recalculations.Where(r => !r.IsDeleted && r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.PENDING) || r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.IN_PROGRESS)).ToList(); if (recalculations.Count > 0) { bool isRecalculationInProgress = recalculations.Any(r => r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.IN_PROGRESS)); // IF recalculation not in running if (!isRecalculationInProgress) { RecalculationVO recalculationVO = new RecalculationVO(recalculations.FirstOrDefault(r => r.Status == Convert.ToInt32(Library.Common.Constants.RecalculationStatus.PENDING))); //if (recalculationVO != null) //{ // List<int> indexIds = new List<int>(); // if (recalculationVO.IndexIds.Contains(";")) // { // string[] ids = recalculationVO.IndexIds.Split(';'); // indexIds.AddRange(ids.Select(id => Convert.ToInt32(id))); // } // else // { // indexIds.Add(Convert.ToInt32(recalculationVO.IndexIds)); // } //} recalculation.RecalculateMilestone(recalculationVO, 1); } } }