вот метод который я в контрллере вызываю public PS_CARD_TYPE Details(int ID)
{
string connectionString = ConnectionString.CName;
PS_CARD_TYPE pS = new PS_CARD_TYPE();
using (OracleConnection con = new OracleConnection(connectionString))
{
string oracleQuery = "SELECT * FROM PS_CARD_TYPE WHERE ID= " + ID;
OracleCommand cmd = new OracleCommand(oracleQuery, con);
con.Open();
OracleDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
pS.ID = Convert.ToInt32(rdr["ID"]);
pS.NAME = (rdr["NAME"]).ToString();
pS.FIRSTSYMBOLS = (rdr["FIRSTSYMBOLS"]).ToString();
pS.SERVICEADRESS = (rdr["SERVICEADRESS"]).ToString();
pS.LOGIN = (rdr["LOGIN"]).ToString();
pS.PASS = (rdr["PASS"]).ToString();
}
}
return pS;
}