/// <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();
}
}
