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_close_v2(IntPtr db);
\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(IntPtr db, byte[] strName, int nArgs, int nType, IntPtr pvUser, SQLiteCallback func, SQLiteCallback fstep, SQLiteFinalCallback ffinal);
\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_create_function_v2(IntPtr db, byte[] strName, int nArgs, int nType, IntPtr pvUser, SQLiteCallback func, SQLiteCallback fstep, SQLiteFinalCallback ffinal, SQLiteFinalCallback fdestroy);
\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_finalize(IntPtr stmt);
\r
167 #if !PLATFORM_COMPACTFRAMEWORK
\r
168 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
170 [DllImport(SQLITE_DLL)]
\r
172 internal static extern int sqlite3_open_v2(byte[] utf8Filename, out IntPtr db, int flags, IntPtr vfs);
\r
174 // Compatibility with versions < 3.5.0
\r
175 #if !PLATFORM_COMPACTFRAMEWORK
\r
176 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
178 [DllImport(SQLITE_DLL)]
\r
180 internal static extern int sqlite3_open(byte[] utf8Filename, out IntPtr db);
\r
182 #if !PLATFORM_COMPACTFRAMEWORK
\r
183 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
185 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
187 internal static extern int sqlite3_open16(string fileName, out IntPtr db);
\r
189 #if !PLATFORM_COMPACTFRAMEWORK
\r
190 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
192 [DllImport(SQLITE_DLL)]
\r
194 internal static extern int sqlite3_reset(IntPtr stmt);
\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_bind_parameter_name(IntPtr stmt, int index);
\r
203 // Apple does not include those symbols in it's libsqlite3
\r
205 #if !PLATFORM_COMPACTFRAMEWORK
\r
206 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
208 [DllImport(SQLITE_DLL)]
\r
210 internal static extern IntPtr sqlite3_column_database_name(IntPtr stmt, int index);
\r
212 #if !PLATFORM_COMPACTFRAMEWORK
\r
213 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
215 [DllImport(SQLITE_DLL)]
\r
217 internal static extern IntPtr sqlite3_column_database_name16(IntPtr stmt, int index);
\r
220 #if !PLATFORM_COMPACTFRAMEWORK
\r
221 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
223 [DllImport(SQLITE_DLL)]
\r
225 internal static extern IntPtr sqlite3_column_decltype(IntPtr stmt, int index);
\r
227 #if !PLATFORM_COMPACTFRAMEWORK
\r
228 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
230 [DllImport(SQLITE_DLL)]
\r
232 internal static extern IntPtr sqlite3_column_decltype16(IntPtr stmt, int index);
\r
234 #if !PLATFORM_COMPACTFRAMEWORK
\r
235 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
237 [DllImport(SQLITE_DLL)]
\r
239 internal static extern IntPtr sqlite3_column_name(IntPtr stmt, int index);
\r
241 #if !PLATFORM_COMPACTFRAMEWORK
\r
242 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
244 [DllImport(SQLITE_DLL)]
\r
246 internal static extern IntPtr sqlite3_column_name16(IntPtr stmt, int index);
\r
249 #if !PLATFORM_COMPACTFRAMEWORK
\r
250 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
252 [DllImport(SQLITE_DLL)]
\r
254 internal static extern IntPtr sqlite3_column_origin_name(IntPtr stmt, int index);
\r
256 #if !PLATFORM_COMPACTFRAMEWORK
\r
257 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
259 [DllImport(SQLITE_DLL)]
\r
261 internal static extern IntPtr sqlite3_column_origin_name16(IntPtr stmt, int index);
\r
263 #if !PLATFORM_COMPACTFRAMEWORK
\r
264 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
266 [DllImport(SQLITE_DLL)]
\r
268 internal static extern IntPtr sqlite3_column_table_name(IntPtr stmt, int index);
\r
270 #if !PLATFORM_COMPACTFRAMEWORK
\r
271 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
273 [DllImport(SQLITE_DLL)]
\r
275 internal static extern IntPtr sqlite3_column_table_name16(IntPtr stmt, int index);
\r
276 #endif // !MONOTOUCH
\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_column_text(IntPtr stmt, int index);
\r
285 #if !PLATFORM_COMPACTFRAMEWORK
\r
286 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
288 [DllImport(SQLITE_DLL)]
\r
290 internal static extern IntPtr sqlite3_column_text16(IntPtr stmt, int index);
\r
292 #if !PLATFORM_COMPACTFRAMEWORK
\r
293 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
295 [DllImport(SQLITE_DLL)]
\r
297 internal static extern IntPtr sqlite3_errmsg(IntPtr db);
\r
299 #if !PLATFORM_COMPACTFRAMEWORK
\r
300 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
302 [DllImport(SQLITE_DLL)]
\r
304 internal static extern int sqlite3_prepare(IntPtr db, IntPtr pSql, int nBytes, out IntPtr stmt, out IntPtr ptrRemain);
\r
306 #if !PLATFORM_COMPACTFRAMEWORK
\r
307 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
309 [DllImport(SQLITE_DLL)]
\r
311 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
313 #if !PLATFORM_COMPACTFRAMEWORK
\r
314 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
316 [DllImport(SQLITE_DLL)]
\r
318 internal static extern IntPtr sqlite3_value_text(IntPtr p);
\r
320 #if !PLATFORM_COMPACTFRAMEWORK
\r
321 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
323 [DllImport(SQLITE_DLL)]
\r
325 internal static extern IntPtr sqlite3_value_text16(IntPtr p);
\r
330 // These functions are custom and have no equivalent standard library method.
\r
331 // All of them are "nice to haves" and not necessarily "need to haves".
\r
332 #region no equivalent standard method
\r
334 #if !SQLITE_STANDARD
\r
335 [DllImport(SQLITE_DLL)]
\r
336 internal static extern IntPtr sqlite3_context_collseq(IntPtr context, out int type, out int enc, out int len);
\r
338 [DllImport(SQLITE_DLL)]
\r
339 internal static extern int sqlite3_context_collcompare(IntPtr context, byte[] p1, int p1len, byte[] p2, int p2len);
\r
341 [DllImport(SQLITE_DLL)]
\r
342 internal static extern int sqlite3_cursor_rowid(IntPtr stmt, int cursor, out long rowid);
\r
344 [DllImport(SQLITE_DLL)]
\r
345 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
347 [DllImport(SQLITE_DLL)]
\r
348 internal static extern void sqlite3_resetall_interop(IntPtr db);
\r
350 [DllImport(SQLITE_DLL)]
\r
351 internal static extern int sqlite3_table_cursor(IntPtr stmt, int db, int tableRootPage);
\r
356 // These are obsolete and will be removed in the future
\r
357 #region windows ntfs filesystem only
\r
359 #if !SQLITE_STANDARD
\r
360 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
\r
361 internal static extern int sqlite3_compressfile(string fileName);
\r
363 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode, SetLastError = true)]
\r
364 internal static extern int sqlite3_decompressfile(string fileName);
\r
369 // Standard API calls global across versions. There are a few instances of interop calls
\r
370 // scattered in here, but they are only active when PLATFORM_COMPACTFRAMEWORK is declared.
\r
371 #region standard sqlite api calls
\r
373 #if !PLATFORM_COMPACTFRAMEWORK
\r
374 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
376 [DllImport(SQLITE_DLL)]
\r
378 internal static extern IntPtr sqlite3_libversion();
\r
380 #if !PLATFORM_COMPACTFRAMEWORK
\r
381 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
383 [DllImport(SQLITE_DLL)]
\r
385 internal static extern void sqlite3_interrupt(IntPtr db);
\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_changes(IntPtr db);
\r
394 #if !PLATFORM_COMPACTFRAMEWORK
\r
395 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
397 [DllImport(SQLITE_DLL)]
\r
399 internal static extern int sqlite3_busy_timeout(IntPtr db, int ms);
\r
401 #if !PLATFORM_COMPACTFRAMEWORK
\r
402 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
404 [DllImport(SQLITE_DLL)]
\r
406 internal static extern int sqlite3_bind_blob(IntPtr stmt, int index, Byte[] value, int nSize, IntPtr nTransient);
\r
408 #if !PLATFORM_COMPACTFRAMEWORK
\r
409 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
410 internal static extern int sqlite3_bind_double(IntPtr stmt, int index, double value);
\r
412 [DllImport(SQLITE_DLL)]
\r
413 internal static extern int sqlite3_bind_double_interop(IntPtr stmt, int index, ref double value);
\r
416 #if !PLATFORM_COMPACTFRAMEWORK
\r
417 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
419 [DllImport(SQLITE_DLL)]
\r
421 internal static extern int sqlite3_bind_int(IntPtr stmt, int index, int value);
\r
423 #if !PLATFORM_COMPACTFRAMEWORK
\r
424 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
425 internal static extern int sqlite3_bind_int64(IntPtr stmt, int index, long value);
\r
427 [DllImport(SQLITE_DLL)]
\r
428 internal static extern int sqlite3_bind_int64_interop(IntPtr stmt, int index, ref long value);
\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_null(IntPtr stmt, int index);
\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_text(IntPtr stmt, int index, byte[] value, int nlen, IntPtr pvReserved);
\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_bind_parameter_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_bind_parameter_index(IntPtr stmt, byte[] strName);
\r
459 #if !PLATFORM_COMPACTFRAMEWORK
\r
460 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
462 [DllImport(SQLITE_DLL)]
\r
464 internal static extern int sqlite3_column_count(IntPtr stmt);
\r
466 #if !PLATFORM_COMPACTFRAMEWORK
\r
467 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
469 [DllImport(SQLITE_DLL)]
\r
471 internal static extern int sqlite3_step(IntPtr stmt);
\r
473 #if !PLATFORM_COMPACTFRAMEWORK
\r
474 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
475 internal static extern double sqlite3_column_double(IntPtr stmt, int index);
\r
477 [DllImport(SQLITE_DLL)]
\r
478 internal static extern void sqlite3_column_double_interop(IntPtr stmt, int index, out double value);
\r
481 #if !PLATFORM_COMPACTFRAMEWORK
\r
482 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
484 [DllImport(SQLITE_DLL)]
\r
486 internal static extern int sqlite3_column_int(IntPtr stmt, int index);
\r
488 #if !PLATFORM_COMPACTFRAMEWORK
\r
489 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
490 internal static extern long sqlite3_column_int64(IntPtr stmt, int index);
\r
492 [DllImport(SQLITE_DLL)]
\r
493 internal static extern void sqlite3_column_int64_interop(IntPtr stmt, int index, out long value);
\r
496 #if !PLATFORM_COMPACTFRAMEWORK
\r
497 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
499 [DllImport(SQLITE_DLL)]
\r
501 internal static extern IntPtr sqlite3_column_blob(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_column_bytes(IntPtr stmt, int index);
\r
510 #if !PLATFORM_COMPACTFRAMEWORK
\r
511 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
513 [DllImport(SQLITE_DLL)]
\r
515 internal static extern TypeAffinity sqlite3_column_type(IntPtr stmt, int index);
\r
517 #if !PLATFORM_COMPACTFRAMEWORK
\r
518 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
520 [DllImport(SQLITE_DLL)]
\r
522 internal static extern int sqlite3_create_collation(IntPtr db, byte[] strName, int nType, IntPtr pvUser, SQLiteCollation func);
\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_aggregate_count(IntPtr context);
\r
531 #if !PLATFORM_COMPACTFRAMEWORK
\r
532 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
534 [DllImport(SQLITE_DLL)]
\r
536 internal static extern IntPtr sqlite3_value_blob(IntPtr p);
\r
538 #if !PLATFORM_COMPACTFRAMEWORK
\r
539 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
541 [DllImport(SQLITE_DLL)]
\r
543 internal static extern int sqlite3_value_bytes(IntPtr p);
\r
545 #if !PLATFORM_COMPACTFRAMEWORK
\r
546 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
547 internal static extern double sqlite3_value_double(IntPtr p);
\r
549 [DllImport(SQLITE_DLL)]
\r
550 internal static extern void sqlite3_value_double_interop(IntPtr p, out double value);
\r
553 #if !PLATFORM_COMPACTFRAMEWORK
\r
554 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
556 [DllImport(SQLITE_DLL)]
\r
558 internal static extern int sqlite3_value_int(IntPtr p);
\r
560 #if !PLATFORM_COMPACTFRAMEWORK
\r
561 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
562 internal static extern long sqlite3_value_int64(IntPtr p);
\r
564 [DllImport(SQLITE_DLL)]
\r
565 internal static extern void sqlite3_value_int64_interop(IntPtr p, out Int64 value);
\r
568 #if !PLATFORM_COMPACTFRAMEWORK
\r
569 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
571 [DllImport(SQLITE_DLL)]
\r
573 internal static extern TypeAffinity sqlite3_value_type(IntPtr p);
\r
575 #if !PLATFORM_COMPACTFRAMEWORK
\r
576 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
578 [DllImport(SQLITE_DLL)]
\r
580 internal static extern void sqlite3_result_blob(IntPtr context, byte[] value, int nSize, IntPtr pvReserved);
\r
582 #if !PLATFORM_COMPACTFRAMEWORK
\r
583 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
584 internal static extern void sqlite3_result_double(IntPtr context, double value);
\r
586 [DllImport(SQLITE_DLL)]
\r
587 internal static extern void sqlite3_result_double_interop(IntPtr context, ref double value);
\r
590 #if !PLATFORM_COMPACTFRAMEWORK
\r
591 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
593 [DllImport(SQLITE_DLL)]
\r
595 internal static extern void sqlite3_result_error(IntPtr context, byte[] strErr, int nLen);
\r
597 #if !PLATFORM_COMPACTFRAMEWORK
\r
598 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
600 [DllImport(SQLITE_DLL)]
\r
602 internal static extern void sqlite3_result_int(IntPtr context, int value);
\r
604 #if !PLATFORM_COMPACTFRAMEWORK
\r
605 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
606 internal static extern void sqlite3_result_int64(IntPtr context, long value);
\r
608 [DllImport(SQLITE_DLL)]
\r
609 internal static extern void sqlite3_result_int64_interop(IntPtr context, ref Int64 value);
\r
612 #if !PLATFORM_COMPACTFRAMEWORK
\r
613 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
615 [DllImport(SQLITE_DLL)]
\r
617 internal static extern void sqlite3_result_null(IntPtr context);
\r
619 #if !PLATFORM_COMPACTFRAMEWORK
\r
620 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
622 [DllImport(SQLITE_DLL)]
\r
624 internal static extern void sqlite3_result_text(IntPtr context, byte[] value, int nLen, IntPtr pvReserved);
\r
626 #if !PLATFORM_COMPACTFRAMEWORK
\r
627 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
629 [DllImport(SQLITE_DLL)]
\r
631 internal static extern IntPtr sqlite3_aggregate_context(IntPtr context, int nBytes);
\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 int sqlite3_bind_text16(IntPtr stmt, int index, string value, int nlen, IntPtr pvReserved);
\r
640 #if !PLATFORM_COMPACTFRAMEWORK
\r
641 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
643 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
645 internal static extern void sqlite3_result_error16(IntPtr context, string strName, int nLen);
\r
647 #if !PLATFORM_COMPACTFRAMEWORK
\r
648 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl, CharSet = CharSet.Unicode)]
\r
650 [DllImport(SQLITE_DLL, CharSet = CharSet.Unicode)]
\r
652 internal static extern void sqlite3_result_text16(IntPtr context, string strName, int nLen, IntPtr pvReserved);
\r
655 #if !PLATFORM_COMPACTFRAMEWORK
\r
656 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
658 [DllImport(SQLITE_DLL)]
\r
660 internal static extern int sqlite3_key(IntPtr db, byte[] key, int keylen);
\r
662 #if !PLATFORM_COMPACTFRAMEWORK
\r
663 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
665 [DllImport(SQLITE_DLL)]
\r
667 internal static extern int sqlite3_rekey(IntPtr db, byte[] key, int keylen);
\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_update_hook(IntPtr db, SQLiteUpdateCallback 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_commit_hook(IntPtr db, SQLiteCommitCallback func, IntPtr pvUser);
\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_rollback_hook(IntPtr db, SQLiteRollbackCallback func, IntPtr pvUser);
\r
691 #if !PLATFORM_COMPACTFRAMEWORK
\r
692 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
694 [DllImport(SQLITE_DLL)]
\r
696 internal static extern IntPtr sqlite3_db_handle(IntPtr stmt);
\r
698 #if !PLATFORM_COMPACTFRAMEWORK
\r
699 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
701 [DllImport(SQLITE_DLL)]
\r
703 internal static extern IntPtr sqlite3_next_stmt(IntPtr db, IntPtr stmt);
\r
705 #if !PLATFORM_COMPACTFRAMEWORK
\r
706 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
708 [DllImport(SQLITE_DLL)]
\r
710 internal static extern int sqlite3_exec(IntPtr db, byte[] strSql, IntPtr pvCallback, IntPtr pvParam, out IntPtr errMsg);
\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_config (SQLiteConfig config);
\r
719 #if !PLATFORM_COMPACTFRAMEWORK
\r
720 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
722 [DllImport(SQLITE_DLL)]
\r
724 internal static extern IntPtr sqlite3_user_data (IntPtr context);
\r
726 #if !PLATFORM_COMPACTFRAMEWORK
\r
727 [DllImport(SQLITE_DLL, CallingConvention = CallingConvention.Cdecl)]
\r
729 [DllImport(SQLITE_DLL)]
\r
731 internal static extern int sqlite3_free (IntPtr ptr);
\r
736 #if PLATFORM_COMPACTFRAMEWORK
\r
737 internal abstract class CriticalHandle : IDisposable
\r
739 private bool _isClosed;
\r
740 protected IntPtr handle;
\r
742 protected CriticalHandle(IntPtr invalidHandleValue)
\r
744 handle = invalidHandleValue;
\r
753 private void Cleanup()
\r
757 this._isClosed = true;
\r
761 GC.SuppressFinalize(this);
\r
766 public void Close()
\r
771 public void Dispose()
\r
776 protected virtual void Dispose(bool disposing)
\r
781 protected abstract bool ReleaseHandle();
\r
783 protected void SetHandle(IntPtr value)
\r
788 public void SetHandleAsInvalid()
\r
791 GC.SuppressFinalize(this);
\r
794 public bool IsClosed
\r
796 get { return _isClosed; }
\r
799 public abstract bool IsInvalid
\r
808 // Handles the unmanaged database pointer, and provides finalization support for it.
\r
809 internal class SqliteConnectionHandle : CriticalHandle
\r
811 public static implicit operator IntPtr(SqliteConnectionHandle db)
\r
816 public static implicit operator SqliteConnectionHandle(IntPtr db)
\r
818 return new SqliteConnectionHandle(db);
\r
821 private SqliteConnectionHandle(IntPtr db)
\r
827 internal SqliteConnectionHandle()
\r
828 : base(IntPtr.Zero)
\r
832 protected override bool ReleaseHandle()
\r
836 SQLiteBase.CloseConnection(this);
\r
838 catch (SqliteException)
\r
844 public override bool IsInvalid
\r
846 get { return (handle == IntPtr.Zero); }
\r
850 // Provides finalization support for unmanaged SQLite statements.
\r
851 internal class SqliteStatementHandle : CriticalHandle
\r
853 public static implicit operator IntPtr(SqliteStatementHandle stmt)
\r
855 return stmt.handle;
\r
858 public static implicit operator SqliteStatementHandle(IntPtr stmt)
\r
860 return new SqliteStatementHandle(stmt);
\r
863 private SqliteStatementHandle(IntPtr stmt)
\r
869 internal SqliteStatementHandle()
\r
870 : base(IntPtr.Zero)
\r
874 protected override bool ReleaseHandle()
\r
878 SQLiteBase.FinalizeStatement(this);
\r
880 catch (SqliteException)
\r
886 public override bool IsInvalid
\r
888 get { return (handle == IntPtr.Zero); }
\r