比如说你可以先定义一个业务实体类型,例如 public class MyObj { public string Name; public double Value; }
然后在查询中就可以写: List<MyObj> result; using (var conn = new OracleConnection(cnStr)) { conn.Open(); var comm = conn.CreateCommand(); comm.CommandText = "select * from Users where .........."; comm.CommandType = System.Data.CommandType.Text; result = ( from DbDataRecord record in comm.ExecuteReader() let name = (string)record["TheName"] select new MyObj{ Name = name, Value = (double)record["Number"] }; ).ToList(); }
public class MyObj
{
public string Name;
public double Value;
}
然后在查询中就可以写: List<MyObj> result;
using (var conn = new OracleConnection(cnStr))
{
conn.Open();
var comm = conn.CreateCommand();
comm.CommandText = "select * from Users where ..........";
comm.CommandType = System.Data.CommandType.Text;
result = ( from DbDataRecord record in comm.ExecuteReader()
let name = (string)record["TheName"]
select new MyObj{
Name = name,
Value = (double)record["Number"]
};
).ToList();
}
剩下的,就是去查询oracle的sql方言(与SQL Server的t-sql语法稍有不同)。而跟ado.net没有关系了。