Solved

Don't TableAdapters run on the client side of an ASPX app?

Posted on 2011-09-12
7
253 Views
Last Modified: 2012-05-12
I'm looking at an app with tableadapters as the primary use for hitting the SQL database.

Don't these run on the client side?
0
Comment
Question by:TimSweet220
  • 3
  • 2
  • 2
7 Comments
 
LVL 75

Accepted Solution

by:
käµfm³d   👽 earned 500 total points
ID: 36523274
Don't these run on the client side?
No.
0
 

Author Closing Comment

by:TimSweet220
ID: 36523394
Thank you.
0
 
LVL 42

Expert Comment

by:dqmq
ID: 36523712
I disagree. In the client-server equation, the Table Adapter is a client side object.   By that I mean it exists on the client and contains code to access data on the server.  While both client and server participate in the "running" (that is the nature of client-server, after all) the table adapter is really a client-side object.  The database server knows nothing about it.

Take care not to equate "client" with "workstation" or "browser".

What may be confusing is that table adapters very often run in a middle tier, as in an ASP configuration.  So, you have a workstation which is a client to the internet server which is in turn a client to the database server.  In other words, the table adapter "lives" in a space that is both a server and a client.  However, it's role is that of a client: issuing requests that are served by the dbms.
 
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 36523953
@dqmq

I read the question as "does a TableAdapter run on the end-user's machine?" The answer to that question is, "no, they run on the server hosting the web application." If, however, you take the DB to be the server and the web server to be the client (in a client-server scenario), then I agree, the TableAdapter runs on the client.
0
 

Author Comment

by:TimSweet220
ID: 36523978
So would it be faster to call a proc or use a data access layer instead of multiple calls via table adapters?
0
 
LVL 42

Expert Comment

by:dqmq
ID: 36524004
I suspected as much and just wanted to clarify that point of confusion.  In a Windows application (as opposed to an ASP page) the Table Adapter very much runs on the end-user workstation.
0
 
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 36524022
I think many people found a few tutorials regarding how to access databases and the majority made reference to TableAdapters and typed DataSets. This, it seems to me, led many to believe that you must use a TableAdapter to gather data from a DB. In my opinion, if you're not going to use typed DataSets, then using a TableAdapter is overkill. It depends on how you structure your app.

So would it be faster to call a proc or use a data access layer
I suppose it depends on how you structured your queries and how involved your objects are.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
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.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

12 Experts available now in Live!

Get 1:1 Help Now