Database Reference
In-Depth Information
VALUES " +
"(756716f7-2e54-4715-9f00-91dcbea6cf50,
'GOOG', " +
" 889.07, -4.00, -0.45);");
session.Execute("INSERT INTO portfo-
lio_demo.portfolio " +
"(portfolio_id, ticker, current_price, "
+
" current_change, current_change_percent)
VALUES " +
"(756716f7-2e54-4715-9f00-91dcbea6cf50,
'AMZN', " +
" 297.92, -0.94, -0.31);");
}
public void PrinResults() {
RowSet results = session.Execute("SELECT *
FROM " +
"portfolio_demo.portfolio WHERE portfo-
lio_id = " +
"756716f7-2e54-4715-9f00-91dcbea6cf50;");
Console.WriteLine(String.Format("{0, -7}\t{1,
-7}\t{2, -7}\t{3, -7}\r\n{4}",
"Ticker", "Price", "Change", "PCT",
"........+........+........+........"));
foreach (Row row in results.GetRows()) {
Console.WriteLine(String.Format("{0,
-7}\t{1, -7}\t{2, -7}\t{3, -7}",
row.GetValue@String:("ticker"),
row.GetValue@Decimal:("current_price"),
row.GetValue@Decimal:("current_change"),
row.GetValue@float:("current_change_percent")));
}
}
static void Main(string[] args) {
SampleApp client = new SampleApp();
