public void Delete() { var cmd = SessionDatabase.CreateCommand(); cmd.CommandText = "DELETE FROM sessions WHERE sessionid = @sessionid"; cmd.Parameters.AddWithValue("@sessionid", SessionID); cmd.ExecuteNonQuery(); }
public string Get(string name) { var cmd = SessionDatabase.CreateCommand(); cmd.CommandText = "SELECT value FROM sessions WHERE sessionid = @sessionid AND name = @name"; cmd.Parameters.AddWithValue("@sessionid", SessionID); cmd.Parameters.AddWithValue("@name", name); var result = cmd.ExecuteScalar(); return(result == null ? null : result.ToString()); }
public void Set(string name, string value) { if (value == null) { Delete(name); } else { var cmd = SessionDatabase.CreateCommand(); cmd.CommandText = "INSERT OR REPLACE INTO sessions (sessionid, name, value) VALUES (@sessionid, @name, @value)"; cmd.Parameters.AddWithValue("@sessionid", SessionID); cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@value", value); cmd.ExecuteNonQuery(); } }