T-SQL - Architecture question

Posted on 2011-10-14
Medium Priority
Last Modified: 2012-05-12
just started working in this environment. There is one SQL Server (2005) and there are about 20 client databases on that server (they're all same version and identical structure).

I am asked to program websites for those clients and I see it's many times the same query I write (text query in VS2008 since I don't have access to the client databases and can use no sprocs or views to each individual database).

What would be some of the options I have to create an "in between" layer. Not sure what the terminology is here. Just trying to get some feedback for some idea's.

Question by:conrad2010
1 Comment
LVL 60

Accepted Solution

Kevin Cross earned 2000 total points
ID: 36971134
You could create a Library project that contains the Data Access Layer. For .NET, there is now LINQ-To-SQL that is popular to use. But main thing here is you are actually wanting to plug and play the queries and just have each project specify its database connection string separately. Just my $0.02 at least.

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question