azure - azure 服务器上的原始sql；如何从 SELECT 语句检索结果？

Question

我正在做这个声明:

    SqlConnection connection = new SqlConnection(connectionString);

    try
    {
        connection.Open();

        string query = "SELECT * FROM [User]";

        SqlCommand command = new SqlCommand(query, connection);

        List<string> results = new List<string>();
        using (var reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                results.Add(reader.GetString(0));
            }
        }

        var x = command.ExecuteNonQuery();

        Console.WriteLine("Row retrieved successfully.");
    }

它成功了，但我只是按照“GetString()”的顺序获取列。我怎样才能把它放入我的对象中？

我该如何解决这个问题？

有人可以帮我吗？

Answer 1

它对我来说适用于以下代码，并对您的代码进行了更改。

try
    {
        connection.Open();
        string query = "SELECT * FROM [User]";
        SqlCommand command = new SqlCommand(query, connection);
        List<User> results = new List<User>();
        using (var reader = command.ExecuteReader())
            {
                 while (reader.Read())
                 {
                     User user = new User();                     
                     user.Id = reader.GetInt32(reader.GetOrdinal("Id"));
                     user.Name = reader.GetString(reader.GetOrdinal("Name"));                       user.Email = reader.GetString(reader.GetOrdinal("Email"));
                     results.Add(user);
                  }
             }

             Console.WriteLine("Rows retrieved successfully.");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Error retrieving rows: " + ex.Message);
            }
            finally
            {
                connection.Close();
            }

创建 new User object对于查询返回的每一行并使用 Get()方法来检索每列的值并将它们存储在对象中。

并添加object to a List<User>存储从查询返回的所有行。