-
DB Access/Manipulation Module
So I am using Visual Studio .NET 2005. I have implemented a database in SQL Server 2005. The database has multiple tables employing normalization techniques. I have Views and Stored Procedures. I will be creating tools that will read, insert and update records into the database using the Views and SPs. My question is this, what would you recommend for a software architecture?
On first thought, I am exploring creating a C# Windows Service that will be a proxy in between the front-end C# utilities and DB. I sort of hit some complexity in terms of how to return data from Windows Service to Windows Application. In no way am I stuck on this particular design. Please suggest an alternate design if you think it is better. I am guessing that many players on DevX have had a similar scenario in which they are implementing a system that has a DB requiring data access/manipulation.
My current functional implementation involves giving the front-end utilities access to DB. That is undesirable as DB code will have to be maintained in multiple tools. Second, tools will most likely run on a remote system. I prefer to have DB code centralized and localized into one component that front-end tools can communicate with.
I look forward to receiving your input.
Similar Threads
-
By Steve36445 in forum .NET
Replies: 4
Last Post: 03-26-2009, 08:46 AM
-
By HockeyZ39 in forum C++
Replies: 0
Last Post: 10-23-2007, 10:34 AM
-
By Rbot in forum VB Classic
Replies: 3
Last Post: 01-15-2007, 02:13 PM
-
By Leopardfist in forum .NET
Replies: 0
Last Post: 12-23-2006, 09:28 PM
-
Replies: 2
Last Post: 04-02-2002, 03:21 PM
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|