protected T FillToObject <T>() { try { if (typeof(T).FullName.StartsWith("System.")) { var tmpResult = CurrentCommand.ExecuteScalar(); if (tmpResult == null || Convert.IsDBNull(tmpResult)) { return(default(T)); } return((T)Convert.ChangeType(tmpResult, typeof(T))); } IDataReader dataReader = CurrentCommand.ExecuteReader(); var result = CBO.Instance.FillObject <T>(dataReader); if (!dataReader.IsClosed) { dataReader.Close(); } dataReader.Dispose(); return(result); } catch (Exception ex) { throw new ManagedException(ex.Message, false); } }
protected List <T> FillToListTest <T>() { DateTime start = DateTime.Now; IDataReader dataReader = CurrentCommand.ExecuteReader(); DateTime end1 = DateTime.Now; Debug.Print(String.Format("Elapsed: {0} miliseconds.", (end1 - start).TotalMilliseconds)); List <T> result = CBO.Instance.FillCollection <T>(dataReader); DateTime end2 = DateTime.Now; Debug.Print(String.Format("Elapsed: {0} miliseconds.", (end2 - start).TotalMilliseconds)); if (!dataReader.IsClosed) { dataReader.Close(); } dataReader.Dispose(); return(result); }
protected void FillToCsv(ref string tableName) { try { IDataReader dataReader = CurrentCommand.ExecuteReader(); CBO.Instance.FillToCsv(dataReader, String.IsNullOrEmpty(tableName), ref tableName); if (!dataReader.IsClosed) { dataReader.Close(); } dataReader.Dispose(); } catch (Exception ex) { throw new ManagedException(ex.Message, false); } }
protected List <T> FillToList <T>() { try { IDataReader dataReader = CurrentCommand.ExecuteReader(); List <T> result = CBO.Instance.FillCollection <T>(dataReader); if (!dataReader.IsClosed) { dataReader.Close(); } dataReader.Dispose(); return(result); } catch (Exception ex) { throw new ManagedException(ex.Message, false); } }