/// <summary> /// Inserts a new path map record /// </summary> /// <param name="pathMap"> /// The path map to insert /// </param> /// <returns> /// The inserted path map, including the generated primary key /// </returns> public PathMap InsertPathMap(PathMap pathMap) { Execute( "INSERT INTO PathMap (" + "SessionID, " + "NodeID, " + "Path) " + "VALUES (@p0, @p1, @p2);", pathMap.Session.ID, pathMap.NodeID, pathMap.Path ); pathMap.ID = GetLastRowID(); return pathMap; }
/// <summary> /// Updates an existing path map record /// </summary> /// <param name="pathMap"> /// The path map to update /// </param> /// <returns> /// The updated path map record /// </returns> public PathMap UpdatePathMap(PathMap pathMap) { Execute( "UPDATE PathMap SET " + "SessionID = @p1, " + "NodeID = @p2, " + "Path = @p3 " + "WHERE ID = @p0;", pathMap.ID, pathMap.Session.ID, pathMap.NodeID, pathMap.Path ); return pathMap; }
/// <summary> /// Deletes an existing path map /// </summary> /// <param name="pathMap"> /// The path map to delete /// </param> public void DeletePathMap(PathMap pathMap) { Execute( "DELETE FROM PathMap WHERE ID = @p0;", pathMap.ID ); }