private void CreateTable(FbConnection fbConnection, string tableName)
{
string createTable = String.Format("CREATE TABLE {0}" +
"(ID BIGINT NOT NULL PRIMARY KEY," +
"Symbol VARCHAR(255) NOT NULL," +
"TickTime TIMESTAMP NOT NULL," + //Time,Timestamp
"Bid REAL NOT NULL," +
"Ask REAL NOT NULL," +
"BidSize INT NOT NULL," +
"AskSize INT NOT NULL," +
"Provider VARCHAR(255) NOT NULL" +
");"
, tableName);
fbConnection.ExecuteNonQuery(createTable);
}
