public List <T> GetTable <T>(ConnectionNameEnum connectionNameEnum, string tableName, string whereCondition) { List <T> list; var com = GeneralMethods.MakeQuerySqlCommand(connectionNameEnum, "Select * from " + tableName + " " + whereCondition, ConnectionTimeout); try { using (var result = com.ExecuteReader()) { if (typeof(T).IsValueType || "".GetType() == typeof(T)) { list = new List <T>(); Parallel.ForEach(SimpleParallelDataReader <T>(result), (data) => { list.Add(data); }); return(list); } list = new GeneralMethods().ToViewModel <T>(result); } } catch (DataException) { Parameters.Clear(); throw; } finally { ConnectionManager.ReleaseConnection(com.Connection); } return(list); }
public DataSet RunQuery(string connectionString, string query) { SqlCommand com = null; try { com = GeneralMethods.MakeQuerySqlCommand(connectionString, query, ConnectionTimeout, Parameters); var set = new DataSet(); new SqlDataAdapter(com).Fill(set); return(set); } catch (Exception) { { } throw; } finally { if (com != null) { ConnectionManager.ReleaseConnection(com.Connection); } } }
public DataTable GetTable(string connectionString, string tableName, string whereCondition) { SqlCommand com = null; try { com = GeneralMethods.MakeQuerySqlCommand(connectionString, "Select * from " + tableName + " " + whereCondition, ConnectionTimeout); var set = new DataSet(); new SqlDataAdapter(com).Fill(set); return(set.Tables[0]); } catch (Exception) { { } throw; } finally { if (com != null) { ConnectionManager.ReleaseConnection(com.Connection); } } }
public List <T> RunQuery <T>(ConnectionNameEnum connectionNameEnum, string query) { List <T> list; SqlCommand com; if (connectionNameEnum == ConnectionNameEnum.DirectConnectionString) { com = GeneralMethods.MakeQuerySqlCommand(_ConnectionString, query, ConnectionTimeout, Parameters); } else { com = GeneralMethods.MakeQuerySqlCommand(connectionNameEnum, query, ConnectionTimeout, Parameters); } using (var result = com.ExecuteReader()) { try { if (typeof(T).IsValueType || "".GetType() == typeof(T)) { list = new List <T>(); Parallel.ForEach(SimpleParallelDataReader <T>(result), (data) => { list.Add(data); }); return(list); } list = new GeneralMethods().ToViewModel <T>(result); } catch (DataException) { Parameters.Clear(); throw; } finally { ConnectionManager.ReleaseConnection(com.Connection); } } return(list); }