Exemple #1
0
        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);
        }
Exemple #2
0
        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]);
            }
        }