Databases
StackOverflow2013
Usersdbo
USdallin
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USdallin
    primarykey
    data
    text
    plurals
    1. POAttach a variable to an HTML element?
      singulars
      1. PTQuestion
    2. POsession_start() returns "No such file or directory" directly after creating the session file
      singulars
      1. PTQuestion
    3. POFastest way to find out if an array of search terms includes a string also in my content?
      singulars
      1. PTQuestion
    1. POBest way to connect to a MySQL database in a Silverlight project
      singulars
      1. PTQuestion
    2. POVB.Net Silverlight project and MySQL
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COThank you! Yeah, I realize a lot of questions... probably a mistake. I thought 1-5 were almost the same question so it was ok. I tacked on 6 at the last second. But I think from how you've illuminated things that I'm not going to go with .NET for the back end simply because I can't guarantee customers will have Windows and IIS instead of Linux and Apache. That makes things a lot simpler as I can go back to PHP. Thanks!
      singulars
      1. PO
      1. USdallin
    2. COIt applies because it's a Silverlight project. Perhaps it would have been better if I just said .NET or VB.NET? I'm sorry, I'm new to Silverlight and .NET. I wasn't sure if Silverlight had a better method for database connections than a plain VB.NET project. As for code, I'll paste how I've gotten the data from LINQ and Entity SQL but what I'm really hoping for is some guidance on the best way to do this period - am I on the right track? If so, is there an easy way to convert the data to what I need?
      singulars
      1. POBest way to connect to a MySQL database in a Silverlight project
      1. USdallin
    3. COThanks Kenneth! This is EXACTLY what I was looking for! After investigating CDC, I actually found out SQL Server 2008 has two solutions for this - Change Data Capture and Change Tracking. Change Tracking does the same thing but is more light weight, is included in SQL Server Express, but lacks a historical record of the data before it was changed. Both solutions are new in SQL Server 2008, and a custom solution is required before that. I appreciate your answer!
      singulars
      1. PO
      1. USdallin
 

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