private static QueryResult ExecuteQuery(DazzleDatabase db, string query) { Console.WriteLine(); Console.WriteLine("Query: " + query); var result = db.ExecuteQuery(query); if (result.Rows.Count > 0) { Console.WriteLine("Returned Rows: " + result.Rows.Count + " Columns per row: " + result.Rows[0].Columns.Count); } Console.WriteLine("Query executed in " + result.ExecutionTime); return(result); }
protected override void HandleData(byte[] data, System.Net.Sockets.TcpClient client) { //client.Client.BeginSend(new byte[1], 0, 1, System.Net.Sockets.SocketFlags.None, null, null); //this.Write(client, new byte[1]); //return; var messageType = (MessageType)data[0]; ushort size = BitConverter.ToUInt16(data, 1); if (messageType == MessageType.Query) { string query = UTF8Encoding.UTF8.GetString(data, 3, size); var result = db.ExecuteQuery(query); //client.Client.Send(new byte[1]); this.Write(client, new byte[1]); } }