StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This isn't really going to anwer your question, because its a bit too vague to give any concrete advice, but I would suggest you have a look at the ADO.NET Entity Framework. Using Entity Framework, you can have classes that contain objects from other tables. For example (I'm guessing your data strunctures here...)</p> <pre><code>public class Pokemon { int Id {get; set;} ICollection<PokeAbility> Abilities {get; set;} ICollection<PokeType> Types {get; set;} } </code></pre> <p>In Entity framework, you define a data context class, like this:</p> <pre><code> public PokeContext : DbContext { DbSet<Pokemon> Kanto {get;set;} DbSet<PokeAbility> Abilies {get; set;} DbSet<PokeType> Types {get; set;} } </code></pre> <p>In your program then, once you have a Pokemon object, you can just access the data from the other tables like so:</p> <pre><code>var context = new PokeContext(); Pokemon instance = context.Kanto.First(); // Fetch first item from the Kanto table in the database foreach (var ability in instance.Abilities) { Console.WriteLine(ability); // Or whatever you want to do with it. } </code></pre> <p>I would suggest you have a look at some of the streaming videos that Microsoft has released with Visual Studio 2012, for example, this one:<br> <a href="http://msdn.microsoft.com/en-us/data/jj193542" rel="nofollow">http://msdn.microsoft.com/en-us/data/jj193542</a><br> There is a whole bunch of resources here:<br> <a href="http://msdn.microsoft.com/en-us/data/aa937723" rel="nofollow">http://msdn.microsoft.com/en-us/data/aa937723</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

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