473,379 Members | 1,373 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

Need Clarification - Approaches to Database Querying

As I continue to read more about the benefits of database querying using
ADO.NET, I am having a more difficult time distinguishing what the best
approach to data retrieval is anymore.

When creating datasets in the Visual Studio.NET designer, Command objects
(Update, Insert, Delete) are automatically generated for you based off your
SelectCommand value. You then get the benefits of strong typing, which from
what I've seen so far are helpful in a limited sense - perhaps I've not seen
enough of it to give an accurate assessment, but the main benefit seems only
to be within codebehind (read: Intellisense) in VS.NET... but I digress.

It seems that creating datasets in the designer is of benefit for simple
queries (at least thats what the examples that I've read have led me to
believe). If you want to query using stored procedures or views, the benefit
of the Command objects are lost. But you have far greater flexibility in
your queries.

Now, lets assume that I want the Command object benefits, and instead
perform queries on datasets (versus using stored procs), using DataRelation,
DataTable, and DataView objects. I just do all my joins on the in memory
tables and boom - same results as a stored procedure. Keep these tables in
cache, and at the end of the day (or whenever is appropriate), commit
changes to the datasource.

Which is the "preferred" method? It seems very unwieldy, especially for the
enterprise, if you have tables with several million rows (I imagine the
tranasctional management nightmare scenario), put them in cache, let users
make modifications, then validate all the changes prior to updating the
datasource. Is it possible to get the benefits of the Command objects while
still using stored procs?

From a slightly confused reader ;)
Thanks


Jul 21 '05 #1
2 1383
Elliot,

I dont like to tell about prefered methods, when there was a prefered
method, than there would probably be no alternatives.

However this sentence of you did make me shudder.
Keep these tables in cache, and at the end of the day (or whenever is
appropriate), commit
changes to the datasource.

What you do if your computer get a power down or whatever, read your IIS log
to check what people have connected.

I think that as soon that you have a commited change of data, that you than
should update it to your database.

However just my thought,

Cor
Jul 21 '05 #2
Cor:

I agree. And I'm not suggesting that this is the right answer. I am just
trying to feel out a somewhat new technology by posing some "what if" type
questions.

Thanks.
"Cor Ligthert" <no************@planet.nl> wrote in message
news:eZ**************@TK2MSFTNGP10.phx.gbl...
Elliot,

I dont like to tell about prefered methods, when there was a prefered
method, than there would probably be no alternatives.

However this sentence of you did make me shudder.
Keep these tables in cache, and at the end of the day (or whenever is
appropriate), commit
changes to the datasource.
What you do if your computer get a power down or whatever, read your IIS

log to check what people have connected.

I think that as soon that you have a commited change of data, that you than should update it to your database.

However just my thought,

Cor

Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Andy J | last post by:
Hi Everyone NEW USER Q. I am trying to restore a database backup image to another machine. Both machines are installed with same DB2 7.2 installation package. Version: 7, Release: 2,...
8
by: Bill | last post by:
Hello out there; This may be a challenge but I'm certain it's possible but I can't seem to figure out how. I have a table that has several date fields, e.g., Date1, Date2, Date3, Date4 ......
8
by: Sai Kit Tong | last post by:
In the article, the description for "Modiy DLL That Contains Consumers That Use Managed Code and DLL Exports or Managed Entry Points" suggests the creation of the class ManagedWrapper. If I...
0
by: roiavidan | last post by:
Hi, I'm having a bit of a problem with a small application I wrote in C#, which uses an Access database (mdb file) for storing financial data. After looking for a similiar topic and failing to...
2
by: Elliot Rodriguez | last post by:
As I continue to read more about the benefits of database querying using ADO.NET, I am having a more difficult time distinguishing what the best approach to data retrieval is anymore. When...
3
by: RC | last post by:
Dear Dudes, I post this in multiple groups for opening brain storm. Sometime I need to query the data from database server then display them into user's browser in HTML <table>. But if the...
6
by: No Spam Man | last post by:
Hi, I am not a programmer and in the past have only created very simple, flat file databases. Although I'm a newbie, I think I could probably figure out basic Boolean logic and financial...
2
by: Sue | last post by:
Hi, we are thinking of installing sql server as a backend to our website. Q.1. What is the best way to do this - should we host the database on the same IIS server where the website is hosted,...
7
by: Jelle de Jong | last post by:
Hi, I want to start a new project, I want to build my own database server and start very simple. I want to create a file-based database server, with XML-files. Does anyone know a good site or...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.