T-SQL - Architecture question

Posted on 2011-10-14
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 59

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now