嘿我有這樣的代碼它從讀者返回模型列表。我怎樣才能做得更好？不要使用這個address.Add(new Address { ID = (int) reader["ID"], Address = reader["Address"].ToString(), PhoneNumber = (int) reader["PhoneNumber"]});但使用更多這樣的address.Add(new Address(reader?or somthing else));，或者也許如果我可以不使用列表并返回數據，僅在它返回的類中我可以添加到可觀察集合？ public async Task<IEnumerable<Address>> LoadDetail(int id) { await conn.OpenAsync(); List<Address> address = new List<Address>(); using (SqlCommand command = conn.CreateCommand()) { command.CommandText = $"SELECT * FROM Address WHERE ID = {id}";, using (SqlDataReader reader = command.ExecuteReader()) { while (await reader.ReadAsync()) { address.Add(new Address { ID = (int)reader["ID"], Address = reader["Address"].ToString(), PhoneNumber = (int)reader["PhoneNumber"] }); } } } return address; }
1 回答
LEATH
TA貢獻1936條經驗 獲得超7個贊
如果不需要異步代碼，您可以避免創建列表并編寫以下內容：
while (reader.Read())
{
yield return new Address { ID = (int)reader["ID"], Address = reader["Address"].ToString(), PhoneNumber = (int)reader["PhoneNumber"] };
}
您可以通過讀者的擴展方法來改進它：
yield return reader.GetAddress();
public static class ReaderExtensions
{
public static Address GetAddress(this SqlDataReader reader)
{
return new Address { ID = (int)reader["ID"], Address = reader["Address"].ToString(), PhoneNumber = (int)reader["PhoneNumber"] };
{
}
- 1 回答
- 0 關注
- 140 瀏覽
添加回答
舉報
0/150
提交
取消