Hi guys.

I have a problem with this scenario. I have a BO that generates the record of his childs in automatic way. I'm doing this with a method that calls an SP in this way:

public void GenerateChildRecords( int parentID )
{
this.ExecSproc( "pr_GenerateChildRecords", this.CreateParameter("@id_Parent", parentID)

return;
}

But the BO is throwing a OUT OF TIME CONNECTION error. If I remove all the logic in the SP that affects data (all the delete an inserts transact-sql commands) it does not trhow any error.

What am I doing wrong? Do I need to generate a separate Data Access Class in order to acomplish that? Can I do this with a simple ExecSproc?


Thanks in advance

David