Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Ok, I'm extrapolating based on limited data, but the fact that you are asking between a list of structs and a dataset implies to me that you're somewhat new to C# and have not been introduced to the fact that a struct is a <a href="http://msdn.microsoft.com/en-us/library/system.valuetype.aspx" rel="nofollow noreferrer">ValueType</a> and therefore lives on the stack. You have probably heard that a struct grants you "better performance" somewhere, and want to get the best performance you can for your list of 8000 items.</p> <p>First, I believe that you are prematurely optimizing. Don't. Do whatever works within the scope of your program. If you are building this list of 8000 items yourself programmatically, perhaps from an XML or flat file, I'd suggest you use a list of <strong><em>objects</em></strong>, as that will be the easiest for you to program against. Your post does not imply that you have a relationship between two tabular sets of data, so a DataSet would be unnecessary.</p> <p>That said, if you are receiving that list from the database somehow, and your current data layer is ADO.NET 2.0 (and therefore returns DataSets and DataTables), then I'd say use that. If you are receiving the list from the database but your data layer is not yet defined, I would suggest you look into <a href="http://msdn.microsoft.com/en-us/library/bb386976.aspx" rel="nofollow noreferrer">LINQ to SQL</a> or <a href="http://msdn.microsoft.com/en-us/library/aa697427(VS.80).aspx" rel="nofollow noreferrer">Entity Framework</a>. </p> <p>Again, I caution you against prematurely optimizing, especially given that you don't appear to understand how structs work. Again this is an assumption and I apologize in advance if I am wrong.</p>
    singulars
    1. This table or related slice is empty.
    1. POList of Structs or Dataset in C#?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USRandolpho
    1. USRandolpho
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. VTUpMod
    1. CO+1 - Nicely stated
      singulars
      1. PO
      1. USMark Brittingham
    2. COSorry when I was talking about performance I did not really mean optimization. I was more curious if there were reasons not to use a generic list of a struct over a dataset. Thinking there is a large overhead using a dataset.
      singulars
      1. PO
      1. USghost
    3. COThough after reading up on stack vs heap again it makes perfect sence I should have been asking about a generic list of classes vs dataset.
      singulars
      1. PO
      1. USghost
 

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