2 // System.Data.OleDb.libgda
5 // Rodrigo Moya (rodrigo@ximian.com)
6 // Tim Coleman (tim@timcoleman.com)
8 // Copyright (C) Rodrigo Moya, 2002
9 // Copyright (C) Tim Coleman, 2002
13 using System.Data.Common;
14 using System.Runtime.InteropServices;
16 namespace System.Data.OleDb
18 internal enum GdaCommandOptions {
20 StopOnErrors = 1 << 1,
24 internal enum GdaCommandType {
33 internal enum GdaTransactionIsolation {
41 internal enum GdaValueType {
62 [StructLayout(LayoutKind.Sequential)]
63 internal class GdaDate
70 [StructLayout(LayoutKind.Sequential)]
71 internal class GdaTime
79 [StructLayout(LayoutKind.Sequential)]
80 internal class GdaTimestamp
88 public ulong fraction;
92 [StructLayout(LayoutKind.Sequential)]
93 internal class GdaList
100 sealed internal class libgda
102 private static IntPtr gdaClient = IntPtr.Zero;
104 public static IntPtr GdaClient
107 if (gdaClient == IntPtr.Zero)
108 gdaClient = gda_client_new ();
114 [DllImport("gobject-2.0",
115 EntryPoint="g_object_unref")]
116 public static extern void FreeObject (IntPtr obj);
119 public static extern void gda_init (string app_id, string version, int nargs, string[] args);
122 public static extern GdaValueType gda_value_get_type (IntPtr value);
125 public static extern long gda_value_get_bigint (IntPtr value);
128 public static extern bool gda_value_get_boolean (IntPtr value);
131 public static extern IntPtr gda_value_get_date (IntPtr value);
134 public static extern double gda_value_get_double (IntPtr value);
137 public static extern int gda_value_get_integer (IntPtr value);
140 public static extern float gda_value_get_single (IntPtr value);
143 public static extern int gda_value_get_smallint (IntPtr value);
146 public static extern string gda_value_get_string (IntPtr value);
149 public static extern IntPtr gda_value_get_time (IntPtr value);
152 public static extern IntPtr gda_value_get_timestamp (IntPtr value);
155 public static extern byte gda_value_get_tinyint (IntPtr value);
158 public static extern bool gda_value_is_null (IntPtr value);
161 public static extern string gda_value_stringify (IntPtr value);
164 public static extern IntPtr gda_parameter_list_new ();
167 public static extern string gda_type_to_string (GdaValueType type);
170 public static extern int gda_data_model_get_n_rows (IntPtr model);
173 public static extern int gda_data_model_get_n_columns (IntPtr model);
176 public static extern IntPtr gda_data_model_get_value_at (IntPtr model, int col, int row);
179 public static extern string gda_data_model_get_column_title (IntPtr model, int col);
182 public static extern IntPtr gda_data_model_describe_column (IntPtr model, int col);
185 public static extern int gda_data_model_get_column_position (IntPtr model, string name);
188 public static extern void gda_field_attributes_free (IntPtr fa);
191 public static extern string gda_field_attributes_get_name (IntPtr fa);
194 public static extern GdaValueType gda_field_attributes_get_gdatype (IntPtr fa);
197 public static extern IntPtr gda_client_new ();
200 public static extern IntPtr gda_client_open_connection (IntPtr client, string dsn, string username, string password);
203 public static extern bool gda_connection_is_open (IntPtr cnc);
206 public static extern bool gda_connection_close (IntPtr cnc);
209 public static extern string gda_connection_get_server_version (IntPtr cnc);
212 public static extern string gda_connection_get_database (IntPtr cnc);
215 public static extern string gda_connection_get_dsn (IntPtr cnc);
218 public static extern string gda_connection_get_cnc_string (IntPtr cnc);
221 public static extern string gda_connection_get_provider (IntPtr cnc);
224 public static extern string gda_connection_get_username (IntPtr cnc);
227 public static extern string gda_connection_get_password (IntPtr cnc);
230 public static extern bool gda_connection_change_database (IntPtr cnc, string name);
233 public static extern IntPtr gda_transaction_new (string name);
236 public static extern IntPtr gda_transaction_get_name (IntPtr xaction);
239 public static extern IntPtr gda_transaction_set_name (IntPtr xaction, string name);
242 public static extern GdaTransactionIsolation gda_transaction_get_isolation_level (IntPtr xaction);
245 public static extern void gda_transaction_set_isolation_level (IntPtr xaction,
246 GdaTransactionIsolation level);
249 public static extern bool gda_connection_begin_transaction (IntPtr cnc, IntPtr xaction);
252 public static extern bool gda_connection_commit_transaction (IntPtr cnc, IntPtr xaction);
255 public static extern bool gda_connection_rollback_transaction (IntPtr cnc, IntPtr xaction);
258 public static extern IntPtr gda_connection_execute_command (IntPtr cnc, IntPtr cmd, IntPtr parameterList);
261 public static extern int gda_connection_execute_non_query (IntPtr cnc, IntPtr command, IntPtr parameterList);
264 public static extern IntPtr gda_connection_execute_single_command (IntPtr cnc, IntPtr command, IntPtr parameterList);
267 public static extern IntPtr gda_connection_get_errors (IntPtr cnc);
270 public static extern IntPtr gda_command_new (string text, GdaCommandType type, GdaCommandOptions options);
273 public static extern void gda_command_set_text (IntPtr cmd, string text);
276 public static extern void gda_command_set_command_type (IntPtr cmd, GdaCommandType type);
279 public static extern string gda_error_get_description (IntPtr error);
282 public static extern long gda_error_get_number (IntPtr error);
285 public static extern string gda_error_get_source (IntPtr error);
288 public static extern string gda_error_get_sqlstate (IntPtr error);