Hallo,

it seems that the default DataContext implementation for the underlying PetaPoco library, differs in that insert, update and delete functions, return no value is this right?

In PetaPoco, the insert returns the primary key of the inserted record, and the update and delete return the number or rows updated/deleted.

Is there something I'm missing with the DataContext.GetIstance() and then the .GetRepository(of..) so that I have those CRUD operations returning value or should I implement directly the PetaPoco library for that functionality?

Thanks

Thank you for your kind answer as always. Good to know about the insert, that's a good thing!

About Delete and Update it could have been useful to know if those command actually had some effect and I don't think those triggered additional selects in PetaPoco. I inspected PetaPoco sources, and the count of affected lines seems to be just a default return value of the ExecuteNonQuery() function.

Using DNN DataContext if you want to check if the commands had some effect, you have to issue 2 count(*) both before and after the commands.

Hallo Cathal, I think the real "Important" thing is retrieving the auto primary key after insert and it seems that the default DataContext already does this as you explained.
About the update and delete, I don't think it's so important to jutify a breaking change. Since I'm totally new to module developement (but I used PetaPoco on my own before) I just wanted to be sure I wasn't missing something. Thanks again for your kind support!