110,534
社区成员
发帖
与我相关
我的任务
分享
List<MyDataType> list;
using (var conn = new OracleConnection(cnStr))
{
conn.Open();
var comm = conn.CreateCommand();
comm.CommandText = "select * from all_tables where temporary='N'";
comm.CommandType = System.Data.CommandType.Text;
var result = from DbDataRecord record in comm.ExecuteReader()
let name = (string)record["X_NAME"]
where name.EndsWith("E")
select new MyDataType{ XName = name, WSize = (double)record["size"]};
list = result.ToList();
}