protected override void Up(MigrationBuilder migrationBuilder)
        {
            var query = "CREATE VIEW V_Product AS " +
                        "SELECT P.ProductId,P.ProductName,P.UnitPrice,P.UnitInStock,C.CategoryName " +
                        "FROM dbo.Product AS P INNER JOIN dbo.Category AS C " +
                        "ON P.CategoryId = C.CategoryId";

            migrationBuilder.CreateOrDeleteView(query);
        }
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            var query = "DROP VIEW V_Product";

            migrationBuilder.CreateOrDeleteView(query);
        }