C# (CSharp) SQLite sqlite3_stmt Exemples

Exemple #1

 public static Error sqlite3_bind_text(sqlite3_stmt stmt, int index, string value) =>
 (Error)provider.sqlite3_bind_text(stmt.Handle, index, value);

Exemple #2

 public static Error sqlite3_clear_bindings(sqlite3_stmt stmt) =>
 (Error)provider.sqlite3_clear_bindings(stmt.Handle);

Exemple #3

 public static Error sqlite3_bind_double(sqlite3_stmt stmt, int index, double value) =>
 (Error)provider.sqlite3_bind_double(stmt.Handle, index, value);

Exemple #4

 public static Error sqlite3_bind_blob(sqlite3_stmt stmt, int index, byte[] value) =>
 (Error)provider.sqlite3_bind_blob(stmt.Handle, index, value);

Exemple #5

 public static Error sqlite3_bind_null(sqlite3_stmt stmt, int index) =>
 (Error)provider.sqlite3_bind_null(stmt.Handle, index);

Exemple #6

 public static Error sqlite3_bind_int64(sqlite3_stmt stmt, int index, long value) =>
 (Error)provider.sqlite3_bind_int64(stmt.Handle, index, value);

Exemple #7

 public static string sqlite3_column_name(sqlite3_stmt stmt, int column) =>
 provider.sqlite3_column_name(stmt.Handle, column);

Exemple #8

 public static double sqlite3_column_double(sqlite3_stmt stmt, int index) =>
 provider.sqlite3_column_double(stmt.Handle, index);

Exemple #9

 public static StepResult sqlite3_step(sqlite3_stmt stmt) => (StepResult)provider.sqlite3_step(stmt.Handle);

Exemple #10

 public static int sqlite3_column_count(sqlite3_stmt stmt) => provider.sqlite3_column_count(stmt.Handle);

Exemple #11

 public static Error sqlite3_finalize(sqlite3_stmt stmt)
 {
     GC.SuppressFinalize(stmt);
     return((Error)provider.sqlite3_finalize(stmt.Handle));
 }

Exemple #12

 public static string sqlite3_column_text(sqlite3_stmt stmt, int index) =>
 provider.sqlite3_column_text(stmt.Handle, index);

Exemple #13

 public static byte[] sqlite3_column_blob(sqlite3_stmt stmt, int index) =>
 provider.sqlite3_column_blob(stmt.Handle, index);

Exemple #14

 public static Error sqlite3_reset(sqlite3_stmt stmt) =>
 (Error)provider.sqlite3_reset(stmt.Handle);

Exemple #15

 public static ColumnType sqlite3_column_type(sqlite3_stmt stmt, int column) =>
 (ColumnType)provider.sqlite3_column_type(stmt.Handle, column);

Exemple #16

 public static int sqlite3_column_int(sqlite3_stmt stmt, int index) =>
 provider.sqlite3_column_int(stmt.Handle, index);

Exemple #17

Fichier : Extensions.cs Projet : chingham/SQLite.NetStandard

        public static void BindParameter(this sqlite3_stmt stmt, object parameter, int index)
        {
            try {
                if (parameter == null)
                {
                    SQLite.sqlite3_bind_null(stmt, index);
                    return;
                }

                var t = parameter.GetType();
                if (t == typeof(int))
                {
                    SQLite.sqlite3_bind_int(stmt, index, (int)parameter);
                }
                else if (t == typeof(uint))
                {
                    SQLite.sqlite3_bind_int64(stmt, index, (uint)parameter);
                }

                else if (t == typeof(short))
                {
                    SQLite.sqlite3_bind_int(stmt, index, (short)parameter);
                }
                else if (t == typeof(ushort))
                {
                    SQLite.sqlite3_bind_int(stmt, index, (ushort)parameter);
                }

                else if (t == typeof(double))
                {
                    SQLite.sqlite3_bind_double(stmt, index, (double)parameter);
                }
                else if (t == typeof(float))
                {
                    SQLite.sqlite3_bind_double(stmt, index, (float)parameter);
                }

                else if (t == typeof(long))
                {
                    SQLite.sqlite3_bind_int64(stmt, index, (long)parameter);
                }

                else if (t == typeof(byte[]))
                {
                    SQLite.sqlite3_bind_blob(stmt, index, (byte[])parameter);
                }

                else if (t == typeof(string))
                {
                    SQLite.sqlite3_bind_text(stmt, index, (string)parameter);
                }

                else
                {
                    throw new NotSupportedException();
                }
            }
            catch (NotSupportedException) { throw; }
            catch (Exception ex) {
                throw new SQLiteException("An unknown error occured: " + ex.Message, ex);
            }
        }