c# - 如何在列表中返回 SQL VIEW

Question

我通过一个过程创建了一个返回列表的代码并且它工作了，但是现在我需要返回一个视图列表 *SQL Server

我的代码：

public List<Ticket> GetTicket()
{
    List<Ticket> ticketList = new List<Ticket>();

    using (_con = new SqlConnection(_connectionString))
    {
        using (SqlCommand command = new SqlCommand("select * from MyView", _con))
        {
            command.CommandType = CommandType.TableDirect;

            _con.Open();

            SqlDataReader reader = command.ExecuteReader();
            // reader.Load(command.ExecuteReader());

            while (reader.Read())
            {
                Ticket ticket = new Ticket()
                {
                    //TicketNumber = Convert.ToInt32(reader["numeroTicket"]),
                    Priority= Convert.ToString(reader["tpr_txt_prioridade"]),
                    Status = Convert.ToString(reader["status_descri"]),
                    Client = Convert.ToString(reader["cliente"]),
                    Topic = Convert.ToString(reader["topico"]),
                    Responsible= Convert.ToString(reader["usuario_responsavel"]),
                    OpenDate = Convert.ToDateTime(reader["dt_int"]),
                    LastInteraction= Convert.ToDateTime(reader["tkt_dat_prazo"])
                };

                ticketList.Add(ticket);
            }
            return ticketList;
        }
    }
}

标签： c#.netsql-serversql-view

Answer 1

前

command.CommandType = CommandType.StoredProcedure;

后

command.CommandType = CommandType.Text;

我只需要从切换.StoredProcedure到.Text

泰！！！！！！！！！！！！