Hello All
I am relatively new to C# and also database programming in general. I thought that the best way to get off the ground would be to write a small database application.
I want to try and write a small database application that manages the following aspects of a small business.
1.) Quoting
2.) Invoicing
3.) Debtors
4.) Contacts
The business is a serviced based business so there is no need for stock management etc.
I want to try and use MySql and C# express 2010.
The concept of how the database tables should be structured and related etc, is not a problem. The main problem is how to model the problem in C#. IOW Can anyone give me some advice as to how to what the class hierarchy should look like.
I am thinking that there will be one base class that manages the database connection and all transactions. This could be an abstract class or maybe an interface (although I am not sure I have the concept of interfaces down just yet). All other classes (one for debtors, one for invoices etc, etc.) will inherit from this base class.
Is this a workable solution or does anyone have a correct / better suggestion.
Any advice on some reading material would also be much appreciated.
Thanks in advance
Rob