C# Pgnsql Swagger
- Konuyu başlatan UNKWTR
- Başlangıç tarihi
Çözüm
- Konuyu başlatan
- #3
public List<Location> GetAll()
{
con.Open();
NpgsqlCommand c2 = new NpgsqlCommand(" SELECT * FROM locationtables ", con);
List<Location> list = new List<Location>();
Location _newLocation = new Location();
NpgsqlDataReader r1 = c2.ExecuteReader();
while (r1.Read())
{
_newLocation.id = r1.GetInt32(0);
_newLocation.name = r1.GetString(1);
_newLocation.x = r1.GetDouble(2);
_newLocation.y = r1.GetDouble(3);
list.Add(_newLocation);
}
r1.Close();
con.Close();
return list;
}
{
con.Open();
NpgsqlCommand c2 = new NpgsqlCommand(" SELECT * FROM locationtables ", con);
List<Location> list = new List<Location>();
Location _newLocation = new Location();
NpgsqlDataReader r1 = c2.ExecuteReader();
while (r1.Read())
{
_newLocation.id = r1.GetInt32(0);
_newLocation.name = r1.GetString(1);
_newLocation.x = r1.GetDouble(2);
_newLocation.y = r1.GetDouble(3);
list.Add(_newLocation);
}
r1.Close();
con.Close();
return list;
}
