I am writing C# apps for my (small) company.
We are basically doing always the same kind of applications that need to read and write into a MySQL database.
So what we usually need is
1) to edit lists of elements with filtering possibilities.
2) edit, create or duplicate, delete one specific element
So what I want is to build some abstract class or interface that could help me saving time writing always the same stuff each time a concept is added to our model and database.
I was thinking about creating an abstract class "Entitiy" that would implement methods such as "Update(), Delete(), Create(), Duplicate()..." and a seconde one "EntitiesList" that would implement methods such as "GetListWithFilterAndOrder()".
So each time a new concept would appear I would only configure, once for all, the SQL tables, fields... And it would be immediately easily used in some datagrid or editing forms...
See my point?
So what I am asking is a good way to do that. Is it a good idea? I am missing something not using some DataApdater that more or less implements these kinds of methods...?
Well I need to learn from your experience!!
Thank you for answering,