SqlDataSource performance

Mike

Is there any difference in performance between a SqlDataSource and an
ObjectDataSourc e - assuming they are being deployed to perform the same task
against a SQL Server database?

Mike

Dec 13 '06 #1

Subscribe Reply

4615

Mike

"Mike" <xx*@xxx.xxxwro te in message
news:e7******** ********@TK2MSF TNGP03.phx.gbl. ..

Is there any difference in performance between a SqlDataSource and an
ObjectDataSourc e - assuming they are being deployed to perform the same
task against a SQL Server database?

Ok. More specifically, will the use of the SqlDataSource in itself lead to
scalability issues at some stage that the ObjectDataSourc e wouldn't?

Mike

Dec 14 '06 #2

Mike

"Mike" <di*********@mi crosoft.comwrot e in message
news:u2******** ******@TK2MSFTN GP04.phx.gbl...

>
"Mike" <xx*@xxx.xxxwro te in message
news:e7******** ********@TK2MSF TNGP03.phx.gbl. ..
>Is there any difference in performance between a SqlDataSource and an
ObjectDataSour ce - assuming they are being deployed to perform the same
task against a SQL Server database?

Ok. More specifically, will the use of the SqlDataSource in itself lead
to scalability issues at some stage that the ObjectDataSourc e wouldn't?

Have I posted these questions to the wrong group? Is there a more
appropriate group I should try?

Mike

Dec 14 '06 #3

raghav

Hi Mike

Following are differences between SqlDataSource and ObjectDataSourc e:
1. SqlDataSource is two-tier in nature where as ObjectDataSourc e
supports three-tier architecture.
2. SqlDataSource requires very small amount of coding to connect with
database. For ObjectDataSourc e more coding is required to build data
access class.
3. SqlDataSource not support full encapsulation. ObjectDataSourc e
supports full encapsulation.
4. SqlDataSource requires complete connection string to connect with
database. ObjectDataSourc e exposes TypeName attribute that is a name of
middle layer class may used to perform database related operations.
Data access class must be placed in App_Code directory.
5. Caching is same for both controls but ObjectDataSourc e control fires
NotSupported exception if return type of SelectMethod is other than
DataSet.
--Raghav
Mike wrote:

Is there any difference in performance between a SqlDataSource and an
ObjectDataSourc e - assuming they are being deployed to perform the same task
against a SQL Server database?

Mike

Dec 15 '06 #4

Mike

Thanks for the info, but it doesn't really answer my question. Unless
that's a complete list of the differences, in which case, I guess, in the
absence of any mention of performance, there isn't any difference between
the two.

"raghav" <ma********@gma il.comwrote in message
news:11******** **************@ 80g2000cwy.goog legroups.com...

Hi Mike

Following are differences between SqlDataSource and ObjectDataSourc e:
1. SqlDataSource is two-tier in nature where as ObjectDataSourc e
supports three-tier architecture.
2. SqlDataSource requires very small amount of coding to connect with
database. For ObjectDataSourc e more coding is required to build data
access class.
3. SqlDataSource not support full encapsulation. ObjectDataSourc e
supports full encapsulation.
4. SqlDataSource requires complete connection string to connect with
database. ObjectDataSourc e exposes TypeName attribute that is a name of
middle layer class may used to perform database related operations.
Data access class must be placed in App_Code directory.
5. Caching is same for both controls but ObjectDataSourc e control fires
NotSupported exception if return type of SelectMethod is other than
DataSet.
--Raghav
Mike wrote:
>Is there any difference in performance between a SqlDataSource and an
ObjectDataSour ce - assuming they are being deployed to perform the same
task
against a SQL Server database?

Mike

Dec 15 '06 #5

Similar topics

1485

You’re Opinion on SQLDatasource Performance?

by: artificer | last post by:

I want to develop a web application that will manage the online registration and class schedule selection process for a small university in the Caribbean. The application should support around 50 simultaneous users to begin with and if the application becomes successful maybe it will grow up to 500 simultaneous users. The application will have an interface very similar to the one on the timetraker starter kit. The logic of the...

ASP.NET

4480

Modify SqlDataSource parameters before select

by: Martin Bischoff | last post by:

Hi, is it possible to modify the values of a SqlDataSource's select parameters in the code behind before the select command is executed? Example: I have an SqlDataSource with a ControlParameter <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:XYZ %>"

ASP.NET

5039

Optimistic concurrency in custom GridView/SqlDataSource

by: Mike Kelly | last post by:

I've chosen to implement the "optimistic concurrency" model in my application. To assist in that, I've added a ROWVERSION (TIMESTAMP) column to my main tables. I read the value of the column in my select, remember it, and then use it in the update. It works just fine when I have full control of the whole process. I want to do the same for my GridView/SqlDataSource combinations. I typically select from a view and update the corresponding...

ASP.NET

6514

GridView - Changing FilterExpression of SQLDataSource and Paging

by: Henry Habermacher [MVP Access] | last post by:

Environment: VS2005, ASP.Net 2.0, SQLServer 2000, VB.Net, IIS6 I use a GridView Control which is based on a SQLDataSource. The datasource is based on a Select statement and is filtered by the FilterExpression. The GridView also has a pager element (below, displaying first, previous, next, last icons), paging is enabled, page contains 10 rows. The user now skips some pages by clicking a view times on the next icon. Now he changes the...

ASP.NET

1791

Binding multiple CheckBoxList controls to one sqlDataSource

by: Nam | last post by:

I want to use the same sqlDataSource for two CheckBoxList controls in ASP.NET 2.0. For simplicity, I am using the case of only two CheckBoxList controls in the following example: My sqlDataSource is bound to a table in my database. The table has four columns, say, col1_ID, col1_value and col2_ID, col2_value. The DataValueField and DataTextField values for CheckBoxList1 are bound to col1_ID and col1_value respectively. And, for...

C# / C Sharp

7688

Using SqlDataSource with MySQL

by: msch-prv | last post by:

Hi, I am trying to tie a SQLDataSource control to MySQL without success. The connection string works ok with an ObjectDataSource. (Native asp.net 2.0 MySQL dll loaded in /bin) For some reason, the compiler believes an SQL db is being accessed ("An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does...

ASP.NET

1998

to sqlDataSource or not - scenario

by: djc | last post by:

1) I am wondering if I should be using an sqlDataSource object for my particular scenario. I need to loop through a listbox and perform an INSERT sql operation for each item. Could be a few or several items. The reason I'm wondering if I should use an SqlDataSource object is overhead. For example, prior to learning about the sqlDataSource I would just code the ado.net procedure myself. For example, create connection object, create and...

ASP.NET

14422

gridview and sqldatasource - refresh the gridview

by: phil | last post by:

I have an ASP.NET application with an SQLdataSource and a Gridview Everything works very well except I have a 'Button' that goes off and changes some of the record data back in the underlying database records. When I press this the data is definitely changed in the database - but on screen nothing seems to happen. So how do I force the page to reload the records from the database and populate the gridview.

ASP.NET

7060

sqldatasource filterexpression - Cannot find column

by: jobs | last post by:

Cannot find column . Am I missing something here... SelectCommand="SELECT , , , refid FROM " FilterExpression="phone_nbr like @phone_nbr + '%'"

ASP.NET

8987

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9534

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9366

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9241

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6793

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4597

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4867

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2777

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2211

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General