Hello,
I´m working with a project that needs to read EDI (Electronic Data Interchange) to process orders. I have the fixed length plain txt which I process using FileHelpers class (I fully recommend http://www.filehelpers.com ) and created the correspondig table and BO to do the CRUD work for me. The problem I´m having is that the table does not have a primary key at all. And the BO is throwing exception when I try to save the items stating that there´s no primary key.

I already tried setting the BO with the PrimaryKeyIsAutoIncremented to false and AutoUpdatable to true, same result and the only way I´ve fund the get this to work is adding a new field to hold a primary key.

So my question whould be that if I can use BOs with tables that has no primary keys at all?

I will apreciate any help or suggestion to deal with this scenario

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion

Hi Guillermo,

In the Business Object Mapper (BOM) select the BO and then select Property, there you will see an option to Override Primary Key Specification, check it and then click the ... button to select the fields you want to use as your Primary Key. 

That should do it for you.

Edhy Rijo

Thanks Edhy

I completed forgot about the Overrides Primary Key Specification.

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion

Perfect!  Thanks, Edhy

Your are welcome guys!

Edhy Rijo