public class Order
    {
        public DateTime OrderDate { get; set; }
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public decimal? Cost { get; set; }
        public string Statement { get; set; }
        public bool IsPaid { get; set; }
        public Nullable<DateTime> DatePayment { get; set; } 

        public virtual ICollection<Product> Products { get; set; }
        public ApplicationUser User { get; set; }
}
public class Product
    {
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public string Name { get; set; }
        public int Price { get; set; }
        public string Description { get; set; }

        public virtual ICollection<Order> Orders { get; set; }
    }

        [Key]
        [Column(Order = 1)]
        
        public int Product_Id { get; set; }
        [Key]
        [Column(Order = 2)]
        
        public int Order_Id { get; set; }
        public int Count { get; set; }

        [ForeignKey("Product_Id")]
        public Product Product { get; set; }

        [ForeignKey("Order_Id")]
        public Order Order { get; set; }
}

 CreateTable(
                "dbo.OrderProducts",
                c => new
                    {
                        Product_Id = c.Int(nullable: false),
                        Order_Id = c.Int(nullable: false),
                        Count = c.Int(nullable: false),
                    })
                .PrimaryKey(t => new { t.Product_Id, t.Order_Id })
                .ForeignKey("dbo.Orders", t => t.Order_Id, cascadeDelete: true)
                .ForeignKey("dbo.Products", t => t.Product_Id, cascadeDelete: true)
                .Index(t => t.Product_Id)
                .Index(t => t.Order_Id);

CreateTable(
                "dbo.ProductOrders",
                c => new
                    {
                        Product_Id = c.Int(nullable: false),
                        Order_Id = c.Int(nullable: false),
                    })
                .PrimaryKey(t => new { t.Product_Id, t.Order_Id })
                .ForeignKey("dbo.Products", t => t.Product_Id, cascadeDelete: true)
                .ForeignKey("dbo.Orders", t => t.Order_Id, cascadeDelete: true)
                .Index(t => t.Product_Id)
                .Index(t => t.Order_Id);

CREATE TABLE `Users` (
	`UserId` INT NOT NULL AUTO_INCREMENT,
	`Order_id` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`UserId`,`Order_id`)
);

CREATE TABLE `Products` (
	`ProductId` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`ProductId`)
);

CREATE TABLE `Orders` (
	`OrderId` INT NOT NULL AUTO_INCREMENT,
	`OrderId` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`OrderId`)
);

CREATE TABLE `OrderProducts` (
	`ProductId` INT NOT NULL AUTO_INCREMENT,
	`OrderId` INT NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (`ProductId`,`OrderId`)
);

ALTER TABLE `Orders` ADD CONSTRAINT `Orders_fk0` FOREIGN KEY (`OrderId`) REFERENCES `Users`(`Order_id`);

ALTER TABLE `OrderProducts` ADD CONSTRAINT `OrderProducts_fk0` FOREIGN KEY (`ProductId`) REFERENCES `Products`(`ProductId`);

ALTER TABLE `OrderProducts` ADD CONSTRAINT `OrderProducts_fk1` FOREIGN KEY (`OrderId`) REFERENCES `Orders`(`OrderId`);