public List <TopicoModel> ObtenerTopicosArticulo(int id) { List <TopicoModel> topicos = new List <TopicoModel>(); String connectionString = ConfigurationManager.ConnectionStrings["Grupo4Conn"].ConnectionString; String sqlString = "SELECT Topico.nombreTopicoPK FROM Topico JOIN TopicosArticulo ON idArticuloFK = @id"; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand(sqlString, connection)) { connection.Open(); command.Parameters.AddWithValue("@id", id); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { TopicoModel topicoActual = new TopicoModel((string)reader["nombreTopicoPK"]); topicos.Add(topicoActual); } } } return(topicos); }
public List <TopicoModel> ObtenerAllTopicos() { List <TopicoModel> topicos = new List <TopicoModel>(); String connectionString = ConfigurationManager.ConnectionStrings["Grupo4Conn"].ConnectionString; String sqlString = "SELECT Topico.nombreTopicoPK FROM Topico"; using (SqlConnection connection = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand(sqlString, connection)) { connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { TopicoModel topicoActual = new TopicoModel((string)reader["nombreTopicoPK"]); topicos.Add(topicoActual); } } } return(topicos); }