. MS SQL express as backend database . Visual Studio as developing tool to implement business logic and user interface . Visual Foxpro as reporting tool to query the database and write reports . This is a multi-user environmentIs there any problem with the following architectural design that I am thinking about?:
. Create a class library (DLL) project for business logic in C#; This DLL will be responsible for creating a connection to, querying from, updating to and deleting records from, the database in SQL. . Create a second project (exe) for user interface using Win Forms in C#. This will reference the business logic DLL for data access and will accept inputs from the user and update the user's screen appropriately. . Create a project in VFP 9 which will be used purly for querying the database and running reports.Is there a better approach?
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature