// testing purpose: Get value from two different table public ReadTwoTableDataConcurrently GetAllValueFromDifferentTableViaDataAdapter() { ReadTwoTableDataConcurrently newDataFromTwoTable; string query = "select * from Employee; select * from EmpTags"; SqlConnection co = new SqlConnection(Configuration.GetConnectionString("KspStoreDBCon")); SqlDataAdapter dataAdapter = new SqlDataAdapter(query, co); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); dataSet.Tables[0].TableName = "Emp"; dataSet.Tables[1].TableName = "Tags"; List <Employee> employees = new List <Employee>(); // read first table data foreach (DataRow em in dataSet.Tables["Emp"].Rows) { var emp = new Employee { Id = (int)em["Id"], Name = em["Name"].ToString(), UserName = em["UserName"].ToString(), Address = em["Address"].ToString(), Email = em["Email"].ToString() }; employees.Add(emp); } List <NewClass> secondData = new List <NewClass>(); //read second table data foreach (DataRow em in dataSet.Tables["Tags"].Rows) { var ob = new NewClass { Id = (int)em["Id"], CategoryName = em["CategoryName"].ToString() }; secondData.Add(ob); } newDataFromTwoTable = new ReadTwoTableDataConcurrently { Employees = employees, NewClasses = secondData }; return(newDataFromTwoTable); }
//testing purpose public ReadTwoTableDataConcurrently GetAllValueFromDifferentTable() { ReadTwoTableDataConcurrently newDataFromTwoTable; try { string query = "select * from Employee; select * from EmpTags"; cmd.CommandText = query; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); List <Employee> employees = new List <Employee>(); // read first table data while (reader.Read()) { var emp = new Employee { Id = (int)reader["Id"], Name = reader["Name"].ToString(), UserName = reader["UserName"].ToString(), Address = reader["Address"].ToString(), Email = reader["Email"].ToString() }; employees.Add(emp); } // testing purpose: Get value from two different table List <NewClass> secondData = new List <NewClass>(); reader.NextResult(); while (reader.Read()) { var data = new NewClass { Id = (int)reader["Id"], CategoryName = reader["CategoryName"].ToString() }; secondData.Add(data); } newDataFromTwoTable = new ReadTwoTableDataConcurrently { Employees = employees, NewClasses = secondData }; reader.Close(); } finally { con.Close(); } return(newDataFromTwoTable); }