Anders Hesselbom

Tag: Data access

Inserting a value in an identity column
2010-05-25

In SQL Server 2008, when a column is set to auto increment (Identity Specification), you are normally not allowed to give that column a value. If you are copying data from one database to another in Visual Basic, perhaps by loading a DataSet object u [...]

Getting the meta data for a table from Visual Basic
2010-01-05

The last time I did this, I needed to build a custom Visual Basic entity generator. After two hours of coding, I had a tiny Windows Forms application that took some connection information and a table name, and returned an entity class with some prope [...]