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?
