void GetRowsRequestMessageReceived(ObjectBusMessage obj) { Console.WriteLine("GetRowsRequestMessageReceived()"); GetRowsRequestMessage request = (GetRowsRequestMessage)obj; GetRowsResponseMessage response; Table table; lock (tables) table = (Table)psc.GetTableByID(request.TableID); Console.WriteLine(table.Name); try { SqlConnection conn_Rows = new SqlConnection(connectionString); try { conn_Rows.Open(); } catch { //retry once conn_Rows.Open(); } SqlCommand cmdSelect = new SqlCommand(string.Format("Select * from [{0}]", table.Name), conn_Rows); cmdSelect.CommandTimeout *= 30; response = new GetRowsResponseMessage(request.ID, readRowsData(conn_Rows, cmdSelect, cmdSelect.ExecuteReader(), table), null); } catch (Exception ex) { response = new GetRowsResponseMessage(request.ID, new List <BD2.Conv.Frontend.Table.Row> (), ex); } ObjectBusSession.SendMessage(response); Console.WriteLine("Sent GetRowsResponseMessage."); }
void GetRowsRequestMessageReceived(ObjectBusMessage obj) { GetRowsRequestMessage request = (GetRowsRequestMessage)obj; Table t; if (tables.TryGetValue(request.TableID, out t)) { } else { ObjectBusSession.SendMessage(new GetRowsResponseMessage(request.ID, new List <Row>(), new KeyNotFoundException())); } }