forked from AlexandrSitdikov/monetdb-mapi-net
-
Notifications
You must be signed in to change notification settings - Fork 3
SQL
Mitchell Weg edited this page Apr 19, 2021
·
1 revision
Queries can be made using regular SQL with the MonetDbCommand class.
MonetDbCommand cmd = new MonetDbCommand("SELECT * FROM foo;", conn);
-
cmdText: string,
The SQL query.
-
connection: MonetDbConnection
MonetDbConnection object
-
transaction: MonetDbTransaction
MonetDbTranscation object
MonetDbCommand.ExecuteReader() returns a DbDataReader, where you can iterate over.
reader = command.ExecuteReader();
while(reader.Read())
{
// do something with the data...
}