public IBeheerContextEntity GetBusinessObject(string qry, BeheerContextEntity beheerObject) { using (var conn = new OracleConnection(_oradb)) { conn.Open(); var cmd = new OracleCommand { Connection = conn, CommandText = qry, CommandType = CommandType.Text }; cmd.Connection = conn; var reader = cmd.ExecuteReader(); var smartReader = new SmartDataReader(reader); BeheerContextEntity businessObject = null; while (smartReader.Read()) { businessObject = new BeheerContextEntity { Id = smartReader.GetInt32("id"), DataKeyValue = smartReader.GetString(beheerObject.DataKeyName, ""), Tablename = beheerObject.Tablename, DataKeyName = beheerObject.DataKeyName }; } return businessObject; } }
public IList<BeheerContextEntity> GetBusinessObjects(string tableName, string kolomName) { var theTables = new List<BeheerContextEntity>(); using (OracleConnection conn = new OracleConnection(_oradb)) { conn.Open(); var cmd = new OracleCommand { Connection = conn, CommandText = "select "+ kolomName + " from " + tableName + " order by " + kolomName, CommandType = CommandType.Text }; cmd.Connection = conn; var reader = cmd.ExecuteReader(); SmartDataReader smartReader = new SmartDataReader(reader); int i = 0; while (smartReader.Read()) { BeheerContextEntity aTable = new BeheerContextEntity { Id = i++, DataKeyValue = smartReader.GetString(kolomName, ""), Tablename = tableName, DataKeyName = kolomName }; theTables.Add(aTable); } return theTables; } }