Hello,
I deleted the OrderCustomer FK in the database & created a new one on a nvarchar field.
The reason why I'm doing this is that I have to import old historical orders of which no customer exists.
Therefor I don't have a link to the customer table but I still want to fill the Customer object in my order if the user exists.
I am getting this error:
Order_Customer_Target_Order_Customer_Source: : The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'ClientNumber' on entity 'Order' does not match the type of property 'Id' on entity 'Customer' in the referential constraint 'Order_Customer'.
The foreign key I created links from Order.ClientNumber to Customer.ClientNumber so I don't get where the ID comes from.
Can anyone help me with this one? Thanks!