public static void Delete(int patternId) { var sql = @" DELETE FROM SocketBoxPatternColors WHERE PatternId = " + patternId; var db = SocketBoxPatternColor.GetDatabase(); db.ExecuteNonQuery(sql); }
public static List <SocketBoxPatternColor> Get(int patternId) { var sql = @" SELECT * FROM SocketBoxPatternColors WHERE PatternId = " + patternId.ToString(); var db = SocketBoxPatternColor.GetDatabase(); return(db.ExecuteQuery <SocketBoxPatternColor>(sql)); }