1 /********************************************************
\r
2 * ADO.NET 2.0 Data Provider for SQLite Version 3.X
\r
3 * Written by Robert Simpson (robert@blackcastlesoft.com)
\r
5 * Released to the public domain, use at your own risk!
\r
6 ********************************************************/
\r
8 namespace Mono.Data.Sqlite
\r
11 using System.Security;
\r
12 using System.Runtime.InteropServices;
\r
14 #if !PLATFORM_COMPACTFRAMEWORK
\r
15 [SuppressUnmanagedCodeSecurity]
\r
17 internal static class UnsafeNativeMethods
\r
19 #if !SQLITE_STANDARD
\r
21 #if !USE_INTEROP_DLL
\r
23 #if !PLATFORM_COMPACTFRAMEWORK
\r
24 private const string SQLITE_DLL = "Mono.Data.Sqlite.DLL";
\r
26 internal const string SQLITE_DLL = "SQLite.Interop.061.DLL";
\r
27 #endif // PLATFORM_COMPACTFRAMEWORK
\r
30 private const string SQLITE_DLL = "SQLite.Interop.DLL";
\r
31 #endif // USE_INTEROP_DLL
\r
34 private const string SQLITE_DLL = "/usr/lib/libsqlite3.dylib";
\r
36 private const string SQLITE_DLL = "sqlite3";
\r
39 // This section uses interop calls that also fetch text length to optimize conversion.
\r
40 // When using the standard dll, we can replace these calls with normal sqlite calls and do unoptimized conversions instead afterwards
\r
41 #region interop added textlength calls
\r
43 #if !SQLITE_STANDARD
\r
44 [DllImport(SQLITE_DLL)]
\r
45 internal static extern IntPtr sqlite3_bind_parameter_name_interop(IntPtr stmt, int index, out int len);
\r
47 [DllImport(SQLITE_DLL)]
\r
48 internal static extern IntPtr sqlite3_column_database_name_interop(IntPtr stmt, int index, out int len);
\r
50 [DllImport(SQLITE_DLL)]
\r
51 internal static extern IntPtr sqlite3_column_database_name16_interop(IntPtr stmt, int index, out int len);
\r
53 [DllImport(SQLITE_DLL)]
\r
54 internal static extern IntPtr sqlite3_column_decltype_interop(IntPtr stmt, int index, out int len);
\r
56 [DllImport(SQLITE_DLL)]
\r
57 internal static extern IntPtr sqlite3_column_decltype16_interop(IntPtr stmt, int index, out int len);
\r
59 [DllImport(SQLITE_DLL)]
\r
60 internal static extern IntPtr sqlite3_column_name_interop(IntPtr stmt, int index, out int len);
\r
62 [DllImport(SQLITE_DLL)]
\r
63 internal static extern IntPtr sqlite3_column_name16_interop(IntPtr stmt, int index, out int len);
\r
65 [DllImport(SQLITE_DLL)]
\r
66 internal static extern IntPtr sqlite3_column_origin_name_interop(IntPtr stmt, int index, out int len);
\r
68 [DllImport(SQLITE_DLL)]
\r
69 internal static extern IntPtr sqlite3_column_origin_name16_interop(IntPtr stmt, int index, out int len);
\r
71 [DllImport(SQLITE_DLL)]
\r
72 internal static extern IntPtr sqlite3_column_table_name_interop(IntPtr stmt, int index, out int len);
\r
74 [DllImport(SQLITE_DLL)]
\r
75 internal static extern IntPtr sqlite3_column_table_name16_interop(IntPtr stmt, int index, out int len);
\r
77 [DllImport(SQLITE_DLL)]
\r
78 internal static extern IntPtr sqlite3_column_text_interop(IntPtr stmt, int index, out int len);
\r
80 [DllImport(SQLITE_DLL)]
\r
81 internal static extern IntPtr sqlite3_column_text16_interop(IntPtr stmt, int index, out int len);
\r
83 [DllImport(SQLITE_DLL)]
\r
84 internal static extern IntPtr sqlite3_errmsg_interop(IntPtr db, out int len);
\r
86 [DllImport(SQLITE_DLL)]
\r
87 internal static extern int sqlite3_prepare_interop(IntPtr db, IntPtr pSql, int nBytes, out IntPtr stmt, out IntPtr ptrRemain, out int nRemain);
\r
89 [DllImport(SQLITE_DLL)]
\r
90 internal static extern int sqlite3_table_column_metadata_interop(IntPtr db, byte[] dbName, byte[] tblName, byte[] colName, out IntPtr ptrDataType, out IntPtr ptrCollSeq, out int notNull, out int primaryKey, out int autoInc, out int dtLen, out int csLen);
\r
92 [DllImport(SQLITE_DLL)]
\r
93 internal static extern IntPtr sqlite3_value_text_interop(IntPtr p, out int len);
\r
95 [DllImport(SQLITE_DLL)]
\r
96 internal static extern IntPtr sqlite3_value_text16_interop(IntPtr p, out int len);
\r
101 // These functions add existing functionality on top of SQLite and require a little effort to
\r
102 // get working when using the standard SQLite library.
\r
103 #region interop added functionality
\r
105 #if !SQLITE_STANDARD
\r
106 [DllImport(SQLITE_DLL)]
\r
107 internal static extern int sqlite3_close_interop(IntPtr db);
\r
109 [DllImport(SQLITE_DLL)]
\r
110 internal static extern int sqlite3_create_function_interop(IntPtr db, byte[] strName, int nArgs, int nType, IntPtr pvUser, SQLiteCallback func, SQLiteCallback fstep, SQLiteFinalCallback ffinal, int needCollSeq);
\r
112 [DllImport(SQLITE_DLL)]
\r
113 internal static extern int sqlite3_finalize_interop(IntPtr stmt);
\r
115 [DllImport(SQLITE_DLL)]
\r
116 internal static extern int sqlite3_open_interop(byte[] utf8Filename, int flags, out IntPtr db);
\r
118 [DllImport(SQLITE_DLL)]
\r
119 internal static extern int sqlite3_open16_interop(byte[] utf8Filename, int flags, out IntPtr db);
\r
121 [DllImport(SQLITE_DLL)]
\r
122 internal static extern int sqlite3_reset_interop(IntPtr stmt);
\r
128 // The standard api call equivalents of the above interop calls
\r
129 #region standard versions of interop functions
\r
131 #if SQLITE_STANDARD
\r
132 #if !PLATFORM_COMPACTFRAMEWORK
\r
133 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
135 [DllImport(SQLITE_DLL)]
\r
137 internal static extern int sqlite3_close(IntPtr db);
\r
139 #if !PLATFORM_COMPACTFRAMEWORK
\r
140 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
142 [DllImport(SQLITE_DLL)]
\r
144 internal static extern int sqlite3_create_function(IntPtr db, byte[] strName, int nArgs, int nType, IntPtr pvUser, SQLiteCallback func, SQLiteCallback fstep, SQLiteFinalCallback ffinal);
\r
146 #if !PLATFORM_COMPACTFRAMEWORK
\r
147 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
149 [DllImport(SQLITE_DLL)]
\r
151 internal static extern int sqlite3_create_function_v2(IntPtr db, byte[] strName, int nArgs, int nType, IntPtr pvUser, SQLiteCallback func, SQLiteCallback fstep, SQLiteFinalCallback ffinal, SQLiteFinalCallback fdestroy);
\r
153 #if !PLATFORM_COMPACTFRAMEWORK
\r
154 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
156 [DllImport(SQLITE_DLL)]
\r
158 internal static extern int sqlite3_finalize(IntPtr stmt);
\r
160 #if !PLATFORM_COMPACTFRAMEWORK
\r
161 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
163 [DllImport(SQLITE_DLL)]
\r
165 internal static extern int sqlite3_open_v2(byte[] utf8Filename, out IntPtr db, int flags, IntPtr vfs);
\r
167 // Compatibility with versions < 3.5.0
\r
168 #if !PLATFORM_COMPACTFRAMEWORK
\r
169 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
171 [DllImport(SQLITE_DLL)]
\r
173 internal static extern int sqlite3_open(byte[] utf8Filename, out IntPtr db);
\r
175 #if !PLATFORM_COMPACTFRAMEWORK
\r
176 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
178 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
180 internal static extern int sqlite3_open16(string fileName, out IntPtr db);
\r
182 #if !PLATFORM_COMPACTFRAMEWORK
\r
183 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
185 [DllImport(SQLITE_DLL)]
\r
187 internal static extern int sqlite3_reset(IntPtr stmt);
\r
189 #if !PLATFORM_COMPACTFRAMEWORK
\r
190 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
192 [DllImport(SQLITE_DLL)]
\r
194 internal static extern IntPtr sqlite3_bind_parameter_name(IntPtr stmt, int index);
\r
196 #if !PLATFORM_COMPACTFRAMEWORK
\r
197 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
199 [DllImport(SQLITE_DLL)]
\r
201 internal static extern IntPtr sqlite3_column_database_name(IntPtr stmt, int index);
\r
203 #if !PLATFORM_COMPACTFRAMEWORK
\r
204 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
206 [DllImport(SQLITE_DLL)]
\r
208 internal static extern IntPtr sqlite3_column_database_name16(IntPtr stmt, int index);
\r
210 #if !PLATFORM_COMPACTFRAMEWORK
\r
211 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
213 [DllImport(SQLITE_DLL)]
\r
215 internal static extern IntPtr sqlite3_column_decltype(IntPtr stmt, int index);
\r
217 #if !PLATFORM_COMPACTFRAMEWORK
\r
218 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
220 [DllImport(SQLITE_DLL)]
\r
222 internal static extern IntPtr sqlite3_column_decltype16(IntPtr stmt, int index);
\r
224 #if !PLATFORM_COMPACTFRAMEWORK
\r
225 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
227 [DllImport(SQLITE_DLL)]
\r
229 internal static extern IntPtr sqlite3_column_name(IntPtr stmt, int index);
\r
231 #if !PLATFORM_COMPACTFRAMEWORK
\r
232 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
234 [DllImport(SQLITE_DLL)]
\r
236 internal static extern IntPtr sqlite3_column_name16(IntPtr stmt, int index);
\r
238 #if !PLATFORM_COMPACTFRAMEWORK
\r
239 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
241 [DllImport(SQLITE_DLL)]
\r
243 internal static extern IntPtr sqlite3_column_origin_name(IntPtr stmt, int index);
\r
245 #if !PLATFORM_COMPACTFRAMEWORK
\r
246 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
248 [DllImport(SQLITE_DLL)]
\r
250 internal static extern IntPtr sqlite3_column_origin_name16(IntPtr stmt, int index);
\r
252 #if !PLATFORM_COMPACTFRAMEWORK
\r
253 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
255 [DllImport(SQLITE_DLL)]
\r
257 internal static extern IntPtr sqlite3_column_table_name(IntPtr stmt, int index);
\r
259 #if !PLATFORM_COMPACTFRAMEWORK
\r
260 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
262 [DllImport(SQLITE_DLL)]
\r
264 internal static extern IntPtr sqlite3_column_table_name16(IntPtr stmt, int index);
\r
266 #if !PLATFORM_COMPACTFRAMEWORK
\r
267 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
269 [DllImport(SQLITE_DLL)]
\r
271 internal static extern IntPtr sqlite3_column_text(IntPtr stmt, int index);
\r
273 #if !PLATFORM_COMPACTFRAMEWORK
\r
274 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
276 [DllImport(SQLITE_DLL)]
\r
278 internal static extern IntPtr sqlite3_column_text16(IntPtr stmt, int index);
\r
280 #if !PLATFORM_COMPACTFRAMEWORK
\r
281 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
283 [DllImport(SQLITE_DLL)]
\r
285 internal static extern IntPtr sqlite3_errmsg(IntPtr db);
\r
287 #if !PLATFORM_COMPACTFRAMEWORK
\r
288 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
290 [DllImport(SQLITE_DLL)]
\r
292 internal static extern int sqlite3_prepare(IntPtr db, IntPtr pSql, int nBytes, out IntPtr stmt, out IntPtr ptrRemain);
\r
294 #if !PLATFORM_COMPACTFRAMEWORK
\r
295 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
297 [DllImport(SQLITE_DLL)]
\r
299 internal static extern int sqlite3_table_column_metadata(IntPtr db, byte[] dbName, byte[] tblName, byte[] colName, out IntPtr ptrDataType, out IntPtr ptrCollSeq, out int notNull, out int primaryKey, out int autoInc);
\r
301 #if !PLATFORM_COMPACTFRAMEWORK
\r
302 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
304 [DllImport(SQLITE_DLL)]
\r
306 internal static extern IntPtr sqlite3_value_text(IntPtr p);
\r
308 #if !PLATFORM_COMPACTFRAMEWORK
\r
309 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
311 [DllImport(SQLITE_DLL)]
\r
313 internal static extern IntPtr sqlite3_value_text16(IntPtr p);
\r
318 // These functions are custom and have no equivalent standard library method.
\r
319 // All of them are "nice to haves" and not necessarily "need to haves".
\r
320 #region no equivalent standard method
\r
322 #if !SQLITE_STANDARD
\r
323 [DllImport(SQLITE_DLL)]
\r
324 internal static extern IntPtr sqlite3_context_collseq(IntPtr context, out int type, out int enc, out int len);
\r
326 [DllImport(SQLITE_DLL)]
\r
327 internal static extern int sqlite3_context_collcompare(IntPtr context, byte[] p1, int p1len, byte[] p2, int p2len);
\r
329 [DllImport(SQLITE_DLL)]
\r
330 internal static extern int sqlite3_cursor_rowid(IntPtr stmt, int cursor, out long rowid);
\r
332 [DllImport(SQLITE_DLL)]
\r
333 internal static extern int sqlite3_index_column_info_interop(IntPtr db, byte[] catalog, byte[] IndexName, byte[] ColumnName, out int sortOrder, out int onError, out IntPtr Collation, out int colllen);
\r
335 [DllImport(SQLITE_DLL)]
\r
336 internal static extern void sqlite3_resetall_interop(IntPtr db);
\r
338 [DllImport(SQLITE_DLL)]
\r
339 internal static extern int sqlite3_table_cursor(IntPtr stmt, int db, int tableRootPage);
\r
344 // These are obsolete and will be removed in the future
\r
345 #region windows ntfs filesystem only
\r
347 #if !SQLITE_STANDARD
\r
348 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
\r
349 internal static extern int sqlite3_compressfile(string fileName);
\r
351 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
\r
352 internal static extern int sqlite3_decompressfile(string fileName);
\r
357 // Standard API calls global across versions. There are a few instances of interop calls
\r
358 // scattered in here, but they are only active when PLATFORM_COMPACTFRAMEWORK is declared.
\r
359 #region standard sqlite api calls
\r
361 #if !PLATFORM_COMPACTFRAMEWORK
\r
362 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
364 [DllImport(SQLITE_DLL)]
\r
366 internal static extern IntPtr sqlite3_libversion();
\r
368 #if !PLATFORM_COMPACTFRAMEWORK
\r
369 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
371 [DllImport(SQLITE_DLL)]
\r
373 internal static extern void sqlite3_interrupt(IntPtr db);
\r
375 #if !PLATFORM_COMPACTFRAMEWORK
\r
376 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
378 [DllImport(SQLITE_DLL)]
\r
380 internal static extern int sqlite3_changes(IntPtr db);
\r
382 #if !PLATFORM_COMPACTFRAMEWORK
\r
383 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
385 [DllImport(SQLITE_DLL)]
\r
387 internal static extern int sqlite3_busy_timeout(IntPtr db, int ms);
\r
389 #if !PLATFORM_COMPACTFRAMEWORK
\r
390 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
392 [DllImport(SQLITE_DLL)]
\r
394 internal static extern int sqlite3_bind_blob(IntPtr stmt, int index, Byte[] value, int nSize, IntPtr nTransient);
\r
396 #if !PLATFORM_COMPACTFRAMEWORK
\r
397 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
398 internal static extern int sqlite3_bind_double(IntPtr stmt, int index, double value);
\r
400 [DllImport(SQLITE_DLL)]
\r
401 internal static extern int sqlite3_bind_double_interop(IntPtr stmt, int index, ref double value);
\r
404 #if !PLATFORM_COMPACTFRAMEWORK
\r
405 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
407 [DllImport(SQLITE_DLL)]
\r
409 internal static extern int sqlite3_bind_int(IntPtr stmt, int index, int value);
\r
411 #if !PLATFORM_COMPACTFRAMEWORK
\r
412 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
413 internal static extern int sqlite3_bind_int64(IntPtr stmt, int index, long value);
\r
415 [DllImport(SQLITE_DLL)]
\r
416 internal static extern int sqlite3_bind_int64_interop(IntPtr stmt, int index, ref long value);
\r
419 #if !PLATFORM_COMPACTFRAMEWORK
\r
420 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
422 [DllImport(SQLITE_DLL)]
\r
424 internal static extern int sqlite3_bind_null(IntPtr stmt, int index);
\r
426 #if !PLATFORM_COMPACTFRAMEWORK
\r
427 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
429 [DllImport(SQLITE_DLL)]
\r
431 internal static extern int sqlite3_bind_text(IntPtr stmt, int index, byte[] value, int nlen, IntPtr pvReserved);
\r
433 #if !PLATFORM_COMPACTFRAMEWORK
\r
434 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
436 [DllImport(SQLITE_DLL)]
\r
438 internal static extern int sqlite3_bind_parameter_count(IntPtr stmt);
\r
440 #if !PLATFORM_COMPACTFRAMEWORK
\r
441 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
443 [DllImport(SQLITE_DLL)]
\r
445 internal static extern int sqlite3_bind_parameter_index(IntPtr stmt, byte[] strName);
\r
447 #if !PLATFORM_COMPACTFRAMEWORK
\r
448 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
450 [DllImport(SQLITE_DLL)]
\r
452 internal static extern int sqlite3_column_count(IntPtr stmt);
\r
454 #if !PLATFORM_COMPACTFRAMEWORK
\r
455 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
457 [DllImport(SQLITE_DLL)]
\r
459 internal static extern int sqlite3_step(IntPtr stmt);
\r
461 #if !PLATFORM_COMPACTFRAMEWORK
\r
462 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
463 internal static extern double sqlite3_column_double(IntPtr stmt, int index);
\r
465 [DllImport(SQLITE_DLL)]
\r
466 internal static extern void sqlite3_column_double_interop(IntPtr stmt, int index, out double value);
\r
469 #if !PLATFORM_COMPACTFRAMEWORK
\r
470 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
472 [DllImport(SQLITE_DLL)]
\r
474 internal static extern int sqlite3_column_int(IntPtr stmt, int index);
\r
476 #if !PLATFORM_COMPACTFRAMEWORK
\r
477 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
478 internal static extern long sqlite3_column_int64(IntPtr stmt, int index);
\r
480 [DllImport(SQLITE_DLL)]
\r
481 internal static extern void sqlite3_column_int64_interop(IntPtr stmt, int index, out long value);
\r
484 #if !PLATFORM_COMPACTFRAMEWORK
\r
485 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
487 [DllImport(SQLITE_DLL)]
\r
489 internal static extern IntPtr sqlite3_column_blob(IntPtr stmt, int index);
\r
491 #if !PLATFORM_COMPACTFRAMEWORK
\r
492 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
494 [DllImport(SQLITE_DLL)]
\r
496 internal static extern int sqlite3_column_bytes(IntPtr stmt, int index);
\r
498 #if !PLATFORM_COMPACTFRAMEWORK
\r
499 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
501 [DllImport(SQLITE_DLL)]
\r
503 internal static extern TypeAffinity sqlite3_column_type(IntPtr stmt, int index);
\r
505 #if !PLATFORM_COMPACTFRAMEWORK
\r
506 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
508 [DllImport(SQLITE_DLL)]
\r
510 internal static extern int sqlite3_create_collation(IntPtr db, byte[] strName, int nType, IntPtr pvUser, SQLiteCollation func);
\r
512 #if !PLATFORM_COMPACTFRAMEWORK
\r
513 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
515 [DllImport(SQLITE_DLL)]
\r
517 internal static extern int sqlite3_aggregate_count(IntPtr context);
\r
519 #if !PLATFORM_COMPACTFRAMEWORK
\r
520 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
522 [DllImport(SQLITE_DLL)]
\r
524 internal static extern IntPtr sqlite3_value_blob(IntPtr p);
\r
526 #if !PLATFORM_COMPACTFRAMEWORK
\r
527 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
529 [DllImport(SQLITE_DLL)]
\r
531 internal static extern int sqlite3_value_bytes(IntPtr p);
\r
533 #if !PLATFORM_COMPACTFRAMEWORK
\r
534 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
535 internal static extern double sqlite3_value_double(IntPtr p);
\r
537 [DllImport(SQLITE_DLL)]
\r
538 internal static extern void sqlite3_value_double_interop(IntPtr p, out double value);
\r
541 #if !PLATFORM_COMPACTFRAMEWORK
\r
542 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
544 [DllImport(SQLITE_DLL)]
\r
546 internal static extern int sqlite3_value_int(IntPtr p);
\r
548 #if !PLATFORM_COMPACTFRAMEWORK
\r
549 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
550 internal static extern long sqlite3_value_int64(IntPtr p);
\r
552 [DllImport(SQLITE_DLL)]
\r
553 internal static extern void sqlite3_value_int64_interop(IntPtr p, out Int64 value);
\r
556 #if !PLATFORM_COMPACTFRAMEWORK
\r
557 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
559 [DllImport(SQLITE_DLL)]
\r
561 internal static extern TypeAffinity sqlite3_value_type(IntPtr p);
\r
563 #if !PLATFORM_COMPACTFRAMEWORK
\r
564 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
566 [DllImport(SQLITE_DLL)]
\r
568 internal static extern void sqlite3_result_blob(IntPtr context, byte[] value, int nSize, IntPtr pvReserved);
\r
570 #if !PLATFORM_COMPACTFRAMEWORK
\r
571 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
572 internal static extern void sqlite3_result_double(IntPtr context, double value);
\r
574 [DllImport(SQLITE_DLL)]
\r
575 internal static extern void sqlite3_result_double_interop(IntPtr context, ref double value);
\r
578 #if !PLATFORM_COMPACTFRAMEWORK
\r
579 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
581 [DllImport(SQLITE_DLL)]
\r
583 internal static extern void sqlite3_result_error(IntPtr context, byte[] strErr, int nLen);
\r
585 #if !PLATFORM_COMPACTFRAMEWORK
\r
586 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
588 [DllImport(SQLITE_DLL)]
\r
590 internal static extern void sqlite3_result_int(IntPtr context, int value);
\r
592 #if !PLATFORM_COMPACTFRAMEWORK
\r
593 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
594 internal static extern void sqlite3_result_int64(IntPtr context, long value);
\r
596 [DllImport(SQLITE_DLL)]
\r
597 internal static extern void sqlite3_result_int64_interop(IntPtr context, ref Int64 value);
\r
600 #if !PLATFORM_COMPACTFRAMEWORK
\r
601 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
603 [DllImport(SQLITE_DLL)]
\r
605 internal static extern void sqlite3_result_null(IntPtr context);
\r
607 #if !PLATFORM_COMPACTFRAMEWORK
\r
608 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
610 [DllImport(SQLITE_DLL)]
\r
612 internal static extern void sqlite3_result_text(IntPtr context, byte[] value, int nLen, IntPtr pvReserved);
\r
614 #if !PLATFORM_COMPACTFRAMEWORK
\r
615 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
617 [DllImport(SQLITE_DLL)]
\r
619 internal static extern IntPtr sqlite3_aggregate_context(IntPtr context, int nBytes);
\r
621 #if !PLATFORM_COMPACTFRAMEWORK
\r
622 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
624 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
626 internal static extern int sqlite3_bind_text16(IntPtr stmt, int index, string value, int nlen, IntPtr pvReserved);
\r
628 #if !PLATFORM_COMPACTFRAMEWORK
\r
629 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
631 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
633 internal static extern void sqlite3_result_error16(IntPtr context, string strName, int nLen);
\r
635 #if !PLATFORM_COMPACTFRAMEWORK
\r
636 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
638 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
640 internal static extern void sqlite3_result_text16(IntPtr context, string strName, int nLen, IntPtr pvReserved);
\r
642 #if !PLATFORM_COMPACTFRAMEWORK
\r
643 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
645 [DllImport(SQLITE_DLL)]
\r
647 internal static extern int sqlite3_key(IntPtr db, byte[] key, int keylen);
\r
649 #if !PLATFORM_COMPACTFRAMEWORK
\r
650 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
652 [DllImport(SQLITE_DLL)]
\r
654 internal static extern int sqlite3_rekey(IntPtr db, byte[] key, int keylen);
\r
656 #if !PLATFORM_COMPACTFRAMEWORK
\r
657 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
659 [DllImport(SQLITE_DLL)]
\r
661 internal static extern IntPtr sqlite3_update_hook(IntPtr db, SQLiteUpdateCallback func, IntPtr pvUser);
\r
663 #if !PLATFORM_COMPACTFRAMEWORK
\r
664 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
666 [DllImport(SQLITE_DLL)]
\r
668 internal static extern IntPtr sqlite3_commit_hook(IntPtr db, SQLiteCommitCallback func, IntPtr pvUser);
\r
670 #if !PLATFORM_COMPACTFRAMEWORK
\r
671 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
673 [DllImport(SQLITE_DLL)]
\r
675 internal static extern IntPtr sqlite3_rollback_hook(IntPtr db, SQLiteRollbackCallback func, IntPtr pvUser);
\r
677 #if !PLATFORM_COMPACTFRAMEWORK
\r
678 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
680 [DllImport(SQLITE_DLL)]
\r
682 internal static extern IntPtr sqlite3_db_handle(IntPtr stmt);
\r
684 #if !PLATFORM_COMPACTFRAMEWORK
\r
685 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
687 [DllImport(SQLITE_DLL)]
\r
689 internal static extern IntPtr sqlite3_next_stmt(IntPtr db, IntPtr stmt);
\r
691 #if !PLATFORM_COMPACTFRAMEWORK
\r
692 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
694 [DllImport(SQLITE_DLL)]
\r
696 internal static extern int sqlite3_exec(IntPtr db, byte[] strSql, IntPtr pvCallback, IntPtr pvParam, out IntPtr errMsg);
\r
698 #if !PLATFORM_COMPACTFRAMEWORK
\r
699 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
701 [DllImport(SQLITE_DLL)]
\r
703 internal static extern int sqlite3_config (SQLiteConfig config);
\r
705 #if !PLATFORM_COMPACTFRAMEWORK
\r
706 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
708 [DllImport(SQLITE_DLL)]
\r
710 internal static extern IntPtr sqlite3_user_data (IntPtr context);
\r
712 #if !PLATFORM_COMPACTFRAMEWORK
\r
713 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
715 [DllImport(SQLITE_DLL)]
\r
717 internal static extern int sqlite3_free (IntPtr ptr);
\r
722 #if PLATFORM_COMPACTFRAMEWORK
\r
723 internal abstract class CriticalHandle : IDisposable
\r
725 private bool _isClosed;
\r
726 protected IntPtr handle;
\r
728 protected CriticalHandle(IntPtr invalidHandleValue)
\r
730 handle = invalidHandleValue;
\r
739 private void Cleanup()
\r
743 this._isClosed = true;
\r
747 GC.SuppressFinalize(this);
\r
752 public void Close()
\r
757 public void Dispose()
\r
762 protected virtual void Dispose(bool disposing)
\r
767 protected abstract bool ReleaseHandle();
\r
769 protected void SetHandle(IntPtr value)
\r
774 public void SetHandleAsInvalid()
\r
777 GC.SuppressFinalize(this);
\r
780 public bool IsClosed
\r
782 get { return _isClosed; }
\r
785 public abstract bool IsInvalid
\r
794 // Handles the unmanaged database pointer, and provides finalization support for it.
\r
795 internal class SqliteConnectionHandle : CriticalHandle
\r
797 public static implicit operator IntPtr(SqliteConnectionHandle db)
\r
802 public static implicit operator SqliteConnectionHandle(IntPtr db)
\r
804 return new SqliteConnectionHandle(db);
\r
807 private SqliteConnectionHandle(IntPtr db)
\r
813 internal SqliteConnectionHandle()
\r
814 : base(IntPtr.Zero)
\r
818 protected override bool ReleaseHandle()
\r
822 SQLiteBase.CloseConnection(this);
\r
824 catch (SqliteException)
\r
830 public override bool IsInvalid
\r
832 get { return (handle == IntPtr.Zero); }
\r
836 // Provides finalization support for unmanaged SQLite statements.
\r
837 internal class SqliteStatementHandle : CriticalHandle
\r
839 public static implicit operator IntPtr(SqliteStatementHandle stmt)
\r
841 return stmt.handle;
\r
844 public static implicit operator SqliteStatementHandle(IntPtr stmt)
\r
846 return new SqliteStatementHandle(stmt);
\r
849 private SqliteStatementHandle(IntPtr stmt)
\r
855 internal SqliteStatementHandle()
\r
856 : base(IntPtr.Zero)
\r
860 protected override bool ReleaseHandle()
\r
864 SQLiteBase.FinalizeStatement(this);
\r
866 catch (SqliteException)
\r
872 public override bool IsInvalid
\r
874 get { return (handle == IntPtr.Zero); }
\r