예제 #1
0
        public static void Delete(int patternId)
        {
            var sql = @"
            DELETE FROM SocketBoxPatternColors
            WHERE PatternId = " + patternId;

            var db = SocketBoxPatternColor.GetDatabase();

            db.ExecuteNonQuery(sql);
        }
예제 #2
0
        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));
        }