Insert throws exception, but actual db insert succeeds
Joined: 27-Aug-2007
Joined: 27-Aug-2007
Hi Renée,
I can see the _LLBLGenProDataSource _here
<llblgenpro:llblgenprodatasource id="LLBLGenProDataSourceConstraints" runat="server" datacontainertype="EntityCollection"
entitycollectiontypename="ValleyTractor.DAL.CollectionClasses.CmssearchTreeConstraintCollection, ValleyTractor.DAL" >
</llblgenpro:llblgenprodatasource>
As isn't set LivePersistence, the default is true, that means _LLLBLGenProDataSource _perform the save by itself.
However at method **HandleConstraintChanges **you explicitly call entity.Save(); that means that two INSERTS are performed. One call is needless. I guess you want to perform the save manually, so you have to LivePersistence = false and implement a PerformWork. For more info read LLBLGenPro Help - Using generated code - SelfServicing - Databinding at designtime and runtime - Databinding with ASP.NET 2.0
Hope this can be useful 
Joined: 27-Aug-2007
daelmo wrote:
Hi Renée,
I can see the _LLBLGenProDataSource _here
<llblgenpro:llblgenprodatasource id="LLBLGenProDataSourceConstraints" runat="server" datacontainertype="EntityCollection" entitycollectiontypename="ValleyTractor.DAL.CollectionClasses.CmssearchTreeConstraintCollection, ValleyTractor.DAL" > </llblgenpro:llblgenprodatasource>As isn't set LivePersistence, the default is true, that means _LLLBLGenProDataSource _perform the save by itself.
However at method **HandleConstraintChanges **you explicitly call entity.Save(); that means that two INSERTS are performed. One call is needless. I guess you want to perform the save manually, so you have to LivePersistence = false and implement a PerformWork. For more info read LLBLGenPro Help - Using generated code - SelfServicing - Databinding at designtime and runtime - Databinding with ASP.NET 2.0
Hope this can be useful
This is really helpful information, and I think I understand now at least why it was happening. I have two questions:
When I turn "LivePersistance" to false, current grid items stop showing up - any ideas why?
If I implement a "PerformWork" method, how can I access the entity that is about to be saved and change the fkSearchTreeID to what's came on the query string? I've spent time looking in the documentation, but I can't find any examples. I've browsed the e.Uow item but don't even see the fkSearchTreeID value. I went back to using my HandleConstraintChanges because it works, but only if LivePersistence is off, but then I can't see my current grid items.
Thanks for your help so far, it's been great. I feel like I'm almost there.
Thanks, Renée
Hi Renée,
When you use LivePersistance=false, you have to handle this events:
PerformSelect PerformWork PerformDBCount
Here is an example of those methods:
protected void customerDS_PerformSelect(object sender, PerformSelectEventArgs2 e)
{
// fetch all customers using the information passed in via the
// PerformSelectEventArgs2 object. This select doesn't have to perform any paging, as the
// data is for a combo box.
using(DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(e.ContainedCollection, e.Filter,
e.MaxNumberOfItemsToReturn, e.Sorter, e.PrefetchPath);
}
}
protected void orderDS_PerformGetDbCount(object sender, PerformGetDbCountEventArgs2 e)
{
// get the total number of orders which match the filter passed in via the
// PerformGetDbCountEventArgs2.
using(DataAccessAdapter adapter = new DataAccessAdapter())
{
e.DbCount = adapter.GetDbCount(e.ContainedCollection, e.Filter);
}
}
protected void orderDS_PerformSelect(object sender, PerformSelectEventArgs2 e)
{
// fetch all orders which are in the selected page using the filter passed in
// via the PerformSelectEventArgs2 object.
using(DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(e.ContainedCollection, e.Filter,
e.MaxNumberOfItemsToReturn, e.Sorter, e.PrefetchPath,
e.PageNumber, e.PageSize);
}
}
firefly-renee wrote:
I've browsed the e.Uow item but don't even see the fkSearchTreeID value. I went back to using my HandleConstraintChanges because it works, but only if LivePersistence is off, but then I can't see my current grid items.
You could use these UOW methods:
- GetInsertQueue
- GetUpdateQueue
- GetEntityElementsToDelete Here are some examples of how to use them: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7833&StartAtMessage=0꣢
You can also check LLBLGenPro Reference Manual to get more info