Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are many ways to connect to databases in .NET. You've of course found one of them and it will work just fine.</p> <p>There are three main schools of thought that I've seen 1st hand and really experienced regarding .NET data connections:</p> <ol> <li><p>The first is a more "wizardy" approach to coding that involves adding a connection object to your form, and then using the table bindings and such to "wizard" your form into submission. This is generally efficient on the client machine since .NET pre-optimizes a lot of it if its done through its binding and wizard functions. However, depending on what you are doing it could introduce a bit more network traffic. Also, sometimes the wizards do not do exactly what you want, and relying on wizards can sometimes introduce hours of googling to figure out why the wizard isn't doing what you want it to.</p></li> <li><p>The second (and my preferred way) is writing back-end code to pull down datasets and then display them in your software. This is I believe what your posted code is doing. I believe that it gives you the best flexibility with the data while still allowing you to do some binding and wizardy coding. This is usually less efficient on the client than option 1 since DataSets can be passed byVal on accident sometimes and cannot be quite as pre-optimized as the wizardy approach can. It generally means less network traffic though because your queries will be more subsinct and in theory should be called less often because you can call the data out, store it, and reuse it elsewhere. Also, there is something to be said about the speed at which you can code in this manner as well. I also find it easier if you don't know much about SQL string formatting and the like (which may be why we use this in the office for some of the other guys). Also, datasets require disposing so that they will be removed from memory.</p></li> <li><p>The third method for data connection that I've seen was an entire class built around reading in datarows from a datareader object. Upon doing some research on <a href="http://aspnet.4guysfromrolla.com/demos/printPage.aspx?path=/articles/050405-1.aspx" rel="nofollow noreferrer">datareaders vs dataConnections and datasets</a>, I've discovered that the datareader approach can be up to 10 times faster than datarow connections and they use far less memory and resources. You can also choose to truncate your result set by just not reading in more rows if you've gotten enough data or found what you were after (which should be done with a "TOP" or "WHERE" clause anyway). However, the drawbacks are the following: </p> <ul> <li>Harder to code since you will have arrays of datarows instead of neat datasets</li> <li>Cannot use wizards for the most part (some still compatible with datarow arrays)</li> <li>I think it would be safe to say most beginning coders would look at it and say "wtf happened here?"</li> <li>More network traffic.</li> <li>Sequential access only.</li> </ul></li> </ol> <p>These are simply my observations. I would research any of the methods before choosing one of these. Also don't forget about things like cacheing to prevent round trips to the server as much as possible, but make sure not to cache anything that will change while the program is running (from an external source). Don't forget about multithreading and connection pools and the like. They are all very important features to keep in mind for any data access class.</p>
    singulars
    1. This table or related slice is empty.
    1. POConnecting to a Database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJrud
    1. USJrud
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POConnecting to a Database
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload