Click here to Skip to main content
15,881,812 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Guys,

I have been browsing this site for a number of years now for articles, advice and code snippets, with great interest in the expertise displayed, never actually posting any questions until now.

I have been coding for a number of years now using procedural code, with breif interludes of OOP attempts, but due to speed necessity being drawn back into procedural to get the jobs done. After much pain I feel I may have come to a point where I can finally move the code forward into a real Object oriented design application. BUT now I feel a bit overloaded by where to start and how to go about it.


I would love some advice as to where\what to look at, design patterns? n-tier design? entity framework? Peta Poco?... the list seems endless.

I know I will make many mistakes as I have done many a time before, but I am just looking for at least a good start point, as this is a huge project that can be ever changing from outside influences.

I will be using visual studio 2010 (VB.net) I will be manipulating data taken from spreadsheets into both MS Access(moving to MS SQL) and XML(i have been using LinQ of late to manipulate the XML currently with the VB.Net environment)

Thanks guys, any help appreciated, particularly if you can point me towards some decent books or ideally online tutorials.
Posted

1 solution

The first step would be to identify procedures performing related tasks.

Like gathering all the functions you are using to say,
1. reading spreadsheets,
2. functions which are used to open as MS access db file or an XML file and dump relevant data.

Once you done this, then try grouping these related functions into classes with meanigful names like SpreadSheetReader, MSAcessSerializer, XMLSerializer etc ...

Now in the executing module all you have to do is to create objects to these classes in an orderly fashion and invoke relevant methods one-by-one.

Once you are sure of achieving the functionality then you can go for performance improvement

The trick is to map operations into objects and establishing the necessary interactions between them
 
Share this answer
 
Comments
Member 4029130 13-Apr-12 13:20pm    
Thanks Lakamraju for your response, I know in theory what I should be attempting to do and have done some of the code in some way, not the correct way I feel, however I have been reading abotu the seperation of data & logic from interface and vice versa, therefore I was hoping forspecific direction i.e what route to focus on.

Thanks again for the response. I will take on board what you have said and move forward accordingly.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900