コード例 #1
0
        public static List <CommentSpecification> Get(int commentId)
        {
            var    db  = CommentSpecification.GetDatabase();
            string sql = @"
                SELECT * FROM CommentSpecifications
                WHERE
                    CommentId = '" + commentId + @"'
                ORDER BY
                    CommentId,
                    SpecificationId";

            return(db.ExecuteQuery <CommentSpecification>(sql));
        }
コード例 #2
0
        public static void DeleteAll()
        {
            var db = CommentSpecification.GetDatabase();

            db.ExecuteNonQuery("DELETE FROM CommentStandardRooms");
        }