Smart Client Data

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...

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...

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...