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); }