Relation Dialog: Relation Only, or with Foreign Key Constraint?

Using the Relation Dialog, you are asked to choose Relation Only, Foreign Key Constraint Only, or Both.  Which is the right choice?  “Relation Only” makes available the tables related to the table that you are working with.  This means that if you are working with, for example, both a Customers table with CustomerID as primary…

1

VSLive San Francisco Presentations

At VSLive I presented two sessions.  One for Occasionally Connected Smart Clients and another on Advancements in Data Access.   The Occasionally Connected Smart Client session focused on what we’re working on post VS 2005.  Some of which should be in Orcas, some of which will follow afterwards.  Mostly the session was about providing an overview…

7

Embedding SQL Server Express into Custom Applications

Rob Walters, from the SQL Team, and I worked on an article for working with SQL Express in Windows Forms applications.  There are a couple of quirks when it comes to Click Once that have been included in this MSDN article. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp Steve

2

Building SQL manually considered harmful

I just got done fixing a painful bug. The long and short of it is that I had code like this (simplified a lot for brevity): Public Sub StoreSyncDate() Dim sql As String = “insert into SyncTimes (ObjectID, SyncDate) values ({0}, ‘{1}’)” sql = String.Format(sql, Me.ID, DateTime.Now) Me.Executequery(sql) End Sub On my machine, sql gets…

3

How do I get to the generated code?

In order to get to the code that is auto-generated by Visual Studio, follow these steps:            1. In the menu, select View -> Solution Explorer            2. In Solution Explorer, click the “Show all Files” icon at the top            3. Expand the file (e.g. Dataset1.xsd) that you want the generated code for             4. Double click on the corresponding Designer file (e.g. Dataset1.Designer.vb) to open…

1

Data Sources window is inactive in Design View

On certain machines, after installing Visual Studio 2005, the contents of the Data Sources window disappears when a design surface that allows drag and drop from the Data Sources window is active. For example, the Windows Forms designer, User Control Designer, etc… The cause of this issue is how VS processes the list of associated…

14

Installing Northwind on SqlExpress

When performing a default install of Visual Studio 2005 an instance of Sql Server Express edition is installed. Unfortunately there are no sample databases included with Sql Express. (http://lab.msdn.microsoft.com/express/sql/) I’ve had more than a few people ask how to get the Northwind sample database loaded into Sql Express so here are some step-by-step directions for getting Northwind up…


Returning the identity column value from a TableAdapter DBDirect method

A common scenario when using tables with an auto-increment primary key is to get the value of the identity column for the row you just inserted. Sometimes you can’t, or don’t want to, use DataSets, which is why we created the DBDirect methods on the TableAdapter. However, the default INSERT function doesn’t return the primary…

4

Why is my column named _Region in the Typed DataSet?

One quirk you’ll find when making a typed DataSet with a column or table named “Region” is that the generated code produces a property called “_Region”.What’s up with that? If you read Raymond Chen’s blog, you already have a pretty good guess: Backward compatability.In previous versions of Visual Studio, we did the same thing. Why…

2