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 = "sqlite3";
\r
37 // This section uses interop calls that also fetch text length to optimize conversion.
\r
38 // When using the standard dll, we can replace these calls with normal sqlite calls and do unoptimized conversions instead afterwards
\r
39 #region interop added textlength calls
\r
41 #if !SQLITE_STANDARD
\r
42 [DllImport(SQLITE_DLL)]
\r
43 internal static extern IntPtr sqlite3_bind_parameter_name_interop(IntPtr stmt, int index, out int len);
\r
45 [DllImport(SQLITE_DLL)]
\r
46 internal static extern IntPtr sqlite3_column_database_name_interop(IntPtr stmt, int index, out int len);
\r
48 [DllImport(SQLITE_DLL)]
\r
49 internal static extern IntPtr sqlite3_column_database_name16_interop(IntPtr stmt, int index, out int len);
\r
51 [DllImport(SQLITE_DLL)]
\r
52 internal static extern IntPtr sqlite3_column_decltype_interop(IntPtr stmt, int index, out int len);
\r
54 [DllImport(SQLITE_DLL)]
\r
55 internal static extern IntPtr sqlite3_column_decltype16_interop(IntPtr stmt, int index, out int len);
\r
57 [DllImport(SQLITE_DLL)]
\r
58 internal static extern IntPtr sqlite3_column_name_interop(IntPtr stmt, int index, out int len);
\r
60 [DllImport(SQLITE_DLL)]
\r
61 internal static extern IntPtr sqlite3_column_name16_interop(IntPtr stmt, int index, out int len);
\r
63 [DllImport(SQLITE_DLL)]
\r
64 internal static extern IntPtr sqlite3_column_origin_name_interop(IntPtr stmt, int index, out int len);
\r
66 [DllImport(SQLITE_DLL)]
\r
67 internal static extern IntPtr sqlite3_column_origin_name16_interop(IntPtr stmt, int index, out int len);
\r
69 [DllImport(SQLITE_DLL)]
\r
70 internal static extern IntPtr sqlite3_column_table_name_interop(IntPtr stmt, int index, out int len);
\r
72 [DllImport(SQLITE_DLL)]
\r
73 internal static extern IntPtr sqlite3_column_table_name16_interop(IntPtr stmt, int index, out int len);
\r
75 [DllImport(SQLITE_DLL)]
\r
76 internal static extern IntPtr sqlite3_column_text_interop(IntPtr stmt, int index, out int len);
\r
78 [DllImport(SQLITE_DLL)]
\r
79 internal static extern IntPtr sqlite3_column_text16_interop(IntPtr stmt, int index, out int len);
\r
81 [DllImport(SQLITE_DLL)]
\r
82 internal static extern IntPtr sqlite3_errmsg_interop(IntPtr db, out int len);
\r
84 [DllImport(SQLITE_DLL)]
\r
85 internal static extern int sqlite3_prepare_interop(IntPtr db, IntPtr pSql, int nBytes, out IntPtr stmt, out IntPtr ptrRemain, out int nRemain);
\r
87 [DllImport(SQLITE_DLL)]
\r
88 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
90 [DllImport(SQLITE_DLL)]
\r
91 internal static extern IntPtr sqlite3_value_text_interop(IntPtr p, out int len);
\r
93 [DllImport(SQLITE_DLL)]
\r
94 internal static extern IntPtr sqlite3_value_text16_interop(IntPtr p, out int len);
\r
99 // These functions add existing functionality on top of SQLite and require a little effort to
\r
100 // get working when using the standard SQLite library.
\r
101 #region interop added functionality
\r
103 #if !SQLITE_STANDARD
\r
104 [DllImport(SQLITE_DLL)]
\r
105 internal static extern int sqlite3_close_interop(IntPtr db);
\r
107 [DllImport(SQLITE_DLL)]
\r
108 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
110 [DllImport(SQLITE_DLL)]
\r
111 internal static extern int sqlite3_finalize_interop(IntPtr stmt);
\r
113 [DllImport(SQLITE_DLL)]
\r
114 internal static extern int sqlite3_open_interop(byte[] utf8Filename, int flags, out IntPtr db);
\r
116 [DllImport(SQLITE_DLL)]
\r
117 internal static extern int sqlite3_open16_interop(byte[] utf8Filename, int flags, out IntPtr db);
\r
119 [DllImport(SQLITE_DLL)]
\r
120 internal static extern int sqlite3_reset_interop(IntPtr stmt);
\r
126 // The standard api call equivalents of the above interop calls
\r
127 #region standard versions of interop functions
\r
129 #if SQLITE_STANDARD
\r
130 #if !PLATFORM_COMPACTFRAMEWORK
\r
131 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
133 [DllImport(SQLITE_DLL)]
\r
135 internal static extern int sqlite3_close(IntPtr db);
\r
137 #if !PLATFORM_COMPACTFRAMEWORK
\r
138 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
140 [DllImport(SQLITE_DLL)]
\r
142 internal static extern int sqlite3_create_function(IntPtr db, byte[] strName, int nArgs, int nType, IntPtr pvUser, SQLiteCallback func, SQLiteCallback fstep, SQLiteFinalCallback ffinal);
\r
144 #if !PLATFORM_COMPACTFRAMEWORK
\r
145 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
147 [DllImport(SQLITE_DLL)]
\r
149 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
151 #if !PLATFORM_COMPACTFRAMEWORK
\r
152 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
154 [DllImport(SQLITE_DLL)]
\r
156 internal static extern int sqlite3_finalize(IntPtr stmt);
\r
158 #if !PLATFORM_COMPACTFRAMEWORK
\r
159 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
161 [DllImport(SQLITE_DLL)]
\r
163 internal static extern int sqlite3_open_v2(byte[] utf8Filename, out IntPtr db, int flags, IntPtr vfs);
\r
165 // Compatibility with versions < 3.5.0
\r
166 #if !PLATFORM_COMPACTFRAMEWORK
\r
167 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
169 [DllImport(SQLITE_DLL)]
\r
171 internal static extern int sqlite3_open(byte[] utf8Filename, out IntPtr db);
\r
173 #if !PLATFORM_COMPACTFRAMEWORK
\r
174 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
176 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
178 internal static extern int sqlite3_open16(string fileName, out IntPtr db);
\r
180 #if !PLATFORM_COMPACTFRAMEWORK
\r
181 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
183 [DllImport(SQLITE_DLL)]
\r
185 internal static extern int sqlite3_reset(IntPtr stmt);
\r
187 #if !PLATFORM_COMPACTFRAMEWORK
\r
188 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
190 [DllImport(SQLITE_DLL)]
\r
192 internal static extern IntPtr sqlite3_bind_parameter_name(IntPtr stmt, int index);
\r
194 #if !PLATFORM_COMPACTFRAMEWORK
\r
195 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
197 [DllImport(SQLITE_DLL)]
\r
199 internal static extern IntPtr sqlite3_column_database_name(IntPtr stmt, int index);
\r
201 #if !PLATFORM_COMPACTFRAMEWORK
\r
202 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
204 [DllImport(SQLITE_DLL)]
\r
206 internal static extern IntPtr sqlite3_column_database_name16(IntPtr stmt, int index);
\r
208 #if !PLATFORM_COMPACTFRAMEWORK
\r
209 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
211 [DllImport(SQLITE_DLL)]
\r
213 internal static extern IntPtr sqlite3_column_decltype(IntPtr stmt, int index);
\r
215 #if !PLATFORM_COMPACTFRAMEWORK
\r
216 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
218 [DllImport(SQLITE_DLL)]
\r
220 internal static extern IntPtr sqlite3_column_decltype16(IntPtr stmt, int index);
\r
222 #if !PLATFORM_COMPACTFRAMEWORK
\r
223 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
225 [DllImport(SQLITE_DLL)]
\r
227 internal static extern IntPtr sqlite3_column_name(IntPtr stmt, int index);
\r
229 #if !PLATFORM_COMPACTFRAMEWORK
\r
230 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
232 [DllImport(SQLITE_DLL)]
\r
234 internal static extern IntPtr sqlite3_column_name16(IntPtr stmt, int index);
\r
236 #if !PLATFORM_COMPACTFRAMEWORK
\r
237 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
239 [DllImport(SQLITE_DLL)]
\r
241 internal static extern IntPtr sqlite3_column_origin_name(IntPtr stmt, int index);
\r
243 #if !PLATFORM_COMPACTFRAMEWORK
\r
244 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
246 [DllImport(SQLITE_DLL)]
\r
248 internal static extern IntPtr sqlite3_column_origin_name16(IntPtr stmt, int index);
\r
250 #if !PLATFORM_COMPACTFRAMEWORK
\r
251 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
253 [DllImport(SQLITE_DLL)]
\r
255 internal static extern IntPtr sqlite3_column_table_name(IntPtr stmt, int index);
\r
257 #if !PLATFORM_COMPACTFRAMEWORK
\r
258 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
260 [DllImport(SQLITE_DLL)]
\r
262 internal static extern IntPtr sqlite3_column_table_name16(IntPtr stmt, int index);
\r
264 #if !PLATFORM_COMPACTFRAMEWORK
\r
265 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
267 [DllImport(SQLITE_DLL)]
\r
269 internal static extern IntPtr sqlite3_column_text(IntPtr stmt, int index);
\r
271 #if !PLATFORM_COMPACTFRAMEWORK
\r
272 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
274 [DllImport(SQLITE_DLL)]
\r
276 internal static extern IntPtr sqlite3_column_text16(IntPtr stmt, int index);
\r
278 #if !PLATFORM_COMPACTFRAMEWORK
\r
279 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
281 [DllImport(SQLITE_DLL)]
\r
283 internal static extern IntPtr sqlite3_errmsg(IntPtr db);
\r
285 #if !PLATFORM_COMPACTFRAMEWORK
\r
286 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
288 [DllImport(SQLITE_DLL)]
\r
290 internal static extern int sqlite3_prepare(IntPtr db, IntPtr pSql, int nBytes, out IntPtr stmt, out IntPtr ptrRemain);
\r
292 #if !PLATFORM_COMPACTFRAMEWORK
\r
293 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
295 [DllImport(SQLITE_DLL)]
\r
297 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
299 #if !PLATFORM_COMPACTFRAMEWORK
\r
300 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
302 [DllImport(SQLITE_DLL)]
\r
304 internal static extern IntPtr sqlite3_value_text(IntPtr p);
\r
306 #if !PLATFORM_COMPACTFRAMEWORK
\r
307 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
309 [DllImport(SQLITE_DLL)]
\r
311 internal static extern IntPtr sqlite3_value_text16(IntPtr p);
\r
316 // These functions are custom and have no equivalent standard library method.
\r
317 // All of them are "nice to haves" and not necessarily "need to haves".
\r
318 #region no equivalent standard method
\r
320 #if !SQLITE_STANDARD
\r
321 [DllImport(SQLITE_DLL)]
\r
322 internal static extern IntPtr sqlite3_context_collseq(IntPtr context, out int type, out int enc, out int len);
\r
324 [DllImport(SQLITE_DLL)]
\r
325 internal static extern int sqlite3_context_collcompare(IntPtr context, byte[] p1, int p1len, byte[] p2, int p2len);
\r
327 [DllImport(SQLITE_DLL)]
\r
328 internal static extern int sqlite3_cursor_rowid(IntPtr stmt, int cursor, out long rowid);
\r
330 [DllImport(SQLITE_DLL)]
\r
331 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
333 [DllImport(SQLITE_DLL)]
\r
334 internal static extern void sqlite3_resetall_interop(IntPtr db);
\r
336 [DllImport(SQLITE_DLL)]
\r
337 internal static extern int sqlite3_table_cursor(IntPtr stmt, int db, int tableRootPage);
\r
342 // These are obsolete and will be removed in the future
\r
343 #region windows ntfs filesystem only
\r
345 #if !SQLITE_STANDARD
\r
346 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
\r
347 internal static extern int sqlite3_compressfile(string fileName);
\r
349 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
\r
350 internal static extern int sqlite3_decompressfile(string fileName);
\r
355 // Standard API calls global across versions. There are a few instances of interop calls
\r
356 // scattered in here, but they are only active when PLATFORM_COMPACTFRAMEWORK is declared.
\r
357 #region standard sqlite api calls
\r
359 #if !PLATFORM_COMPACTFRAMEWORK
\r
360 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
362 [DllImport(SQLITE_DLL)]
\r
364 internal static extern IntPtr sqlite3_libversion();
\r
366 #if !PLATFORM_COMPACTFRAMEWORK
\r
367 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
369 [DllImport(SQLITE_DLL)]
\r
371 internal static extern void sqlite3_interrupt(IntPtr db);
\r
373 #if !PLATFORM_COMPACTFRAMEWORK
\r
374 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
376 [DllImport(SQLITE_DLL)]
\r
378 internal static extern int sqlite3_changes(IntPtr db);
\r
380 #if !PLATFORM_COMPACTFRAMEWORK
\r
381 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
383 [DllImport(SQLITE_DLL)]
\r
385 internal static extern int sqlite3_busy_timeout(IntPtr db, int ms);
\r
387 #if !PLATFORM_COMPACTFRAMEWORK
\r
388 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
390 [DllImport(SQLITE_DLL)]
\r
392 internal static extern int sqlite3_bind_blob(IntPtr stmt, int index, Byte[] value, int nSize, IntPtr nTransient);
\r
394 #if !PLATFORM_COMPACTFRAMEWORK
\r
395 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
396 internal static extern int sqlite3_bind_double(IntPtr stmt, int index, double value);
\r
398 [DllImport(SQLITE_DLL)]
\r
399 internal static extern int sqlite3_bind_double_interop(IntPtr stmt, int index, ref double value);
\r
402 #if !PLATFORM_COMPACTFRAMEWORK
\r
403 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
405 [DllImport(SQLITE_DLL)]
\r
407 internal static extern int sqlite3_bind_int(IntPtr stmt, int index, int value);
\r
409 #if !PLATFORM_COMPACTFRAMEWORK
\r
410 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
411 internal static extern int sqlite3_bind_int64(IntPtr stmt, int index, long value);
\r
413 [DllImport(SQLITE_DLL)]
\r
414 internal static extern int sqlite3_bind_int64_interop(IntPtr stmt, int index, ref long value);
\r
417 #if !PLATFORM_COMPACTFRAMEWORK
\r
418 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
420 [DllImport(SQLITE_DLL)]
\r
422 internal static extern int sqlite3_bind_null(IntPtr stmt, int index);
\r
424 #if !PLATFORM_COMPACTFRAMEWORK
\r
425 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
427 [DllImport(SQLITE_DLL)]
\r
429 internal static extern int sqlite3_bind_text(IntPtr stmt, int index, byte[] value, int nlen, IntPtr pvReserved);
\r
431 #if !PLATFORM_COMPACTFRAMEWORK
\r
432 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
434 [DllImport(SQLITE_DLL)]
\r
436 internal static extern int sqlite3_bind_parameter_count(IntPtr stmt);
\r
438 #if !PLATFORM_COMPACTFRAMEWORK
\r
439 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
441 [DllImport(SQLITE_DLL)]
\r
443 internal static extern int sqlite3_bind_parameter_index(IntPtr stmt, byte[] strName);
\r
445 #if !PLATFORM_COMPACTFRAMEWORK
\r
446 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
448 [DllImport(SQLITE_DLL)]
\r
450 internal static extern int sqlite3_column_count(IntPtr stmt);
\r
452 #if !PLATFORM_COMPACTFRAMEWORK
\r
453 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
455 [DllImport(SQLITE_DLL)]
\r
457 internal static extern int sqlite3_step(IntPtr stmt);
\r
459 #if !PLATFORM_COMPACTFRAMEWORK
\r
460 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
461 internal static extern double sqlite3_column_double(IntPtr stmt, int index);
\r
463 [DllImport(SQLITE_DLL)]
\r
464 internal static extern void sqlite3_column_double_interop(IntPtr stmt, int index, out double value);
\r
467 #if !PLATFORM_COMPACTFRAMEWORK
\r
468 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
470 [DllImport(SQLITE_DLL)]
\r
472 internal static extern int sqlite3_column_int(IntPtr stmt, int index);
\r
474 #if !PLATFORM_COMPACTFRAMEWORK
\r
475 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
476 internal static extern long sqlite3_column_int64(IntPtr stmt, int index);
\r
478 [DllImport(SQLITE_DLL)]
\r
479 internal static extern void sqlite3_column_int64_interop(IntPtr stmt, int index, out long value);
\r
482 #if !PLATFORM_COMPACTFRAMEWORK
\r
483 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
485 [DllImport(SQLITE_DLL)]
\r
487 internal static extern IntPtr sqlite3_column_blob(IntPtr stmt, int index);
\r
489 #if !PLATFORM_COMPACTFRAMEWORK
\r
490 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
492 [DllImport(SQLITE_DLL)]
\r
494 internal static extern int sqlite3_column_bytes(IntPtr stmt, int index);
\r
496 #if !PLATFORM_COMPACTFRAMEWORK
\r
497 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
499 [DllImport(SQLITE_DLL)]
\r
501 internal static extern TypeAffinity sqlite3_column_type(IntPtr stmt, int index);
\r
503 #if !PLATFORM_COMPACTFRAMEWORK
\r
504 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
506 [DllImport(SQLITE_DLL)]
\r
508 internal static extern int sqlite3_create_collation(IntPtr db, byte[] strName, int nType, IntPtr pvUser, SQLiteCollation func);
\r
510 #if !PLATFORM_COMPACTFRAMEWORK
\r
511 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
513 [DllImport(SQLITE_DLL)]
\r
515 internal static extern int sqlite3_aggregate_count(IntPtr context);
\r
517 #if !PLATFORM_COMPACTFRAMEWORK
\r
518 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
520 [DllImport(SQLITE_DLL)]
\r
522 internal static extern IntPtr sqlite3_value_blob(IntPtr p);
\r
524 #if !PLATFORM_COMPACTFRAMEWORK
\r
525 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
527 [DllImport(SQLITE_DLL)]
\r
529 internal static extern int sqlite3_value_bytes(IntPtr p);
\r
531 #if !PLATFORM_COMPACTFRAMEWORK
\r
532 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
533 internal static extern double sqlite3_value_double(IntPtr p);
\r
535 [DllImport(SQLITE_DLL)]
\r
536 internal static extern void sqlite3_value_double_interop(IntPtr p, out double value);
\r
539 #if !PLATFORM_COMPACTFRAMEWORK
\r
540 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
542 [DllImport(SQLITE_DLL)]
\r
544 internal static extern int sqlite3_value_int(IntPtr p);
\r
546 #if !PLATFORM_COMPACTFRAMEWORK
\r
547 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
548 internal static extern long sqlite3_value_int64(IntPtr p);
\r
550 [DllImport(SQLITE_DLL)]
\r
551 internal static extern void sqlite3_value_int64_interop(IntPtr p, out Int64 value);
\r
554 #if !PLATFORM_COMPACTFRAMEWORK
\r
555 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
557 [DllImport(SQLITE_DLL)]
\r
559 internal static extern TypeAffinity sqlite3_value_type(IntPtr p);
\r
561 #if !PLATFORM_COMPACTFRAMEWORK
\r
562 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
564 [DllImport(SQLITE_DLL)]
\r
566 internal static extern void sqlite3_result_blob(IntPtr context, byte[] value, int nSize, IntPtr pvReserved);
\r
568 #if !PLATFORM_COMPACTFRAMEWORK
\r
569 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
570 internal static extern void sqlite3_result_double(IntPtr context, double value);
\r
572 [DllImport(SQLITE_DLL)]
\r
573 internal static extern void sqlite3_result_double_interop(IntPtr context, ref double value);
\r
576 #if !PLATFORM_COMPACTFRAMEWORK
\r
577 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
579 [DllImport(SQLITE_DLL)]
\r
581 internal static extern void sqlite3_result_error(IntPtr context, byte[] strErr, int nLen);
\r
583 #if !PLATFORM_COMPACTFRAMEWORK
\r
584 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
586 [DllImport(SQLITE_DLL)]
\r
588 internal static extern void sqlite3_result_int(IntPtr context, int value);
\r
590 #if !PLATFORM_COMPACTFRAMEWORK
\r
591 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
592 internal static extern void sqlite3_result_int64(IntPtr context, long value);
\r
594 [DllImport(SQLITE_DLL)]
\r
595 internal static extern void sqlite3_result_int64_interop(IntPtr context, ref Int64 value);
\r
598 #if !PLATFORM_COMPACTFRAMEWORK
\r
599 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
601 [DllImport(SQLITE_DLL)]
\r
603 internal static extern void sqlite3_result_null(IntPtr context);
\r
605 #if !PLATFORM_COMPACTFRAMEWORK
\r
606 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
608 [DllImport(SQLITE_DLL)]
\r
610 internal static extern void sqlite3_result_text(IntPtr context, byte[] value, int nLen, IntPtr pvReserved);
\r
612 #if !PLATFORM_COMPACTFRAMEWORK
\r
613 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
615 [DllImport(SQLITE_DLL)]
\r
617 internal static extern IntPtr sqlite3_aggregate_context(IntPtr context, int nBytes);
\r
619 #if !PLATFORM_COMPACTFRAMEWORK
\r
620 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
622 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
624 internal static extern int sqlite3_bind_text16(IntPtr stmt, int index, string value, int nlen, IntPtr pvReserved);
\r
626 #if !PLATFORM_COMPACTFRAMEWORK
\r
627 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
629 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
631 internal static extern void sqlite3_result_error16(IntPtr context, string strName, int nLen);
\r
633 #if !PLATFORM_COMPACTFRAMEWORK
\r
634 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
636 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
638 internal static extern void sqlite3_result_text16(IntPtr context, string strName, int nLen, IntPtr pvReserved);
\r
640 #if !PLATFORM_COMPACTFRAMEWORK
\r
641 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
643 [DllImport(SQLITE_DLL)]
\r
645 internal static extern int sqlite3_key(IntPtr db, byte[] key, int keylen);
\r
647 #if !PLATFORM_COMPACTFRAMEWORK
\r
648 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
650 [DllImport(SQLITE_DLL)]
\r
652 internal static extern int sqlite3_rekey(IntPtr db, byte[] key, int keylen);
\r
654 #if !PLATFORM_COMPACTFRAMEWORK
\r
655 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
657 [DllImport(SQLITE_DLL)]
\r
659 internal static extern IntPtr sqlite3_update_hook(IntPtr db, SQLiteUpdateCallback func, IntPtr pvUser);
\r
661 #if !PLATFORM_COMPACTFRAMEWORK
\r
662 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
664 [DllImport(SQLITE_DLL)]
\r
666 internal static extern IntPtr sqlite3_commit_hook(IntPtr db, SQLiteCommitCallback func, IntPtr pvUser);
\r
668 #if !PLATFORM_COMPACTFRAMEWORK
\r
669 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
671 [DllImport(SQLITE_DLL)]
\r
673 internal static extern IntPtr sqlite3_rollback_hook(IntPtr db, SQLiteRollbackCallback func, IntPtr pvUser);
\r
675 #if !PLATFORM_COMPACTFRAMEWORK
\r
676 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
678 [DllImport(SQLITE_DLL)]
\r
680 internal static extern IntPtr sqlite3_db_handle(IntPtr stmt);
\r
682 #if !PLATFORM_COMPACTFRAMEWORK
\r
683 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
685 [DllImport(SQLITE_DLL)]
\r
687 internal static extern IntPtr sqlite3_next_stmt(IntPtr db, IntPtr stmt);
\r
689 #if !PLATFORM_COMPACTFRAMEWORK
\r
690 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
692 [DllImport(SQLITE_DLL)]
\r
694 internal static extern int sqlite3_exec(IntPtr db, byte[] strSql, IntPtr pvCallback, IntPtr pvParam, out IntPtr errMsg);
\r
696 #if !PLATFORM_COMPACTFRAMEWORK
\r
697 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
699 [DllImport(SQLITE_DLL)]
\r
701 internal static extern int sqlite3_config (SQLiteConfig config);
\r
703 #if !PLATFORM_COMPACTFRAMEWORK
\r
704 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
706 [DllImport(SQLITE_DLL)]
\r
708 internal static extern IntPtr sqlite3_user_data (IntPtr context);
\r
710 #if !PLATFORM_COMPACTFRAMEWORK
\r
711 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
713 [DllImport(SQLITE_DLL)]
\r
715 internal static extern int sqlite3_free (IntPtr ptr);
\r
720 #if PLATFORM_COMPACTFRAMEWORK
\r
721 internal abstract class CriticalHandle : IDisposable
\r
723 private bool _isClosed;
\r
724 protected IntPtr handle;
\r
726 protected CriticalHandle(IntPtr invalidHandleValue)
\r
728 handle = invalidHandleValue;
\r
737 private void Cleanup()
\r
741 this._isClosed = true;
\r
745 GC.SuppressFinalize(this);
\r
750 public void Close()
\r
755 public void Dispose()
\r
760 protected virtual void Dispose(bool disposing)
\r
765 protected abstract bool ReleaseHandle();
\r
767 protected void SetHandle(IntPtr value)
\r
772 public void SetHandleAsInvalid()
\r
775 GC.SuppressFinalize(this);
\r
778 public bool IsClosed
\r
780 get { return _isClosed; }
\r
783 public abstract bool IsInvalid
\r
792 // Handles the unmanaged database pointer, and provides finalization support for it.
\r
793 internal class SqliteConnectionHandle : CriticalHandle
\r
795 public static implicit operator IntPtr(SqliteConnectionHandle db)
\r
800 public static implicit operator SqliteConnectionHandle(IntPtr db)
\r
802 return new SqliteConnectionHandle(db);
\r
805 private SqliteConnectionHandle(IntPtr db)
\r
811 internal SqliteConnectionHandle()
\r
812 : base(IntPtr.Zero)
\r
816 protected override bool ReleaseHandle()
\r
820 SQLiteBase.CloseConnection(this);
\r
822 catch (SqliteException)
\r
828 public override bool IsInvalid
\r
830 get { return (handle == IntPtr.Zero); }
\r
834 // Provides finalization support for unmanaged SQLite statements.
\r
835 internal class SqliteStatementHandle : CriticalHandle
\r
837 public static implicit operator IntPtr(SqliteStatementHandle stmt)
\r
839 return stmt.handle;
\r
842 public static implicit operator SqliteStatementHandle(IntPtr stmt)
\r
844 return new SqliteStatementHandle(stmt);
\r
847 private SqliteStatementHandle(IntPtr stmt)
\r
853 internal SqliteStatementHandle()
\r
854 : base(IntPtr.Zero)
\r
858 protected override bool ReleaseHandle()
\r
862 SQLiteBase.FinalizeStatement(this);
\r
864 catch (SqliteException)
\r
870 public override bool IsInvalid
\r
872 get { return (handle == IntPtr.Zero); }
\r