I am planning on writing a small home budget application for myself, as a learning excercise. I have built my database (SQL Server), and written a small console application to interact with it, and test out scenarios on my database. Once I am happy, my next step would be to start building the application - but I am already wondering what the best/standard design would be. I am palnning on using Entity Framework for handling my database entities... then linq to sql/objects for getting the data, all running under a WinForms (for now) application.
My plan (I've never used EF... and most of my development background is Web apps) is to have my database... with Entity Framework in it's own
project.. which has the connection to the database. This
project would expose methods such as 'GetAccount()', 'GetAccount(int accountId)' etc.
I'd then have a service
project that references my EF
project. And on top of that, my GUI
project, which makes the calls to my service
project. But I am stuck.
Lets say I have a screen that displays a list of Account types (Debit, Credit, Loan...). Once I have selected one, the next drop down shows a list of accounts I have that suite that account type.
So, my OnChange event on my DropDown on the account type control will make a call to the serviceLayer
project, 'GetAccountTypes()', and I would expect back a List< of Account Types. However, the AccountType object ... what is that? That can't be the AccountType object from my EF
project, as my GUI
project doesn't have reference to it. Would I have to have some sort of Shared
Library, shared between my GUI and my Service
project, with a custom built AccountType object? The GUI can then expect back a list of these. So my service layer would have a method:
public List<AccountType> GetAccountTypes()
That would then make a call to a custom method in my EF
project, which would probably be the same as the above method, except, it returns an list of EF.Data.AccountType (The Entity Framework generated Account Type object). The method would then have the linq code to get the data as I want it.
Then my service layer will get that object, and transform it unto my custom AccountType object, and return it to the GUI.
Does that sound at all like a good plan?
