Tuesday, February 7, 2012

EPiServer Commerce Associations

In the last couple of Commerce projects I have had trouble with associations, when saving them I get an exception. The cause for this error is two missing rows in the commerce database, the table should in a normal installation only contain this two rows and when I have had the problem the table has been empty.
-------------------
INSERT INTO [AssociationType]([AssociationTypeId],[Description]) VALUES('OPTIONAL','Optional');
INSERT INTO [AssociationType]([AssociationTypeId],[Description]) VALUES('REQUIRED','Required');
-------------------