public void FailedConnectTest()
{
using (DbConnection connection = new KdbPlusConnection("server=localhost;port=11"))
{
connection.Open();
}
}
private static void RunADONetExample()
{
try
{
using (DbConnection connection = new KdbPlusConnection("server=localhost;port=1001;user id=me;password=my;buffer size=16384"))
{
// open connection - connection pooling is enabled
// to disable pooling - use Pooling=false in connection string.
connection.Open();
DbCommand command = connection.CreateCommand();
// get current time
command.CommandText = ".z.T";
TimeSpan time = (TimeSpan)command.ExecuteScalar();
Console.WriteLine("Current time {0}", time);
// create trade table
command.CommandText = "trade:([]sym:();price:();size:())";
command.ExecuteNonQuery();
command.CommandText = "`trade insert(`AIG;10.75;200)";
command.ExecuteNonQuery();
object[] x = { "xx", 93.5, 300 };
command.CommandText = "insert";
DbParameter table = command.CreateParameter();
table.Value = "trade";
command.Parameters.Add(table);
DbParameter row = command.CreateParameter();
row.Value = x;
command.Parameters.Add(row);
command.ExecuteNonQuery();
command.ExecuteNonQuery();
command.CommandText = "select from trade where sym=@sym";
command.Parameters.Clear();
DbParameter sym = command.CreateParameter();
sym.ParameterName = "@sym";
sym.Value = "AIG";
command.Parameters.Add(sym);
// get data from trade
using (IDataReader reader = command.ExecuteReader())
{
DataTable dtable = new DataTable();
dtable.Load(reader);
Console.WriteLine("Trade:");
Console.WriteLine("{0}\t{1}\t{2}", dtable.Columns[0].ColumnName, dtable.Columns[1].ColumnName, dtable.Columns[2].ColumnName);
for (int i = 0; i < dtable.Rows.Count; i++)
{
Console.WriteLine("{0}\t{1}\t{2}", dtable.Rows[i][0], dtable.Rows[i][1], dtable.Rows[i][2]);
}
}
}
}
catch (KdbPlusException ex)
{
Console.WriteLine(ex);
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
