本机已装Oracle服务端和客户端。
第一种 :
public class BookDal222
{
private const string strConnect = "Data Source=orcl;Persist Security Info=True;User ID=system;Password=maokun;Unicode=True";
public BookModel GetModel(int id)
{
BookModel model = new BookModel();
OracleConnection conn = new OracleConnection(strConnect);
conn.Open();
OracleCommand cmd = new OracleCommand("select * from test_books ", conn);
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
model.Bk_Id = reader["Bk_id"].ToString();
model.Bk_Name = reader["Bk_Name"].ToString();
}
reader.Close();
conn.Close();
return model;
}
}
第二种:
public class BookDal
{
a .
private const string strConnect = "Provider=OraOLEDB.Oracle.1;Data Source=orcl;User Id=system;Password=maokun;";
b. private const string strConnect = "Provider=msdaora;Data Source=orcl;User Id=system;Password=maokun;";
public BookModel GetModel(int id)
{
BookModel model = new BookModel();
OleDbConnection conn = new OleDbConnection(strConnect);
conn.Open();
OleDbCommand cmd = new OleDbCommand("select * from test_books ", conn);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
model.Bk_Id = reader["Bk_id"].ToString();
model.Bk_Name = reader["Bk_Nqame"].ToString();
}
reader.Close();
conn.Close();
return model;
}
}