/// <summary> /// /// </summary> /// <param name="con"></param> /// <param name="commandType"></param> /// <param name="command"></param> /// <returns></returns> public static object QuickExecuteScalar(SQLiteConnection con, CommandType commandType, string command) { DBCommand cmd = new DBCommand(con, commandType, command); try { return(cmd.ExecuteScalar()); } finally { cmd.Close(); } }
/// <summary> /// /// </summary> /// <returns></returns> public int GetLastAutoIncrement() { DBCommand tmpCmd = new DBCommand(Con, CommandType.Text); tmpCmd.CommandText = "select last_insert_rowid()"; try { SQLiteDataReader r = tmpCmd.ExecuteReader(); if (r.Read()) { return(r.GetInt32(0)); } return(0); } catch { return(0); } finally { tmpCmd.Close(); } }
/// <summary> /// /// </summary> /// <returns></returns> public int GetLastAutoIncrement() { DBCommand tmpCmd = new DBCommand( Con, CommandType.Text ); tmpCmd.CommandText = "select last_insert_rowid()"; try { SQLiteDataReader r = tmpCmd.ExecuteReader(); if( r.Read() ) { return r.GetInt32( 0 ); } return 0; } catch { return 0; } finally { tmpCmd.Close(); } }
/// <summary> /// /// </summary> /// <param name="con"></param> /// <param name="commandType"></param> /// <param name="command"></param> /// <returns></returns> public static object QuickExecuteScalar( SQLiteConnection con, CommandType commandType, string command ) { DBCommand cmd = new DBCommand( con, commandType, command ); try { return cmd.ExecuteScalar(); } finally { cmd.Close(); } }