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

Case sensitive or not sensitive

In a Dataset, case sensitive seems only apply to the data not to the schema Within a dataset, table and column names are by default case-insensitive — that is, a table in a dataset called “Customers” can also be referred to as “customers.” This matches the naming conventions in many databases, including the default behavior…

3