Help me fly man ... I'm grounded.
I thought this recursive save would be easy.
Booking has passengers
Booking has Services
Services have prices
All 1:n relationships
Adding passenger and service to booking and doing a recursive save works fine.
However, as soon as I add a ServicePrice entity I run into problems:=
An unhandled exception of type 'SD.LLBLGen.Pro.ORMSupportClasses.ORMQueryExecutionException' occurred in bl.dll
Additional information: An exception was caught during the execution of an action query: Cannot insert the value NULL into column 'Service_ID', table 'Yatra.dbo.ServicePrice'; column does not allow nulls. INSERT fails.
The statement has been terminated.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.
Now recursive saves should assign this fkey value because PK Service.Service_ID has a value.
Any thoughts before I shoot myself !!!!